Monday, October 03, 2016

Introducing SQL Server 2016

Introducing Microsoft SQL Server 2016 – get your free ebook today
"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. ... ebook introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancements, and R integration.

Free ebook: Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2 – Microsoft Press blog

SQL Server 2016: Get started with Columnstore for real time operational analytics
real-time operational analytics overview

Combined indexes for warm and hot data