SQL Server 2019 – SQLBlog

SQL Server 2019 Cumulative Update #1

Aaron Bertrand | January 10th, 2020 in SQL Server 2019

SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.

Aaron Bertrand | January 6th, 2020 in SQL Server 2017 / SQL Server 2019

In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.

Aaron Bertrand | November 21st, 2019 in SQL Server 2019

Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.

Aaron Bertrand | November 11th, 2019 in SQL Server 2019

I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.

Aaron Bertrand | November 7th, 2019 in SQL Server 2019

Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.

Aaron Bertrand | November 6th, 2019 in Community / SQL Server 2019

See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.

Aaron Bertrand | November 1st, 2019 in SQL Server 2019

I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.

Aaron Bertrand | October 15th, 2019 in SQL Server 2019

I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.