Tag Archives: automation

Code snippet – Reestablishing the backup log chain with PowerShell

Posted on 2011-05-19 by

We have a certain customer that has an incredible fondness for undermining the restorability of their databases. Almost all of their databases are in the full recovery model and all-too-frequently the customer will start backing up transaction logs with the … Continue reading →

Posted in PowerShell, SQL Server | Tagged , , , , , , , , , | Leave a comment

Script – Extracting XML deadlock graphs from a trace file

Posted on 2011-02-24 by

Today is my fourth day of SQLskills Immersion Events training, taught by none other than Paul Randal (blog, Twitter) and Kimberly Tripp (blog, Twitter). The material and delivery have been amazing and I hope to have a chance to blog … Continue reading →

Posted in PowerShell, SQL Server | Tagged , , , , , , , , , , | Leave a comment

The Presentations Won’t Be Posted Until After the PASS Summit

Posted on 2009-10-31 by

I’ve decided that the posting of my presentation materials (PowerPoint slide decks and sample code) will have to wait until I return from the 2009 PASS Community Summit. I apologize again for the delay. As I mentioned previously, I’ve been … Continue reading →

Posted in SQL Server | Tagged , , , , , , , | Leave a comment

Using PowerShell to Determine the Windows Installer Version

Posted on 2009-07-08 by

I’m going to attempt a short post… Sometimes it’s necessary to determine the version of Windows Installer present on a system. The installation package for new products may be designed to use a feature added to a specific version of … Continue reading →

Posted in PowerShell | Tagged , , , | Leave a comment

Speaking at the PASS Community Summit 2009

Posted on 2009-07-01 by

One of my abstracts was selected for the PASS Community Summit 2009! It is an immense honor to get to speak at the conference, and it’s humbling to see my name listed amongst those of so many renowned SQL Server … Continue reading →

Posted in SQL Server | Tagged , , , , , , | 2 Comments

My PowerShell Script Won A Contest!

Posted on 2009-04-30 by

Yesterday, I attended a Live Meeting for the PASS Database Administration Special Interest Group, presented by Buck Woody. The topic was on using PowerShell with SQL Server. Given that these are two of my favorite technologies, I decided to participate. … Continue reading →

Posted in PowerShell, SQL Server | Tagged , | Leave a comment