Next Meeting: Mon, Oct 12 2015

CASSUG monthly meeting 2015-10-12

Language: English
Event Type: In-Person
Online Meeting URL: None

Monthly meeting at Autotask in East Greenbush


UTC : Mon, Oct 12 2015 21:30 - 23:30
Event Time : Mon, Oct 12 2015 17:30 - 19:30 Eastern Daylight Time
Your Local Time: Mon, Oct 12 2015 21:30 - 23:30


26 Tech Valley Dr
East Greenbush, New York

Direction: None

Featured Presentation

Architecting Availability Groups

Speaker: Derik Hammer, Senior Database Administrator Ascension Information Services

Summary: You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you’ll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.

About Derik: I am currently working as a Production / Traditional DBA with Ascension Information Services. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Previous positions have landed me as Head of Database Operations followed by Data Architect at Liberty Tax Service. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.