The End of SQL Server 2019
Steve has a few thoughts after the end of mainstream support for SQL Server 2019.
2025-03-26
553 reads
Patching
How Do You Patch 100 Database Servers?
The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.
2024-11-18
247 reads
2024-05-29
290 reads
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
151 reads
A New SQL Server Vulnerability
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
740 reads
The Challenge of Edge Security
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
292 reads
The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
537 reads
Patching Challenges
Having a patching strategy for your systems is important, and Steve notes that you ought to be organized and allow for some flexibility when designing one.
2021-06-30
342 reads
2021-04-10
122 reads
SQL Server Database engine patching
This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).
2020-05-26 (first published: 2020-05-19)
1,778 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers