SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
A function to add or subtract working days taking into account weekends and using a table of non-working days.
Function that converts AD UserAccountControl number to details text
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
Can be useful when inserting a lot of data into a table.
This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
Collect CPU % for a time period and alert if Average CPU usage is high
Quick check SQL connection and process details with current SQL text
Yes, I realize you shouldn’t shrink your database (data files or log files), but...
By Rob Sewell
In my last post I showed how to build an Azure DevOps Pipeline for...
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will...
Hi All, I have a working SQL 2016 Enterprise AAG at our primary datacenter...
Hi, I am creating a report which needs to show an image from AWS...
Hi Sir, How to write MERGE statement when using more then two source tables...
Ask SSC