" rel="stylesheet">
Skip Main Navigation
Page Content
This event has ended

MagicPASS January 2016 Meeting


Wednesday, January 20, 2016 from 6:30 PM to 9:00 PM (EST)

Registration Information

Type Remaining End Quantity
MagicPASS January 2016 Meeting 24 Registrations Ended Free  

Share MagicPASS January 2016 Meeting

Event Details

Free SQL Server Training!

Join us for the January 2016 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!

This month we welcome Orlando's own Andy Warren to present Automating Database Restores

After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)

Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)

Featured Presentation

Automating Database Restores

Speaker: Andy Warren

Summary: Beginning DBA's think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn't hard, but what about when you get five or ten requests a day? It's not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable.

This presentation will show you the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I'll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it's a pattern you could solve using another language, even perhaps TSQL!.

About Andy: Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he's been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

No Pre-Meeting Presentation This Month

Have questions about MagicPASS January 2016 Meeting? Contact MagicPASS

When & Where

Disney Vacation Club
1390 Celebration Blvd
Celebration, FL 34747

Wednesday, January 20, 2016 from 6:30 PM to 9:00 PM (EST)

  Add to my calendar

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.