December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
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,
Start your free trial
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 ...