Microsoft SQL Server 2008 R2 Unleashed- P57:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 504 CHAPTER 17 Administering SQL Server 2008 with PowerShell Either during the initial installation of SQL 2008 or afterward while changing the installed features you are able to add the SQL Server-specific PowerShell features by using the setup utility. The Management Tools-Basic feature must be added as shown in Figure . FIGURE Installing the PowerShell features. The Management Studio add-on is also required to get the PowerShell-specific features installed. This specific feature adds the following Management Studio The graphical user interface for managing SQL Server 2008 SQLCMD The utility that SQL scripters should already be familiar with SQL Server PowerShell provider The PowerShell-specific extra functionality NOTE An added bonus is that you can install Management Studio by itself on either the server or another remote system and be able to administer your SQL Server database remotely. Consideration should be given to whether the SQL Server is set up for remote connections and the appropriate firewall changes have been made to the network and on the database server if applicable. Download from PowerShell in SQL Server 2008 505 Accessing PowerShell Now that you have added the SQL Server-specific PowerShell features you can access a SQL Server PowerShell session. NOTE From this point on we make the distinction between PowerShell and SQL Server PowerShell. The details are discussed shortly but for now PowerShell is the basic or default PowerShell console and SQL Server PowerShell is a more restricted version of PowerShell that has all the SQL Server-specific PowerShell features packaged within it. SQL Server PowerShell can be accessed in either of two ways You can open SQL Server PowerShell via the SQL Server Management Studio by right-clicking on a particular object in the Object Explorer and selecting Start PowerShell as shown in Figure . This way is handy because it provides a prompt in the SQL provider which is discussed .
