O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required