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
131 reads
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
583 reads
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
201 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
440 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
204 reads
2021-04-10
103 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,366 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
594 reads
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,332 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
8,532 reads
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
I am having great trouble creating a data pipeline using MariaDB connector 3 with...
Dear Friends, Please advise why would one of my Availability Group databases go into...
Access db wanting to move sql server, how much control does business have over...
Ask SSC