PowerShell Integration
SQL Server 2008 provides integrated support for Windows PowerShell, a powerful scripting shell that enables administrators and developers to automate server administration and application deployment. The Windows PowerShell language supports more complex logic than Transact-SQL scripts, enabling SQL Server administrators to build more robust and complex administration scripts.
SQL Server provides two snap-ins to Windows PowerShell for creating scripts to manage SQL Server:
• A SQL Server provider, which enables a simple navigation mechanism similar to file system paths where the drive is associated with a SQL Server management object model and the nodes are based on the object model classes. This allows you to use familiar ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
