Monday, June 13, 2016

New Sample databases for SQL 2016

SQL 2016 is in market for just under two weeks and Microsoft released a new sample databases(WideWorldImporters and WideWorldImportersDW) Those sample database can be used to evaluate the new features of SQL 2016 such as
•    Polybase
•    Query store
•    In-Meomory OLTP
•    Updatable column store index (both clustered and non-clustered)
•    Native JSON support
•    Security (Dynamic data masking, row level security and Always encrypted)
•    Temporal database and tables

There are also few scripts and applicaiton that was released with new sample databases to test out the new features. Enjoy

No comments: