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

  1. Todd Thorrez
    January 10, 2013 at 16:21

    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

    • January 11, 2013 at 08:59

      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

  2. Ravi
    April 28, 2014 at 22:56

    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.

  1. October 15, 2012 at 21:50
  2. April 6, 2013 at 13:49
  3. April 14, 2013 at 21:25
  4. July 28, 2013 at 17:34

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: