SQLBlog.org

SQL Server 2016 SP2 Cumulative Update #14

Aaron Bertrand August 6th, 2020 SQL Server / SQL Server 2016

SQL Server 2016 SP2 Cumulative Update #14 is available, with 18 enhancements. The build number is 13.0.5830.85.

Using Taylor Swift to explain my job to my 7-year old

Aaron Bertrand August 5th, 2020 Career

My daughter surprised me with a question about work last week, and I answered her by invoking Taylor Swift.

SQL Server 2019 Cumulative Update #6

Aaron Bertrand August 4th, 2020 SQL Server / SQL Server 2019

SQL Server 2019 Cumulative Update #6 is available, with 51 enhancements. The build number is 15.0.4053.23.

A reliable and flexible replacement for sp_MSforeachdb

Aaron Bertrand August 4th, 2020 SQL Server

Find out about the replacement I wrote for the undocumented, unsupported, and ill-advised system procedure, sp_MSforeachdb.

Some weekend maintenance here on sqlblog.org

Aaron Bertrand August 3rd, 2020 General

A quick update on some maintenance I performed on the site over the weekend.

Troubleshooting Error 18456

Aaron Bertrand July 28th, 2020 SQL Server

Updated in 2020 with a few new entries, this is a fairly comprehensive list of the reasons behind various 18456 error messages.

T-SQL Tuesday #128 : Learn From Others

Aaron Bertrand July 14th, 2020 T-SQL Tuesday

For this month's T-SQL Tuesday, Kerry Tyler asks us to talk about something that went wrong. I had plenty to choose from, and went way back to ~2002 for this short story.

SQL Server 2017 Cumulative Update #21

Aaron Bertrand July 1st, 2020 SQL Server 2017

SQL Server 2017 Cumulative Update #21 is available, with 35 enhancements. The build number is 14.0.3335.7.

Be an ally and a nuisance

Aaron Bertrand June 24th, 2020 Community

Encourage PASS to show they are a diverse and inclusive community.

SQL Server 2019 Cumulative Update #5

Aaron Bertrand June 22nd, 2020 SQL Server / SQL Server 2019

SQL Server 2019 Cumulative Update #5 is available, with 86 enhancements. The build number is 15.0.4043.16.

Keep relevant system_health data longer

Aaron Bertrand June 17th, 2020 Extended Events / SQL Server

See two ways you can make the relevant data in the system_health session last longer and not get drowned out by noise.

T-SQL Tuesday #127 : Measure twice, cut once

Aaron Bertrand June 9th, 2020 T-SQL Tuesday

For this month's T-SQL Tuesday, let's talk about something you're more likely to hear from a carpenter: Measure twice, cut once.

Replace legacy splitting functions with STRING_SPLIT

Aaron Bertrand June 1st, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.

SQL Server 2016 SP2 Cumulative Update #13

Aaron Bertrand May 28th, 2020 SQL Server / SQL Server 2016

SQL Server 2016 SP2 Cumulative Update #13 is available, with 29 enhancements. The build number is 13.0.5820.21.

Get to the system_health file target a little easier

Aaron Bertrand May 28th, 2020 Extended Events / SQL Server

Access the system_health file target without tedious string parsing gymnastics.

Index and Partition Space Usage – Part 3

Aaron Bertrand May 27th, 2020 SQL Server

This series shows how I determine the amount of data distributed across indexes, files, filegroups, and partitions.

Heaps, LOBs, and aggregates : A bad combination

Aaron Bertrand May 26th, 2020 SQL Server

Dig into an intermittent stack dump involving an aggregate query against a heap with a LOB column.

SQL Server Cumulative Updates Delayed

Aaron Bertrand May 13th, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

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.