Category: SQL Server 2016

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.
The newly released SentryOne 18.5 includes the first feature set to utilize advanced analytics and machine learning technology—introducing SentryOne Storage Forecasting.
Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose the newer version.
Melissa Coates of SentryOne shares slides, videos, and other resources from a recent webinar on building an Azure SQL Data Warehouse.
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries...
They Did it Again- The Release of SQL Server 2017
Kevin Kline provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of SQL Server trace flags.
Kevin Kline and Ben Lezin hold a short Q & A with Gavin Payne and Mike Wood about Azure architecture and improvements.
February 23, 2017 | Kevin Kline | SQL Server 2016, Cloud, SQL Server, Azure 0
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.
The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server.
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.
Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade
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.
Learn more about all of the newest features added to SSMS from Kevin Kline's latest article on DBTA.
1 2 3 4

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More