The Challenge of Edge Security
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
139 reads
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
139 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
338 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
155 reads
2021-04-10
96 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,137 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
536 reads
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,323 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,625 reads
This week Steve Jones recommends installing Cumulative Updates. If you can test them.
2016-05-02
66 reads
Planning on patching my SQL Servers to the latest service pack, but not sure how to complete this for a environment that is using database mirroring? In this tip, will outline the environment and then walk through the process of patching mirrored servers.
2012-06-22
3,569 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Hello. I am not a SQL Developer - just an IT generalist (if that)...