SQL Server 2012 PowerShell Provider Introduction from the Scripting Guy...

Hey, Scripting Guy - Introduction to the SQL Server 2012 PowerShell Provider

Summary: Microsoft Scripting Guy, Ed Wilson, provides an introduction to the SQL Server 2012 provider for Windows PowerShell.

Microsoft Scripting Guy, Ed Wilson, is here. One of the really cool things about SQL Server 2012 is the SQL Server provider for Windows PowerShell. By using the SQL Server provider, you gain access to a driver that permits working with SQL Server 2012 in the same way that you might work with the file system. It becomes another drive, just like the other Windows PowerShell drives.

Note   For more information about the various Windows PowerShell drives, see this series of Hey, Scripting Guy! Blog posts.

After you install SQL Server 2012, there are two additional downloads you need to gain access to the SQL Server 2012 provider for Windows PowerShell. The first is the Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2012, and the second is the Microsoft SQL Server 2012 Shared Management Objects. Both of these packages come in x86 and in x64 flavors, and they are available via the Microsoft Download site.

Note   To work with the SQL Server provider, you do not have to enable script execution on your system. If you decide to enable script execution on your system, take a look at The Scripting Wife Sets the Script Execution Policy.

..."

If you've never looked at the PowerShell Provider for SQL Server, you should head on over to this blog post. I think you'll be surprised at what's available.

 

Related Past Post XRef:
SQL Server Provider/Namespace for PowerShell (Think "Easy Command Line/PowerShell Access to SQL Server Data")
Powering your DBA'ness with these Powershell scripts for DBA's
Powering up your SQL Server DBA skills with PowerShell
SQLPSX v2 – PowerShell for SQL Server has been PowerShell 2’ed
PowerShell for SQL Server 2000+ - Chad Miller’s SQL Server PowerShell Extensions v1.5 released, with 104 functions, 2 cmdlets and 12 scripts
DBA’s & PowerShell? Yep, PowerShell is not just for your IT brethren, you can have PS fun too!
PowerShell and SQL Server 2008 Whitepaper
More details about SQL Server 2008 and its PowerShell support
SQL Server 2008 & PowerShell - Better Together
SQL Server Provider/Namespace for PowerShell (Think "Easy Command Line/PowerShell Access to SQL Server Data")