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,167 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,678 reads
Blogs
Daily Coping 4 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Forums
CAST AS DATE Assistance
Can someone let me know why I'm not able to use CAST method to...
Deploying a standalone Azure VM running SQL Server into an availability zone
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Ask SSC