We have a TeamCity (TC) server which we use to automate many repetitive jobs, in the spirit of CI.
Such things include:
1) Moving changes from source control to QA databases
2) Building and deploying SSIS ispac files
3) Creating drift reports for production databases
4) Running Powershell scripts to check (and set) server config settings
5) Sending alerts if certain production database criteria are met
6) Sending alerts in the event of build failures for QA or production databases (we use VS database projects)
7) Building and deploying web sites.
The next thing we intend to automate is the restore of prod databases to QA. I know that this can be done outside of TC, but not with the same level of ease and visibility to non-SQL Server users.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin