Author Archives: tnbarkhouse
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
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
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
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
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
Please vote for PASS Summit 2011 sessions!
I have been extremely fortunate to have spoken at the last two North American PASS Summits. The experiences have been amazing and I’m hopeful about getting a chance to present at this year’s conference too. I received very good feedback … Continue reading
Code snippet – Reestablishing the backup log chain with PowerShell
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
