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 Professionals
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…
Why a SQL Server Health Check is the Best First Step
You can’t fix something until you know exactly what’s wrong. Well, you can try, but you’re going to end up wasting a lot of time and money. A doctor wouldn’t…
5 Ways a Remote SQL DBA Will Benefit Your Business
Yes, you need your SQL Server databases up and running right to do business efficiently and effectively. But that doesn’t mean you’re in the database business. In most cases, it’s…