In focus

Migrate To SQL Server 2016

How to upgrade and migrate your existing SQL Server database to SQL Server 2016.

Staff Reporter Mar 10, 2016

SQL Server 2016 is Microsoft’s newest release of its popular database, SQL Server. In this video, Lonny Bastien, Program Manager at Microsoft, gives a brief overview of the new SQL Server 2016 Upgrade Advisor and SQL Server Migration Assistant 7.0. Lonny highlights the new assessment and migration features to support SQL Server 2016 upgrades and foreign platform migrations. 

Benefits of SQL Server 2016 
  • Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk-based relational databases, and real-time operational analytics
  • New "Always Encrypted" technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes. 
  • Built-in advanced analytics provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database 
  • Business insights are possible through rich visualizations on mobile devices with native apps for Windows, iOS, and Android. Simplify management of relational and non-relational data with the ability to query both through standard T-SQL using PolyBase technology. 
  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes. 
  • Faster hybrid backups, high availability,and disaster-recovery scenarios allow you to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure

Staff Reporter
Staff Reporter

This is an official staff reporter account of DbTalks. My job is to bring you the latest happenings in data industry including product launches, events, and innovations.