Recently there was a request to create a function that would parse out the city, state and postal code information from a single string into separate columns for both US…
SQL Scripts
Monitoring Disk Space with SQL Server and PowerShell
This article shows one possible solution for monitoring disk space usage using SQL Server and a simple PowerShell script executed via SQL Agent Job. In this first code section is…
Insight into the SQL Server Agent Job Schedules
Every once in a while, I get a request to create a report of all the SQL Agent jobs and their schedules for a particular SQL Instance. The following script was…