SentryOne Team Blog (blogs.sentryone.com)

Tag: SQL Server 2016

Pre-Release Builds of SQL Server 2016

We've separated out the now-static info about pre-release SQL Server 2016 builds into its own post, primarily to make maintenance easier and the RTM page lighter.

Slide Decks & Demos from SQLBits

Slide Decks & Demos from SQLBits

Aaron Bertrand (@AaronBertrand) shares his slides and demos from T-SQL and SQL Server 2016 sessions at SQLBits XV in Liverpool, UK.

Slide Decks & Demos from SQLintersection

Aaron Bertrand (@AaronBertrand) shares his slides and demos from his two SQL Server 2016 sessions at SQLintersection in Orlando this week.

Configuring a PolyBase Cluster

David Benoit (@SQLTentMaker) walks through the process of configuring a scale-out PolyBase cluster with SQL Server 2016 and Azure Blob Storage.

What might the SSMS changes mean to you?

After the first Visual Studio 2015-based SSMS build is released, Aaron Bertrand (@AaronBertrand) talks about the changes you'll notice, and the changes you won't (yet).

On telemetry and other data collected by SQL Server

Aaron Bertrand (@AaronBertrand) talks about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.

Performance Surprises and Assumptions : STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.

Management Studio February Preview : An Illustrated Guide

Aaron Bertrand (@AaronBertrand) explains some of the nuances of the latest Management Studio preview, with a visual tour through installation.

The difference a day makes : SSMS 2016, Azure, and Extended Events

Aaron Bertrand (@AaronBertrand) shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.

Delayed Durability while Purging Data

Melissa Connors (@MelikaNoKaOi) investigates using SQL Server's delayed durability feature to improve performance while purging data.

Machine Learning and the Microsoft Data Platform

If you're into data and databases and you have not heard the term "machine learning," may I suggest that you're not reading enough? This technology is hot and hyped, largely because it is the secret ingredient in many successful Big Data projects. READ MORE… Originally Posted January 07, 2016

Preview Support for SQL Server 2016

With the latest build of SQL Sentry software, v9.0.36.0, you will now be able to watch SQL Server 2016 instances. Read on for more details…

Dynamic Data Masking and Row-Level Security Features in SQL Server

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, they'll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server. READ MORE… Originally