SQL Server 2017 Cumulative Update #22 is available, with 42 enhancements. The build number is 14.0.3356.20.
Category: SQL Server 2017
SQL Server 2017 Cumulative Update #21 is available, with 35 enhancements. The build number is 14.0.3335.7.
See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.
Cumulative Updates for SQL Server 2019, SQL Server 2017, and SQL Server 2016 SP2 have been pushed back a month or more due to our current health crisis.
SQL Server 2017 Cumulative Update #20 is available, with 40 enhancements. The build number is 14.0.3294.2.
In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.
SQL Server 2017 Cumulative Update #19 is available. The build # is 14.0.3281.6 and there are 38 fixes.
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
I show how I tried to chase down a very unexpected issue with SQL Server metadata. Spoiler: it didn't end the way I thought it would.
Updated for a more modern version, I explain how to install and use SQLLocalDB.