I'll be presenting at the South East Michigan SQL Server User Group (SEMSSUG) tonight. The session will be Gather SQL Server Performance Data with PowerShell. We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always ...

After a week of data recovery (see my blog post here) and travel via train with no internet access, I've finally been able to get my presentation materials together from the Training Day and two regular sessions I did at SQL Bits #9 in Liverpool last week.  I've uploaded the materials here for the training day.  If you were in the room ...

Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling there next week for SQLBits 9 - Query across the Mersey! My wife and I will be spending a couple of days in London first, and since I'm a descendant of the Howard family from the Tudor period, I'm most interested in ...

As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief list of what's coming up: On Saturday, September 17 I'll be in Kalamazoo, Michigan for SQL Saturday #84, where I'll be presenting my Automate Policy-Based Management using PowerShell. The lineup of presenters for this event is amazing and I'll ...

The organizers of SQL Saturday #61 in DC (actually Reston, VA) created an Advanced DBA/Dev track for their event, which I think is cool. Both of the presentations I'll be doing there on Saturday are in that track. (In fact, they're the first two sessions of the day.) The first, Automate Policy-Based Management using PowerShell will walk through ...

In conjunction with the launch of Red Gate's SQL Source Control product, I'm presenting a webinar on Thursday, November 18 at noon EST. I'll present an introduction to PowerShell for those who've never seen it, walk through the basics of the SQL Server SMO Object Model, so you can see how SQL Server organizes all it's objects, then show you a ...

I'd like to thank everyone who attended my pre-conference session at PASS on Using PowerShell to Get the Most Out Of SQL Server. It was a huge success, and (at the last count I heard) I had 63 people in attendance. The demos for the session have been attached to this post, but it's password protected, so those of you present have the ...

Next week is the eagerly anticipated PASS Summit 2010. I've attended every year since 2003, but this one is special, because I'm presenting both a Pre-Conference session and a Spotlight session! In addition to these, I'll be a contestant in Monday evening's SQL Quiz Bowl, and on Wednesday afternoon, one of the Lightning sessions. Monday's ...

This week I presented two sessions at the Fall 2010 SQL Connections conference, in Las Vegas, Automating Policy-Based Management Using PowerShell and Managing SQL Server System and Performance Data with PowerShell. I thorougly enjoyed doing both presentations and for the most part got some great questions. I'm attaching the decks and demo scripts ...

I'll be presenting my session on Use PowerShell to Get the Most out of SQL Server twice today. This session is a one-hour intro to PowerShell and how to use it to connect with and manage SQL Server. Here's the full abstract: PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports ...