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
Adding PowerShell Support
Note
This discussion is based on SQL Server 2012 Enterprise Edition. SQL Server 2012 Express doesn’t provide all the same features. For example, the Express version doesn’t provide the SQL Server Agent functionality briefly discussed later.
The addition of Windows PowerShell 2.0 support has changed in SQL Server 2012. Prior to SQL Server 2012, PowerShell could be installed as part of the SQL Server install or installed after the SQL Server install was complete. With SQL Server 2012, Windows PowerShell 2.0 is a prerequisite for installing the SQL Server 2012 Database Engine components and SQL Server Management Studio.
The PowerShell 2.0 prerequisite tends to make administration of SQL Server easier. If SQL Server 2012 ...