SQL Server 2008 Management Improvements – SQL Server Provider for PowerShell (Part 3)

At the SQL Connections conference in April of 2008 I gave a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one of those new improvements – our new PowerShell provider for SQL Server.

For a couple of days now I’ve posted about the basics of PowerShell. I mentioned that it has a few advantages that I think the DBA will find essential:

1. It’s like a batch-file based system (all of your old logic will still work)

2. It lets variables stand for objects (see the post yesterday for this)

3. It has piping (the | symbol)

Full Article – http://blogs.msdn.com/buckwoody/archive/2008/04/30/sql-server-2008-management-improvements-sql-server-provider-for-powershell-part-3.aspx