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)
688 reads
Patching
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
303 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,297 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
5,649 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
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental...
Daily Coping 1 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Power BI – Hungry Median – Aggregations
Introduction In my last blog post, I have addressed an issue with DAX Median...
Forums
poor performance function
Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int]...
Random Timeout Error
Hi, following a code release we have seen random timeout errors. I'm not sure...
is_merge_published
I'm running the following query to get a list of my Merge Publications but...
Ask SSC