Tag : SQL Server 2016 - SentryOne Team Blog

Tag: SQL Server 2016

The Architecture of Azure Data Platform Applications

The Architecture of Azure Data Platform Applications

Kevin Kline and Ben Lezin hold a short Q & A with Gavin Payne and Mike Wood about Azure architecture and improvements.

Overview of Columnstore Indexes in SQL Server

Overview of Columnstore Indexes in SQL Server

Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

Updated January 18th, 2017 : See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Rob Farley : Estimated Number of Rows to be Read

Rob Farley : Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

Memory Limits in SQL Server 2016 SP1

Memory Limits in SQL Server 2016 SP1

Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

Caribbean SQL Cruise 2017

Caribbean SQL Cruise 2017

Kevin Kline (@kekline) talks about the benefits of unique training events like SQL Cruise, and his upcoming voyage in 2017.

A Big Deal : SQL Server 2016 Service Pack 1

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change to SQL Server 2016 in Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

Slides and Demos from SQLintersection

Slides and Demos from SQLintersection

Aaron Bertrand shares his slides and demos from presentations at SQLintersection in Las Vegas.

Dynamic Data Masking : My Thoughts

Recently I have been exploring Dynamic Data Masking, looking at ways that it can be used and I thought I would share my thoughts with you.

Rob Farley : AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.

Where do I get SQL Server 2016 Developer Edition?

Aaron Bertrand (@AaronBertrand) shows a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.

Slides and Demos from Discovery Day New England

Today I presented at Discovery Day New England, a SQL Server 2016 event (sponsored in part by SQL Sentry) held at the Microsoft office in Cambridge, MA. Attached are demos and slide decks.

Stretch Database in SQL Server 2016 RTM

Tim Radney (@tradney) of SQLskills shows us how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.

T-SQL Tuesday #079 : It’s 2016!

Lori Edwards (@loriedwards) gives us a quick introduction to a new SQL Server 2016 feature, Temporal Tables, as a part of this month's T-SQL Tuesday.

This Weird Trick Still Missing From SQL Server 2016

Aaron Bertrand (@AaronBertrand) enters June's T-SQL Tuesday, talking about a feature long missing from SQL Server : The ability for Developer Edition to act like Standard.