In-Memory OLTP is used to optimize the performance of table-valued parameters (TVPs) and to optimize ingestion of sensor data.Advanced security features like Always Encrypted, Row-Level Security and Dynamic Data Masking are used to secure data.JSON is used to enable AJAX calls to some of the key tables, and also to extend the relational schema to record such things as application settings and user preferences.Temporal tables are used to conveniently keep track of the history of reference data, as well as some of the main entities.Query Store is used to keep track of query performance.
ADVENTUREWORKS DATABASE QUERY EXERCISES ARCHIVE
It also showcases the key SQL Server 2016 capabilities and performance enhancements. It does not attempt to use every single SQL Server feature, as that would not be realistic. It illustrates how the rich SQL Server feature set can be used in a realistic database. Wide World Importers is the new sample for SQL Server. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade. This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server.Ī release the magnitude of SQL Server 2016 deserves a new sample.