Introduction to SQL Server 2016 CTP2

Top Notch
In Business

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.

Read More Introduction to SQL Server 2016 CTP2

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.

Read More Querying Temporal Tables

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.

Read More Introduction to Temporal Tables

Invoking Managed Code from SQL Server

  • Post published:September 1, 2009

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…

Read More Invoking Managed Code from SQL Server