SQL Server 2016: Temporal Tables
Jul 14,
2016
System-Versioned Temporal Tables For as long as there have been relational databases, there have been administrators who have needed to maintain a history table of row changes. There are many reasons for this; probably the most common is the requirements for auditing data if a particular row value is brought into question. More recently, there […]
SQL Server 2016 Release: The Good News and the Better News
Jul 6,
2016
The good news is that SQL Server 2016 has been released and is now available. This version has been anticipated with some excitement since it eclipses previous releases in both the number of new features and the improvements and extensions to existing features. The better news, at least to developers like myself, is that Microsoft […]
SQL Server 2016: R Integration Redux
May 12,
2016
SQL Server 2016 has now reached Release Candidate 3 (RC3). One of the new features that continues to foster interest in the analytics and data mining community is the integration of SQL Server with the open-source statistics toolset R. If you fall into this category, I’m inclined to suggest you remain patient and wait for […]
SQL Server 2016: Choosing Your R-Chitecture
May 10,
2016
Enthusiastic data miners are excited about the new possibilities which have opened up with Microsoft R. Not everyone, however, has realized that the so-called “in-database” R is not the best choice for every application of R to SQL Server data. One database administrator expressed concern about R competing with SQL Server for precious RAM. A […]
SQL Server 2016: Query Store Configuration
Feb 17,
2016
Introduction Some of the new features of SQL Server 2016, most notably the Advanced Analytics and Polybase, are unprecedented in earlier versions. In contrast, the Query Store added to SQL Server 2016 doesn’t so much add new features as make the time-honored tasks of query execution monitoring faster, easier, and more convenient. Once turned on […]