What’s New with PowerShell
The integration of Windows PowerShell into the SQL Server environment is new to SQL Server 2008. The PowerShell scripting language has been around for some time, but it was not installed with prior versions of SQL Server or integrated into the SQL Server environment. With SQL Server 2008, it is installed, and there are now means for easily accessing SQL Server objects via this powerful scripting shell.
The SQLPS utility is at the crux of the new PowerShell integration in SQL Server 2008. SQLPS is a command-line shell that loads and registers SQL Server snap-ins that provide access to SQL Server via PowerShell. There is no need to manually reference or load the SQL Server libraries, which is necessary if you launch ...
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.
