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
