Improve Load Time on SQLPS

Over the month of November a fellow PowerShell enthusiast, Mike Fal (blog|@Mike_Fal), did a series on the SQL Server PowerShell module (SQLPS). In reading his series curiosity struck on what the module does when it was loading. I also just answered a question on DBA.SE that I figured out by tweaking a... [Read More]
Tags: sqlserver, powershell

Dynamically Build RDP Files

This post was originally published 26 July 2011, updated the script and the post since I have learned a good bit on PowerShell since the original post. [Read More]
Tags: powershell

Parse Deadlock Graph from System_Health session

Way back in October (2014) I published the post: XML, Glad that is over (yeah, I know such a good title). In that post I published a script built from researching how to get the deadlock report out of the Extended Event system_health session. Think of this session like the... [Read More]
Tags: sqlserver