A short demo of a CTE used to perform aggregations.
2019-04-16 (first published: 2019-04-12)
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
Through the shared script, you can see the Paglock table hint.
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
2019-01-14 (first published: 2019-01-08)
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)