Monthly Archives: June 2011

Tutorial – Installing PowerShell

Unfortunately there are a few different ways to install PowerShell, depending on the version of Windows. This tutorial provides the installation steps that are appropriate for your operating system. Note: Before attempting to install PowerShell on a computer, confirm that … Continue reading

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

Tutorial – Determining whether PowerShell is installed

The first step in using PowerShell is making sure that it’s installed on the computer(s) that need it. As time passes, it will become as ubiquitous as Cmd.exe and VBScript. However, it’s currently important to verify that PowerShell is available … Continue reading

Posted in PowerShell | Tagged , , , , | 1 Comment

Reflecting on my first CodeStock session

Today I gave my first of two presentations at the 2011 CodeStock conference, my “An Introduction to Profiler and SQL Trace” talk. The session went really well! It had good attendance, the audience was engaged and asked great questions, and … Continue reading

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

I am speaking at CodeStock 2011

I will be delivering two sessions at this year’s CodeStock conference in Knoxville, Tennessee: An Introduction to Profiler and SQL Trace at 2011-06-03 13:50-04:00. The session’s materials have been posted here. A PowerShell Cookbook for DBAs at 2011-06-04 09:50-04:00. The … Continue reading

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

Dealing with full transaction logs

In a recent post, I mentioned a customer that takes some perverse pleasure in undermining point-in-time-recoverability of their databases. Here are some more details on the bad practice and what I wish they would do instead. The customer has a … Continue reading

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