SentryOne Team Blog (blogs.sentryone.com)

Category : SQL Server

Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Latest Builds of Management Studio

Latest Builds of Management Studio

Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 3, with plenty of enhancements back-ported from recent SQL Server 2016, 2017, and 2019 updates.

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.

Glenn Berry : Using Intel Optane Storage for SQL Server

Glenn Berry : Using Intel Optane Storage for SQL Server

Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.

GroupBy : New Engine Features in SQL Server 2019

GroupBy : New Engine Features in SQL Server 2019

Aaron Bertrand provides his deck and demos for a GroupBy presentation on SQL Server 2019, and makes up for some serious demo disasters.

SentryOne Community Omnibus—December 6, 2018

SentryOne Community Omnibus—December 6, 2018

In his inaugural SentryOne Community Omnibus post, Kevin Kline shares the latest SentryOne webinars, resources, blogs, and press releases.

Paul White : Join Estimation using Histogram Coarse Alignment

Paul White : Join Estimation using Histogram Coarse Alignment

Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.

PASS Summit 2018 Day Two Keynote—Two Decades of Data Innovation with Raghu Ramakrishnan

PASS Summit 2018 Day Two Keynote—Two Decades of Data Innovation with Raghu Ramakrishnan

Kevin Kline shares highlights from the PASS Summit 2018 keynote with Raghu Ramakrishnan.

PASS Summit 2018 Day One Keynote—SQL Server and Azure Data Services with Rohan Kumar

PASS Summit 2018 Day One Keynote—SQL Server and Azure Data Services with Rohan Kumar

Kevin Kline shares highlights from Rohan Kumar's PASS Summit 2018 keynote, "SQL Server and Azure Data Services: Harness the future with the ultimate hybrid platform for data and AI."

Introducing Storage Forecasting with SQL Server Machine Learning Services

Introducing Storage Forecasting with SQL Server Machine Learning Services

The newly released SentryOne 18.5 includes the first feature set to utilize advanced analytics and machine learning technology—introducing SentryOne Storage Forecasting. SentryOne Director of Analytics Steve Wright shares how you can access and customize storage capacity forecasts in SentryOne.

Attend a Microsoft Focus Group at the PASS Summit!

Attend a Microsoft Focus Group at the PASS Summit!

Learn about this HUGE opportunity to influence the Microsoft Data Platform products and services you use daily while attending the PASS Summit!

Tim Radney : End of support for SQL Server 2008 & 2008 R2

Tim Radney : End of support for SQL Server 2008 & 2008 R2

Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.