新しいサンプルデータベース『 WideWorldImporters 』の中身を見てみる - 都内で働くSEの技術的なひとりごと / Technical soliloquy of System Engineer working in Tokyo

　SQL Server のサンプルデータベースといえば、AdventureWorks です。今回、SQL Server 2016 の機能に合わせて WideWorldImporters というサンプルデータベースがリリースされました。
blogs.technet.microsoft.com

Wide World Importers is the new sample for SQL Server. It illustrates how the rich SQL Server feature set can be used in a realistic database. It does not attempt to use every single SQL Server feature, as that would not be realistic. It also showcases the key SQL Server 2016 capabilities and performance enhancements.

　下記の通り、一通りの SQL Server 2016 の機能を見ることができます。

WideWorldImporters is the main database for transaction processing (OLTP – OnLine Transaction Processing) and operational analytics (HTAP – Hybrid Transactional/Analytics Processing). Here are some examples of the use of SQL Server capabilities with this database:

Real-time operational analytics of sales data is enabled through the use of nonclustered columnstore indexes.

Archive tables can be stretched to Azure for long-term retention, reducing storage cost and improving manageability.

Query Store is used to keep track of query performance.

Temporal tables are used to conveniently keep track of the history of reference data, as well as some of the main entities.

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.

Advanced security features like Always Encrypted, Row-Level Security and Dynamic Data Masking are used to secure data.

In-Memory OLTP is used to optimize the performance of table-valued parameters (TVPs) and to optimize ingestion of sensor data.

Clustered columnstore indexes are used to reduce the storage footprint of large tables with insert-only workload.

Partitioning is used to improve the manageability of large tables.

For more detail, see WideWorldImporters use of SQL Server features and capabilities.