Skip to content

Instantly share code, notes, and snippets.

@gbritton1

gbritton1/links.md

Last active January 10, 2023 17:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gbritton1/01ac031aaa80c18df1deccf502f023a0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gbritton1/01ac031aaa80c18df1deccf502f023a0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. gbritton1 revised this gist Apr 22, 2020. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion links.md
    View file
    Original 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
    -
  2. gbritton1 revised this gist Apr 20, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion links.md
    View file
    Original 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
    - Reorganizing and rebuilding indexes
    - https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes
    -
    -
  3. gbritton1 revised this gist Apr 20, 2020. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion links.md
    View file
    Original 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
    -
    -
  4. gbritton1 revised this gist Apr 17, 2020. 1 changed file with 9 additions and 0 deletions.
    9 changes: 9 additions & 0 deletions links.md
    View file
    Original 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
    -
    -
    -
  5. gbritton1 revised this gist Apr 13, 2020. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions links.md
    View file
    Original 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
  6. gbritton1 revised this gist Apr 13, 2020. 1 changed file with 8 additions and 0 deletions.
    8 changes: 8 additions & 0 deletions links.md
    View file
    Original 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
  7. gbritton1 revised this gist Apr 10, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion links.md
    View file
    Original 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/tree/master/samples
    - 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
  8. gbritton1 revised this gist Apr 9, 2020. No changes.
  9. gbritton1 revised this gist Apr 5, 2020. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions links.md
    View file
    Original 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
  10. gbritton1 revised this gist Apr 4, 2020. 1 changed file with 5 additions and 0 deletions.
    5 changes: 5 additions & 0 deletions links.md
    View file
    Original 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
  11. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion links.md
    View file
    Original 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/?utm_source=accidentaldba&utm_medium=blogs&utm_campaign=training
    - https://www.sqlskills.com/help/accidental-dba
  12. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion links.md
    View file
    Original 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%20ofAccidental DBA Series%20SQL%20Server%20Databases.pdf)
    - [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
  13. gbritton1 revised this gist Apr 3, 2020. No changes.
  14. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion links.md
    View file
    Original 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%20of%20SQL%20Server%20Databases.pdf)
    - [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
  15. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion links.md
    View file
    Original 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)
    - https://bit.ly/39HLa9c
  16. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions links.md
    View file
    Original 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
  17. gbritton1 revised this gist Apr 3, 2020. 1 changed file with 13 additions and 1 deletion.
    14 changes: 13 additions & 1 deletion links.md
    View file
    Original 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
    - 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
  18. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 8 additions and 0 deletions.
    8 changes: 8 additions & 0 deletions links.md
    View file
    Original 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
  19. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 0 additions and 2 deletions.
    2 changes: 0 additions & 2 deletions links.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,3 @@
    # SSIS Database Maintenance Playbook

    ### Short link to this gist: https://bit.ly/2xIsDfw
    ---
    ### Links to software used in this course:
  20. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion links.md
    View file
    Original 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/2JyLZXa
    ### Short link to this gist: https://bit.ly/2xIsDfw
    ---
    ### Links to software used in this course:
  21. gbritton1 revised this gist Apr 2, 2020. No changes.
  22. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 3 additions and 2 deletions.
    5 changes: 3 additions & 2 deletions links.md
    View file
    Original 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/2Ppp0Uz
    ---
    ### Short link to this gist: https://bit.ly/2JyLZXa
    ---
    ### Links to software used in this course:
  23. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion links.md
    View file
    Original 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/2JyLZXa
    ### Short link to this gist: https://bit.ly/2Ppp0Uz
    ---
  24. gbritton1 revised this gist Apr 2, 2020. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion links.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,3 @@
    # SSIS Database Maintenance Playbook
    # SSIS Database Maintenance Playbook

    Short link to this gist: https://bit.ly/2JyLZXa
  25. gbritton1 created this gist Apr 2, 2020.
    1 change: 1 addition & 0 deletions links.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    # SSIS Database Maintenance Playbook