Presentation Slides and Scripts
January Chicago SQL Server User Group Meeting - Building An Azure SQL Database Using PowerShell
The slides and scripts from my presentation are available from the links below. NOTE: The scripts have been updated to set firewall rules and allow the import of the .bacpac file to complete successfully.
Building An Azure SQL Database Using PowerShell.zip
October Chicago SQL Server User Group Meeting - Interrogating the Transaction Log
The scripts and slide deck from my presentation are available form the links below.
Interrogating the Transaction Log Scripts.zip
Interrogating the Transaction Log.pptx
January SQLConnections Meeting - Interrogating the Transaction Log
The scripts and slide deck from my presentation are contained in the zip file below. Now with VLFs!
SQL Connections - Interrogating the Transaction Log - Slides and Scripts</a
SQL Saturday Madison - Interrogating the Transaction Log
The scripts and slide deck from my presentation are contained in the zip file below.
SQL Saturday Madison - Interrogating the Transaction Log
April CSSUG Meeting/SQL Saturday Chicago - Tools for Making Multi-Object Administration Easier
The scripts and slide deck from my presentation are contained in the following zip file.
Tools to Make Multi-Object Administration Easier
SQL Saturday East Iowa - Interrogating the Transaction Log with VLF Demos
The scripts and slide deck are contained in the zip file below.
Interrogating The Transaction Log - SQL Saturday 239
SQL Saturday Kalamazoo - Interrogating the Transaction Log with VLF Demos
The scripts and slide deck are contained in the zip file below.
Interrogating the Transaction Log - SQLSAT256
I380 PASS and QCPASS - Designing a Restore Strategy
The scripts and slides are available in the zip file below. If you have any questions, leave them in a comment at this page.
ScriptandSlidesforDesigningaRestoreStrategyPresentation
IndyPASS - Designing a Restore Strategy
The .zip file below contains my presentation slides and four script files. File #1 creates sp_AutomateDBRestores. File #2 creates the database and objects for the demos. File #3 deletes rows from a table and restores them using point-in-time. File #4 drops and restores a table using point-in-time. Enjoy.
DesigningARestoreStrategy
Wisconsin SQL Server User Group - Desiging a Recovery Strategy
The .zip file contains the updated sp_AutomateDBRestore proc, demo scripts, and slides from my presentation at WISSUG.
DesigningARestoreStrategyWISSUG
Thank you Frank for sharing your knowledge on TransLogs. I agree with your statement that you made that night “one of the great things of the SQL Server community is that they share their knowledge with us all” and I include you in that great group. This was a very good presentation, thank you also for sharing your resources. I look forward to meeting up with you again in the future. – Todd Thorrez
Todd,
Thanks for the kind words and thank you for coming to the meeting. I have learned a tremendous amount from people doing presentations like mine and I am trying to give back.
Frank
Hello Frank,
For some reason I am not able to open your scripts and presentation. Can you help me please as I am very interested in the stored procedure for the restore process.