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 ...

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 ...

SQL Saturday is coming to Cleveland!   The Ohio North SQL Server Users Group is excited to announce the date for SQL Saturday 60 in Cleveland, Ohio on February 5, 2011! The Call for Speakers is now open and we'd love to have you come here and join us for our city's event. Why would I want to come to Cleveland in February, you ask? Well ...

Brian Davis and I will be presenting a session on managing database change via source control tomorrow evening. Developers use source control consistently and with great success, but database change has been resistant to it, largely because the change involves much more than just the scripts. We'll discuss this, and show you how to use both ...

PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline: Use PowerShell to Get the Most out of SQL Server Module 1: ...

I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell. The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft Way, Charlotte, NC 28273. For more information please visit SQLSaturday.com or email us ...

I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is for the PASS AppDev Virtual Chapter, and will take place on Tuesday at noon EST. You can attend the meeting via this link: https://www323.livemeeting.com/cc/usergroups/join?id=8PQHN2&role=attend The second will be the same ...

The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server Performance Data with PowerShell, where I discussed key performance counters you should monitor and why, then a PowerShell script to gather them and store them in a SQL Server database, then created a report which I loaded and ran from ...

  I will be speaking at the Orange County SQL Server Professionals User Group this Thursday, October 1st, 2009. The topic is “How the Query Optimizer Works”. So if you are in the Orange County or Los Angeles area please stop by and say hello. The meeting starts at 6:30 PM. More details and directions can be found here Orange County SQL ...

I will be speaking at Los Angeles SQL Server Professionals Group this Thursday, September 17, 2009. The topic is “How the Query Optimizer Works”. So if you are in the area please stop by and say hello.   The meeting starts at 6:30 PM. More details and directions can be found here   Los Angeles SQL Server Professionals Group ...