2021-04-10
78 reads
Patching
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)
895 reads
The Time to Patch
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
400 reads
Finding Non Current Cumulative Updates
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,305 reads
6 steps to a more secure SQL database
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
6,428 reads
Install Cumulative Updates
This week Steve Jones recommends installing Cumulative Updates. If you can test them.
2016-05-02
58 reads
Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases
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
Blogs
Thanks Kathi and Mala
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Goal Progress for April 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Daily Coping 7 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
Upgrade 2014 Web Edition to Standard
Hello. I'm working with a client who currently has a SQL 2014 Web Instance...
Package failing but the table is already there and the system says its missing!!
Dear Everyone Im using SSIS 2019 and VS 2019 The data scientist gave me...
Ask SSC