Skip to main content
SQL Server 2016

New how-to guide helps to get the most out of SQL Server 2016

Server 2016 is now generally available and brings with it a feature set designed for the modern-day enterprise, in which data can be located in a variety of locations, both on-premises and in the cloud.

To get a taste of the most advanced version of SQL Server yet, download a free trial version of SQL Server 2016. And to help you get the most out of this release, download the SQL Server 2016 e-book, for which we enlisted the help of some of the industry’s leading experts and SQL Server community MVPs.

The e-book contains the following chapters:

Chapter one: Faster queries

Get up to speed on how to perform real-time transactions and ultra-fast analytics using new features like in-memory transaction processing and in-memory updateable column stores.

Chapter two: Better security

Explore three new principal security features in SQL Server 2016—Always Encrypted, Row-Level Security and Dynamic Data Masking, and learn how to use each one of these features to its fullest potential.

Chapter three: Higher availability

Learn how to deploy more robust, highly available data management solutions using the new features in AlwaysOn Availability Group and AlwaysOn Failover Cluster.

Chapter four: Improved database engine

Find out how to optimize query performance, how to take advantage of hybrid cloud architectures, and how to stay in control amidst growing volumes of data.

Chapter five: Broader data access

Discover how SQL Server 2016 can help you manage, maintain, integrate and import data of all types, leading to richer business insights.

Chapter six: More analytics

Learn how to more quickly build secure, advanced analytics solutions, how to create predictive models with R functions, and how to generate better business outcomes by incorporating these models into application and reporting tools.

Chapter seven: Better reporting

Explore the new data visualization and layout options in Reporting Services, and how Mobile BI lets employees easily access business intelligence, whether in the office or on the road.

Chapter eight: Improved Azure SQL Database

Learn more about Microsoft Azure SQL Database and how features such as elastic database pools and rapid development cycles make it a natural complement to your on-premises DB solution.

Chapter nine: Expanding your options with Azure SQL Data Warehouse

Find out how to exponentially increase your data management and analytics capabilities, without the usual overhead.


download the SQL Server 2016 e-book


Frederik De Breuck is better known as Stonyarc (GamerTag). Next to writing and maintaining his personal blog he is the owner of and . He's also Microsoft MVP (Most Valuable Professional) since 2010 and works as Presales Director for Fujitsu Belgium.

Leave a Reply