March 2012 - Posts

• System Inventory and Performance Gathering SQL Connections Session

  Yesterday I delivered a session on maintaining a system inventory and gathering performance data with PowerShell. The session went well and I had great questions and I'd like to thank everyone who attended the session. I've attached the slides and demo Read More... Posted Thursday, March 29, 2012 12:44 PM by AllenMWhite | 0 Comments Filed under: SMO, PowerShell, Database Administration, Speaking Attachment(s): SQL325-Maintain SQL Server System and Performance Data with PowerShell.zip

• PowerShell Precon session at SQL Connections

  Yesterday I had the privilege of presenting the full day training session SPR304-Automate and Manage SQL Server with PowerShell at the SQL Connections conference in Las Vegas. The session went very well (at least from my perspective) and I think the attendees Read More... Posted Tuesday, March 27, 2012 3:50 PM by AllenMWhite | 6 Comments Attachment(s): SPR304-Automate and Manage SQL Server with PowerShell.zip

• Speaking About SQL Server

  There's a lot of excitement in the SQL Server world right now, with the RTM (Release to Manufacturing) release of SQL Server 2012 , and the availability of SQL Server Data Tools (SSDT) . My personal speaking schedule has exploded as well. Just this past Read More... Posted Monday, March 12, 2012 3:32 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, Database Administration, Speaking

• Set and Verify the Retention Value for Change Data Capture

  Last summer I set up Change Data Capture for a client to track changes to their application database to apply those changes to their data warehouse. The client had some issues a short while back and felt they needed to increase the retention period from Read More... Posted Wednesday, March 7, 2012 9:14 PM by AllenMWhite | 6 Comments Filed under: Database Administration, SQL Server 2008

• Load Perfmon Log Data into SQL Server with PowerShell

  In yesterday's post I showed you how I set up performance data gathering in an environment where I can't directly update my analysis database. Today I'll show you how I load that data into SQL Server for the analysis. First, I create tables to contain Read More... Posted Saturday, March 3, 2012 3:12 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, Database Administration

• Setup Perfmon with PowerShell and Logman

  In a session yesterday I was reminded of the power of a tool on every server, Logman, to manage performance data gathering. It's a pretty amazing tool, and I'm starting to get to know how much more it can do than I've even considered, but here's a simple Read More... Posted Friday, March 2, 2012 5:34 PM by AllenMWhite | 8 Comments Filed under: SMO, PowerShell, Database Administration

• Getting Job History Correctly

  In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem. Read More... Posted Thursday, March 1, 2012 10:03 PM by AllenMWhite | 2 Comments Filed under: SMO, PowerShell, Database Administration