Browse by Tags

• Database Administration
• Speaking
• SQL Server 2008
• User Group Meetings

• PASS Demonstration Errors

  Errors occur. (I'm sure that's someone's corollary to Stuff Happens.) Errors occur, and that's why we write error handling code in our applications. My least favorite time for the occurrance of errors is when I'm doing demos, and that's what happened Read More... Posted Monday, November 24, 2008 12:37 PM by AllenMWhite | 4 Comments Filed under: SMO, PowerShell, SQL Server 2008, Speaking

• SQL Server 2008 SMO Library Changes

  While preparing for a presentation at PASS next month I tested my PowerShell script to back up user databases on a server. This script has been running flawlessly against SQL Server 2005 for a couple of years, so I was really surprised when PowerShell Read More... Posted Saturday, October 18, 2008 1:35 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, SQL Server 2008

• SQL Saturday 6 - Cleveland August 9

  Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Read More... Posted Friday, June 27, 2008 8:42 AM by AllenMWhite | 0 Comments Filed under: SMO, PowerShell, User Group Meetings, SQL Server 2008

• Create Database from PowerShell

  Last week I presented a session on Using SMO to Manage SQL Server at SQL Connections in Orlando, Florida. This was the third major conference I've presented this session, and each time I do this session I change more demos from VB.Net to PowerShell. This Read More... Posted Monday, April 28, 2008 11:13 AM by AllenMWhite | 3 Comments Filed under: SMO, PowerShell, Database Administration

• Start PowerShell in Management Studio

  In the February CTP of SQL Server 2008 a new feature has appeared in SQL Server Management Studio. You now have the ability to right-click on an object in the Object Explorer window and open up a PowerShell window. In this window you can navigate the Read More... Posted Wednesday, February 20, 2008 8:59 AM by AllenMWhite | 7 Comments Filed under: SMO, PowerShell, SQL Server 2008

• Create Agent Jobs to run PowerShell Scripts

  Actually, let's use PowerShell and SMO to create an Agent job which will run a PowerShell script. (Or is that a circular reference?) I've created a number of PowerShell scripts which automate database management processes, and I wanted to be able to run Read More... Posted Wednesday, January 09, 2008 2:50 PM by AllenMWhite | 3 Comments Filed under: SMO, PowerShell

• Accessing WMI Information Using SMO

  While doing some research on SMO I found a couple of very handy features of the WMI accessibility features of SMO. I'm playing with PowerShell because it's easy to browse the SMO objects in that environment, but here are a couple of tips I found useful. Read More... Posted Friday, December 28, 2007 1:31 PM by AllenMWhite | 0 Comments Filed under: SMO, PowerShell