SQL Server Best Practices – Ayoka Lunch n’ Learn Series

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.

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.

One of the flagship features in SQL Server 2005 is the ability to write stored procedures using any language supported in .NET. This feature provides greater flexibility for developers to…