There is a new SQL Server 2016 ebook available for free. The preview version of the book, Introducing Microsoft SQL Server 2016, is available for download directly from Microsoft. The final version of the book should be available soon.
With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this preview ebook, by Stacia Varga, Joseph D’Antoni, and Denny Cherry, we introduce you to several of these changes that you can experience for yourself in Community Technology Preview 3.2. We start by introducing three new security features that you can use to protect your data: Always Encrypted, Row-Level Security, and dynamic data masking. Then we describe significant database engine enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database. Last, we review several improvements to Reporting Services, including new data visualizations, support for mobile reports and key performance indicators, and subscription enhancements, to name a few. In each of these areas, we review the key concepts you need to understand before using these features and describe the steps necessary to get started so you can quickly experience the benefits of SQL Server 2016 firsthand.