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 ...

Get PowerShell in Practice now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.