Patching

SQL Server Database engine patching

• by Dnirmania

• SQLServerCentral

• Patching
• SQL Server patching

• Script

This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-05-26 (first published: 2020-05-19)

773 reads

• Discuss

The Time to Patch

• by Steve Jones

• SQLServerCentral

• Patching

• Editorial

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. […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-01-03

363 reads

• Discuss

Finding Non Current Cumulative Updates

• by Steve Jones

• SQLServerCentral

• Cumulative Updates (CU)
• Patching

• Article

A short article to help you quickly find a CU that isn't the latest one.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.5 (4)

Log in or register to rate

2019-12-19

1,302 reads

• Discuss

6 steps to a more secure SQL database

• by steve@thesqlguy.com

• SQLServerCentral

• Audit
• Dynamic Data Masking
• Encryption
• Patching
• Security
• Transparent Data Encryption (TDE)

• Article

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

Log in or register to rate

2019-10-07

6,115 reads

• Discuss

Install Cumulative Updates

• by Steve Jones

• SQLServerCentral.com

• Patching

• Article

This week Steve Jones recommends installing Cumulative Updates. If you can test them.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2016-05-02

58 reads

• Discuss

Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases

• by Additional Articles

• MSSQLTips.com

• Patching

• Article

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