Microsoft SQL server 2008 administration with Windows PowerShell

Microsoft SQL Server 2008 Administration with Windows PowerShell 2.0 is a nuts and bolts guide to creating Windows PowerShell scripts that can be used to administer every aspect of SQL Server. With a very hands-on approach, it guidesthe reader through the basics of Windows PowerShell, the available Windows PowerShell components that have been integrated into SQL Server 2008, and actualadministration tasks. By providing clear, well-structured examples, MicrosoftSQL Server 2008 Administration with Windows PowerShell 2.0 shows the reader how to construct effective solutions that can improve the SQL Server administration and monitoring in an enterprise environment. Readers who do not have any background in Windows PowerShell will be introduced to it in the first eight chapters. These eight chapters help the reader understand the basics of writingWindows PowerShell scripts and show the reader how to use the scripts to administer the overall operating system. Chapter 9 and 10 shows the reader how to access the WMI provider for SQL Server. Chapter 11 and 12 take on the Windows PowerShell components that have been integrated into SQL Server 2008, and explain the usage of each of them in great details. Chapter 13 show reader SQL Server Management Object (SMO) programs with Windows PowerShell. Chapter 14 and 15 provide the reader with ample examples of building a SQL Server tasks inventory over an existing or new environment and guide them to use various standards. Chapter 16, 17,18,19,20 and 21 shows the user on how to create Windows PowerShell scripts to handle an array of SQL Server administrative tasks for servers in the inventory.

• ISBN: 978-0-470-47728-1
• Editorial: John Wiley & Sons
• Encuadernacion: Rústica
• Páginas: 576
• Fecha Publicación: 19/06/2009
• Nº Volúmenes: 1
• Idioma: Inglés