Next Meeting

Thursday,

February

25

OPASS February 2016 Meeting W/ Andy Warren

  • In-Person @ 1061 South Sun Drive Ste. 1009 Lake Mary, Florida, United States (map)
  • 18:30 - 20:30 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

The Orlando SQL user group (OPASS) meets the last Thursday of every month at Cork and Olive in Lake Mary, FL. We feature a different speaker every month covering a variety of topics. This is a free event centered around Microsoft SQL server, where everyone is welcome and encouraged to attend. Come join us for free learning, networking, food, and fun.

Featured Presentation:

Automating Database Restores

Andy Warren, President SQLAndy

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 one way to do it; a table driven design with two jobs that will get the latest backup, restore it, and then apply a configurable set of post-restore options. I'll show you the code and talk to you about some of the design decisions, mistakes, and trade-offs that we made.

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.

Register for OPASS May Meeting W/ Brad Gall!

 Meeting Time

We typically meet on the last Thursday of each month from 6:30PM - 8:30PM

 NEW Meeting Location

Cork and Olive

1061 S. Sun Drive Ste. 1009 Lake Mary, FL 32746

We normally start with about 10 minutes of news and announcements.  We then have 10-15 minutes of networking.  Right before the food is served, we give our sponsor for the month a chance to present for 10-20 minutes.  At about 6:45 we start our feature presentation. Finally we end by raffling off any SWAG our sponsors have graciously supplied.

 

Sign up here for news, and join us on our LinkedIn group for networking, discussion, and job posts.