Time to testing SQL 2016 new features
1. Download SQL 2016 CTP3 3.2 with evaluation version
https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
2. Setup Hyper-V
http://soonyu-sql.blogspot.my/2012/12/70-462-virtual-server-preparation.html
3. Install SQL 2016 in Virtual Server
4. download SQL 2016 testing database and database
https://msftdbprodsamples.codeplex.com/releases/view/618193
5. Restore AdventureWorks2016CTP3 database
Download file (AdventureWorks2016CTP3.bak & AdventureWorksDW2016CTP3.bak) from
step 4
6. Going to test the below features with the demo script from step 4
Always Encrypted
Clustered Columnstore Index
Data Masking
In-Memory OLTP
JSON
PolyBase
Row-Level Security
Query Store
Stretch DB
Temporal Tables
No comments:
Post a Comment