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 ...
Get Microsoft® SQL Server 2012 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.
