Dan Sullivan has been doing some great things using PowerShell to manage SQL. Dan wrote that Addison-Wesley book “A Developer’s Guide to SQL Server 2005” along with Bob Beauchemin. He has now started a series of articles on this topic at simple-talk.com. Here are the first two but Dan told me that he’ll be writing more so you might want to bookmark the search for all Dan’s articles:

• Managing SQL Server using PowerSMO
• PowerSMO at work Part 1: DBA Scripts and Functions

BTW – if you are new to PowerShell, these are worth reading as they also provide a very good and pithy introduction to PowerShell.

Enjoy!

Jeffrey Snover [MSFT]
Windows PowerShell/Aspen Architect
Visit the Windows PowerShell Team blog at: http://blogs.msdn.com/PowerShell
Visit the Windows PowerShell ScriptCenter at: http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx