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)
773 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)
773 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
363 reads
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,302 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
6,115 reads
This week Steve Jones recommends installing Cumulative Updates. If you can test them.
2016-05-02
58 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 set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...
I know this has been covered ad nauseum all over the internet for years....
I am using SQL server 2008 R2 express edition. Out of below 3 method...