Central Wis PASS

Welcome to the Central Wis PASS Chapter

The Central Wis PASS User Group (Central WI PASS) is an official chapter of the Professional Association for SQL Server.  Our mission is to provide SQL Server users in the north-central Wisconsin area with training and networking opportunities.  Meetings are free and open to anyone.  We meet quarterly on the 3rd Wednesday of the month at Sentry Insurance Stevens Point.   Meeting details can be found on our Events page.


Next Meeting: Wed, Jan 17 2018

January Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/wausau-point-pass-january-meeting-tickets-41945643549

CORRECTION:  The meeting will be held virtually at http://youtu.be/13y-Uxk_o7U.  See you there!

Soda and snacks will be provided at the meeting.  Our topic for this meeting will be "Architecting Availabilty Groups" presented by Derik Hammer.


UTC : Thu, Jan 18 2018 00:30 - 02:30
Event Time : Wed, Jan 17 2018 18:30 - 20:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Thu, Jan 18 2018 00:30 - 02:30


1800 Northpoint Drive
Stevens Point, Wisconsin

Direction: Meeting is located in the Center for Business and Industry (smaller building to left of main entrance with it's own parking lot). Permits are required if parking prior to 5:00 PM (see front desk in CBI building for permit). Meeting is located in Room #124.

Featured Presentation

Architecting Availability Groups

Speaker: Derik Hammer, Senior Database Administrator Subway (Franchise World Headquarters, LLC)

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 Database Operations Team Lead with Subway World Headquarters. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Almost all of my previous experience has resided firmly in the traditional / production DBA realm. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.


Our Sponsors


Back to Top