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
118 reads
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
386 reads
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
169 reads
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
393 reads
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
174 reads
2021-04-10
100 reads
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,232 reads
Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]
2020-01-03
558 reads
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,327 reads
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
2019-10-07
7,955 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Last month (I ran just a little bit late writing this, it was meant...
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Hi everyone, So I have been working on converting my SQL tables data into...
Comments posted to this topic are about the item The Growth of IQP
Comments posted to this topic are about the item How to work with Python...
Ask SSC