PowerShell in Practice

Chapter 14. SQL Server

This chapter covers

• Configuring SQL Server
• Creating and administering databases
• Creating and managing database objects such as tables and indexes
• Manipulating data in a SQL Server database

Any Windows-based environment is more than likely to have SQL Server installed somewhere. In addition to being used as a database in its own right, it also appears as a data store for a number of other Microsoft products including SharePoint, Operations Manager, and Configuration Manager.

SQL Server has a powerful scripting language in the shape of T-SQL. Many SQL Server experts will say they don’t need PowerShell, as they can administer SQL Server quite happily using T-SQL.

Unfortunately, in many organizations the opportunity ...