Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
What’s New with PowerShell
PowerShell continues to evolve and change as it relates to SQL Server. This evolution starts with the SQL Server setup. In the past, PowerShell could be installed as part of the SQL Server setup. Starting in SQL Server 2012, PowerShell 2.0 is a prerequisite for installing SQL Server 2012. You cannot install PowerShell 2.0 with the SQL Server setup, but fortunately it is already installed with many of the new operating systems. This demonstrates Microsoft’s commitment to PowerShell and SQL Server’s dependency on PowerShell.
The SQLPS utility has also evolved in SQL Server 2012. This utility (also known as SQL Server PowerShell) is no longer a PowerShell 1.0 minishell. When the SQLPS utility launches, it now starts PowerShell ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access