Video: Building Unconventional SQL Server Tools in PowerShell

Last week, on Wednesday (April 6th, 2016), I presented a session at the PowerShell and DevOps Global Summit 2016 on “Building Unconventional SQL Server Tools in PowerShell with Functions and Script Modules“. The video from that presentation is now available:

Here’s the abstract or synopsis for this presentation: “Have you ever had records from a SQL Server database table come up missing? Maybe someone or some process deleted them, but who really knows what happened to them? Wouldn’t it be awesome to create a free tool with PowerShell that automates the task of sifting through the transaction log backups and even the active transaction log to determine when deletes occurred for a specific database and what user deleted those records along with the LSN (Log Sequence Number) that the database needs to be restored to so the missing records can be recovered? During this session, PowerShell MVP Mike F Robbins will walk you through his custom SQL Server PowerShell module which includes functions for querying SQL Server with PowerShell from a client machine without requiring the installation of the SQL PowerShell module or snap-in, querying transaction logs for insert, update, and delete operations, and automated point in time recovery of a database by only having to specify the point in time to perform the recovery to. All code shown during this presentation will be made available on GitHub.

Also, if you haven’t seen it, Forrest Brazeal wrote a nice critique of this session in his “Notes from the Summit: Day 3” blog article.

The slide deck and code sample shown in this presentation can be downloaded from my presentations repository on GitHub. All of the SQL related functions that are referenced during the demo can be downloaded as part of my SQL repository on GitHub.


Leave a Reply

%d bloggers like this: