SSIS Database Maintenance Playbook

links.md

Short link to this gist: https://bit.ly/2xIsDfw

---

Links to software used in this course:

• SQL Server
  • https://www.microsoft.com/en-ca/sql-server/sql-server-downloads
  • SQL Server samples on github
    • https://github.com/microsoft/sql-server-samples
• SQL Server Management Studio
  • https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
• Visual Studio
  • https://visualstudio.microsoft.com/downloads
• SQL Server Intergration Services Extension for Visual Studio
  • https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

---

Basic database maintenance tasks

Pluralsight courses

• SQL Server: Understanding and Performing Backups
  • https://app.pluralsight.com/library/courses/sqlserver-understanding-performing-backups
• Managing SQL Server Database Maintenance
  • https://app.pluralsight.com/library/courses/managing-sql-server-database-maintenance

Online resources

• The Complete Guide to SQL Server Backup and Restore
  • https://www.red-gate.com/products/dba/sql-backup/entrypage/sql-server-backup-restore
• Backup and Restore of SQL Server Databases - Microsoft
  • Microsoft Download
• SQL Skills Accidental DBA Series
  • https://www.sqlskills.com/help/accidental-dba

---

SQL Server Integration Services

• https://docs.microsoft.com/en-us/sql/integration-services/

Database Maintenance Plans

• https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans

---

Pluralsight Courses on SQL Server Integration Services

• Integration Services Fundamentals (a little older, but covers all the essentials)
  • https://app.pluralsight.com/library/courses/ssis-basic
• What's New in SQL Server 2016 Integration Services
  • https://app.pluralsight.com/library/courses/sql-server-2016-integration-services
• Extracting and Transforming Data in SSIS
  • https://app.pluralsight.com/library/courses/extracting-transforming-data-ssis

---

SQL Server documentation

• BACKUP DATABASE
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
• DBCC CHECKDB
  • https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql
• Reorganizing and rebuilding indexes
  • https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes
• UPDATE STATISTICS
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql