SQL server 2016 CTP 2.2

Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are now available for download!

This first look at SQL Server 2016 Upgrade Advisor showcases a new platform for the database upgrade tool.  upgrade advisor  also introduces the Stretch Database Advisor so that customer can identify the which data to make online and use transparent  cold storage of azure.

The Post From SQLserverTeam….

SQL Server 2016 Upgrade Advisor Preview is a standalone tool that enables users of prior versions to find certain breaking and behavior changes as well as deprecated features in the database engine.  Upgrade Advisor Preview also helps with the adoption of Stretch Database by analyzing existing database tables for fit with the new functionality based on criteria that the user selects, using the Stretch Database Advisor. Future releases will include enhancements to the upgrade rules and feature adoption advisors.

The Added features

  • Users are able to add security policies including row-level security to a table that has been stretched to Azure using Stretch Database
  • Master Data Services now allows compound keys, slowly changing dimension (SCD) Type 2, and syncing an entity between models
  • SQL Server Reporting Services (SSRS) will now support two additional chart types, treemap and sunburst

CTP2 will also have improvements to the Query Store, Query Execution, DBCC CHECKCB performance, and Temporal Database.

Grab a copy of SQL Server 2016 CTP 2.2 play with it and explore the possibilities


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s