Monday, January 25, 2016

SQL 2016 CTP3 testing

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