I’m presenting a session on Building Unconventional SQL Server Tools in PowerShell this weekend at SQL Saturday #498 in Chattanooga.
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 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 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.
My session begins at 8:15am in room 201 in the EMC Building at UT Chattanooga on Saturday, June 25th. Be sure to check the event schedule for any schedule changes between now and then.
The slide deck and demo code will be posted in my presentations repository on GitHub prior to the session in case anyone wants to follow along during the presentation.