SQL Server Function to convert INT into DATETIME for sysjobhistory

While building an internal repository for monitoring and reporting for my SQL network, I ran across a small but important issue with the¬†sysjobhistory in msdb. The run_date and run_time are of the INT datatype. I have created a small function …

Read more »

SQL Server Partitioning for Performance and Archiving

Thanks to all who attended the Tampa Bay SQL BI user group meeting September 9, 2013. I had a terrific time presenting and appreciate the¬†opportunity to share details on SQL Server partitioning. Partitioning is near and dear to me so …

Read more »

PowerShell (script) – Run SQL Query in Database

This post is a nice simple way to connect into a SQL Server and run a quick SQL query. I have purposely left it simple so anyone can use it as a template to build on and add features. I …

Read more »