About once a month or so, us developers here at Ayoka like to get together over lunch to discuss various software development topics in a series we call Ayoka Lunch n’ Learn. This month our resident SQL Server expert, Steve Chang discussed SQL Server best practices. You can check out the the four part video series below. You can also download the complete PowerPoint presentation here: SQL Server Best Practices – Ayoka Lunch n’ Learn.
You Might Also Like
Introduction to SQL Server 2016 CTP2
- Post published:August 11, 2015
SQL Server 2016 Community Technology Preview 2.2 (CTP2) has been released for evaluation and trial use by Microsoft. It features highly-anticipated improvements to in-memory performance to deliver faster queries from its database engine, deeper enterprise insights through analytics with its analysis services, new always-encrypted security technology, and new hybrid cloud support.
Introduction to Temporal Tables
- Post published:August 4, 2015
Microsoft has recently released SQL Server 2016 as Community Technology Preview 2 (CTP2) and utilizes temporal tables to simplify the process of auditing records and restoring tables by retrieving its temporal history data. Creating new temporal table schemas and scaling existing database schemas to the new system-versioned architecture prove to optimize processing speeds and add an extra layer of security to tables in the database.
Querying Temporal Tables
- Post published:August 6, 2015
In software performance optimization, real data sources are dynamic since business decisions often rely on the insights that can be retrieved at a moment's notice. SQL Server 2016 has given database administrators the ability to utilize temporal tables to bring database insights to decision-makers in both real-time and from the past. These temporal tables, also known as system-versioned or assertion tables, offer the ability to query its data to be tracked as it changes over time to understand changing business trends, improve the process of auditing data as it changes, maintain slowly changing dimensions (SCD), and ease the process of recovering tables from data corruption or loss.