Last active
January 10, 2023 17:55
-
-
Save gbritton1/01ac031aaa80c18df1deccf502f023a0 to your computer and use it in GitHub Desktop.
Revisions
-
gbritton1 revised this gist
Apr 22, 2020 . 1 changed file with 2 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -46,5 +46,6 @@ - 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 - -
gbritton1 revised this gist
Apr 20, 2020 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -44,7 +44,7 @@ - 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 - - -
gbritton1 revised this gist
Apr 20, 2020 . 1 changed file with 2 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -44,6 +44,7 @@ - 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 - - -
gbritton1 revised this gist
Apr 17, 2020 . 1 changed file with 9 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -38,3 +38,12 @@ - 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 - - - -
gbritton1 revised this gist
Apr 13, 2020 . 1 changed file with 2 additions and 2 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -25,12 +25,12 @@ - [Microsoft Download](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) - 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 -
gbritton1 revised this gist
Apr 13, 2020 . 1 changed file with 8 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -30,3 +30,11 @@ - 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 -
gbritton1 revised this gist
Apr 10, 2020 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -4,7 +4,7 @@ - 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 -
gbritton1 revised this gist
Apr 9, 2020 . No changes.There are no files selected for viewing
-
gbritton1 revised this gist
Apr 5, 2020 . 1 changed file with 2 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -3,6 +3,8 @@ ### 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/tree/master/samples - SQL Server Management Studio - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms - Visual Studio -
gbritton1 revised this gist
Apr 4, 2020 . 1 changed file with 5 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -23,3 +23,8 @@ - [Microsoft Download](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) - 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 -
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -22,4 +22,4 @@ - Backup and Restore of SQL Server Databases - Microsoft - [Microsoft Download](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) - SQL Skills Accidental DBA Series - https://www.sqlskills.com/help/accidental-dba -
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -20,6 +20,6 @@ - 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](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) - SQL Skills Accidental DBA Series - https://www.sqlskills.com/help/accidental-dba/?utm_source=accidentaldba&utm_medium=blogs&utm_campaign=training -
gbritton1 revised this gist
Apr 3, 2020 . No changes.There are no files selected for viewing
-
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 3 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -20,4 +20,6 @@ - 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](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20ofAccidental DBA Series%20SQL%20Server%20Databases.pdf) - SQL Skills Accidental DBA Series - https://www.sqlskills.com/help/accidental-dba/?utm_source=accidentaldba&utm_medium=blogs&utm_campaign=training -
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 0 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -21,4 +21,3 @@ - https://www.red-gate.com/products/dba/sql-backup/entrypage/sql-server-backup-restore - Backup and Restore of SQL Server Databases - Microsoft - [Microsoft Download](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) -
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 1 addition and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -20,4 +20,5 @@ - 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](https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Backup%20and%20Restore%20of%20SQL%20Server%20Databases.pdf) - https://bit.ly/39HLa9c -
gbritton1 revised this gist
Apr 3, 2020 . 1 changed file with 13 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -8,4 +8,16 @@ - 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 - https://bit.ly/39HLa9c -
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 8 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,3 +1,11 @@ ### 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 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 -
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 0 additions and 2 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,5 +1,3 @@ ### Short link to this gist: https://bit.ly/2xIsDfw --- ### Links to software used in this course: -
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,5 +1,5 @@ # SSIS Database Maintenance Playbook ### Short link to this gist: https://bit.ly/2xIsDfw --- ### Links to software used in this course: -
gbritton1 revised this gist
Apr 2, 2020 . No changes.There are no files selected for viewing
-
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 3 additions and 2 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,4 +1,5 @@ # SSIS Database Maintenance Playbook ### Short link to this gist: https://bit.ly/2JyLZXa --- ### Links to software used in this course: -
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 2 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,3 +1,4 @@ # SSIS Database Maintenance Playbook ### Short link to this gist: https://bit.ly/2Ppp0Uz --- -
gbritton1 revised this gist
Apr 2, 2020 . 1 changed file with 3 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1 +1,3 @@ # SSIS Database Maintenance Playbook Short link to this gist: https://bit.ly/2JyLZXa -
gbritton1 created this gist
Apr 2, 2020 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1 @@ # SSIS Database Maintenance Playbook