August 2011 - Posts

• Check the Default Database Setting for your Admin Accounts

  Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor venue, Blossom Music Center , a client called with a problem. The databases on his principal production server had failed over to the mirror Read More... Posted Wednesday, August 31, 2011 4:30 PM by AllenMWhite | 3 Comments Filed under: Database Administration

• [Speaking] Lots of Speaking Engagements in September and October

  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 Read More... Posted Monday, August 22, 2011 9:38 AM by AllenMWhite | 0 Comments Filed under: PowerShell, User Group Meetings, Speaking, Service Broker

• Pull Performance Data from Perfmon Logs with PowerShell

  For the last year and a half or so I've been presenting a session on how to gather perfmon data with PowerShell. Here's a link to my blog after the 2010 Tech Ed conference that has the download scripts. These scripts include the database tables and stored Read More... Posted Sunday, August 21, 2011 8:04 PM by AllenMWhite | 0 Comments Filed under: PowerShell, Database Administration

• [OT] On Community

  Last fall, and winter, and spring I was part of the PASS Election Review Committee . It was interesting, sometimes fun, sometimes frustrating, but a very rewarding experience. My first PASS conference was in the fall of 2003, and I've attended every one Read More... Posted Thursday, August 11, 2011 1:47 PM by AllenMWhite | 3 Comments Filed under: User Group Meetings