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