September '16 BRSSUG Meeting

Post date: Sep 08, 2016 2:24:0 AM

Date: Wednesday, September 14, 2016

Location: The Louisiana Technology Park - http://www.brssug.org/where

Sponsor: Devart (giving away free licenses!)

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business

7:00 - 8:00 pm: Main Topic Speaker

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)

Topic: Welcome to the DBA Escape Room.

This month we will be doing an escape room challenge. Unlike most escape rooms we will not be physically prevented from leaving, but as DBAs we know that the effect is the same when a data is at risk. You are not going home until the database is fixed (or if you do, print out a bunch of resume before you go).  We will be working through two of the corruption challenges put forth by Steve Stedman at  

http://stevestedman.com/server-health/database-corruption-challenge/

In the Week 1 Database corruption challenge we will be recovering a database that has become corrupt. All we have to work with is a single backup of the corrupt databases. The conventional wisdom is that when DBCC reports corruption, the solution is to restore from the last good backup. But as you know, that often is not an acceptable solution. So how can we get back all of our data from somewhere in a corrupted database?

In the Week 3 Database corruption challenge we will be recovering a database where the .mdf file has been lost. All we have are the last full backup, 3 transaction log backups and the .trn file that was recovered.

A few of us will have laptops with the challenge files and a SQL2014 Server, and all of the challenge files on a thumb drive in case we want to split into teams and solve in parallel or as a competition. Matthew Tessier will be leading this adventure.

 Important Announcement!

Registering for the PASS Summit in October? Use this code for a discount!  LC15BGL5