gbritton1/links.md

Last active January 10, 2023 17:55

Star (2) You must be signed in to star a gist
Fork (2) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gbritton1/01ac031aaa80c18df1deccf502f023a0.js"></script>
Save gbritton1/01ac031aaa80c18df1deccf502f023a0 to your computer and use it in GitHub Desktop.

Download ZIP

SSIS Database Maintenance Playbook

Raw

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment