Expert Scripting and Automation for SQL Server DBAs

Index

A, B

1. APPLY operator

2. Automated maintenance routines

   1. break/fix scenarios

See9002 errors

1. environment refreshes

   1. SSIS Package

SeeSQL Server Integration Services Project (SSIS) package

1. workflow

1. patching activity

   1. documentation

   2. inventory database

   3. workflow

2. PowerShell script

1. Automating instance build

   1. /ACTION parameter

   2. configuring file

      1. instance installation

      2. orchestration script

      3. required instance configuration

      4. UpdateEnabled

      5. UpdateSource

   3. database scoped configurations

   4. /FEATURES parameter

   5. inventory database

      1. insert

      2. update script run

   6. orchestration

   7. port number

   8. required parameters

   9. /ROLE paramezter

   10. setup.exe program

   11. simple installation

C

1. Central management server

   1. DBCC CHECKDB

   2. Evaluate Policies

   3. NTAM server group

   4. page verification option

   5. registered servers

      1. Connection Properties tab

      2. general tab

      3. hierarchy ...