A couple of months ago, I created a routine to gather disk drive space statistics from several SQL Servers. Today, I discovered a bug in that program that could cause the @@SERVERNAME variable on the server that runs the job to get reset to NULL after a restart of SQL Server. The problem comes from […]
This post contains details about the behavior of one particular program we use here at my work, but the general idea should be applicable anywhere. The IT department at my work, of which I am a part, uses a tool called Orion by Solarwinds Software for network performance monitoring. The software uses SQL Server as […]
A while back, I wrote an article that appeared on SQLServerCentral.com that presented a routine to gather disk usage data for all the SQL Servers in an organization. One of the pieces of data that routine gathered was the size of the SQL Server data and log files and the total size of the drives […]
I am now officially a published author! Well, I suppose if you count blog posts, I already was, but today, my first ever non-blog article has been published! I even got paid for it and everything! You can check it out at SQL Server Central here. There is also a discussion thread about it on […]