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)
1,070 reads
SQL Server patching
A SQL Server Patching Shortcut
This post on SQL Server patching illustrates a quick and simple way of safely extracting SQL Server installation files in advance of patching a SQL Server instance.
2016-04-05
3,558 reads
Blogs
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks...
How to tell if Change Data Capture (CDC) is working as expected
By DesertDBA
I’m not sure how many of you use Change Data Capture (CDC) on your...
Forums
Can secondary data file (.ndf) be created by default during sql installation?
Primary data file, sitting on its own drive, has two files: .mdf and .ndf....
Extended Events stop writing to Ring Buffer in 10 minutes.
It hardly goes over 1000 collected rows, and just stops further logging without any...
left join causing results to be multiplied
Hello, Hello, the query below is giving me some trouble. the results of the...
Ask SSC