SentryOne Team Blog (blogs.sentryone.com)

Tag: SQL Server 2016

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.

SQL Server 2016 – The Cool is in the Tool (SSMS That is)

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles. Learn more about all of

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.

SQL Server 2016 is Simply Faster… A Lot Faster

I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland last summer. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was

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.

U-SQL and the Azure Data Lake

There's a new buzzword on the loose, the data lake. At first glance, a data lake could be easily mistaken for a data warehouse. The two big data concepts have a common focus on analytics and they may, in certain situations, produce roughly equivalent output. But that's about where their similarities end. Learn more about

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.

Rob Farley : Plans with SQL Server 2016 Temporal Tables

For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Announcing Plan Explorer Add-In Support for SSMS 2016

Aaron Bertrand (@AaronBertrand) reveals a new build of SQL Sentry Plan Explorer, updated to support the new add-in model introduced with the latest SSMS.

Temporal Tables in SQL Server 2016

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't heard of temporal data values (or for some, "bitemporal"), here is a brief explanation. READ MORE… Originally Posted June 09, 2016