SQL Server 2016 SP2 Cumulative Update #15 is available, with 21 enhancements. The build number is 13.0.5850.14.
Monthly Archive: September 2020
I've started a new project to parse default values from stored procedures and functions.
I like to encourage people to always be on the latest Cumulative Update, but lately my confidence has been eroding. The latest patch for SQL Server 2019 hasn't helped.
If you ever use
sys.sp_columns as shorthand for catalog views, please don't, and I'll tell you why.
Whether you love or fear new PC builds, it's not every day a Mac person builds a Windows PC. See the parts I chose and how much more economical this option can be.
SQL Server 2017 Cumulative Update #22 is available, with 42 enhancements. The build number is 14.0.3356.20.
This month, Elizabeth Noble asks us to talk about things we have automated (or want to automate). I talk about a project I just started, called GetAllTheErrorLogs.
SQL Server 2019 Cumulative Update #7 is available, with 56 enhancements. The build number is 15.0.4063.15.
There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and deadlocks.