O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required