January 2008 - Posts

• Using PowerShell and SQL Server Together

  I've mentioned before my company manages trade shows, and we've got a series of web sites managed by an application which uses a different SQL Server database for each site, with a master database (I'll call it Global, to differentiate it from SQL Server's Read More... Posted Friday, January 25, 2008 12:05 PM by AllenMWhite | 22 Comments Filed under: PowerShell, Database Administration

• 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 | 5 Comments Filed under: SMO, PowerShell

• Automating SQL Server Administrative tasks with PowerShell

  I'll be presenting this topic at the January meeting of the Ohio North SQL Server Users Group on Thursday, January 10, 2008. Here's the Agenda: 5:00 - 5:45 PM - Early Arrival/Discussions around SQL Server Management Tools - Bruce Szabo Are you new to Read More... Posted Friday, January 04, 2008 4:25 PM by AllenMWhite | 1 Comments Filed under: User Group Meetings

• [OT] Daddy's Little Girl

  Today at 4:45PM EST my daughter is getting married. Her fiance is in the Army and will fly to Frankfurt, Germany for assignment as a Combat Engineer. They're getting married today so she can join him on base in Germany as soon as he arranges housing for Read More... Posted Thursday, January 03, 2008 9:29 AM by AllenMWhite | 13 Comments