MADPASS

Welcome

The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server. We are here to support the SQL Server users in the Madison, WI area. We plan to meet on the fourth Wednesday of every month.

Meetings are always FREE and food is provided. Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session. Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Door Prizes&Q&ASession & Wrap-up

PASS Summit 2017 - This annual connference is back in Seattle, WA again. Early registrations are going on right now! PLUS, we have a special code that you can use to knock off a whopping $150 from the registration fees! Take advantage of these low rates and our special code... PASS Summit 2017

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

August

23

Laying Down the Law with Resource Governor

5:30 PM - 5:45 PM: General Announcements
5:45 PM - 6:15 PM: Dinner & Networking
6:15 PM - 7:30 PM: Main Presentation
7:30 PM - 7:45 PM: Wrap-up

Featured Presentation:

Laying Down the Law with Resource Governor

Lonny Niederstadt, Systems Engineer Epic

Even on an adequately-sized database server, mixed workload patterns can present resource utilization and performance challenges. Even with prior testing and careful code promotion, runaway queries can disrupt normal business activities. SQL Server gives a number of tools to control both resource access and pace of work. In this session we'll stress SQL Server with a set of workloads to illustrate several Resource Governor strategies in SQL Server 2016. We'll also look at some SQL Server resource controls and throttles outside of Resource Governor.

About Lonny:
For 17 years, Lonny has worked with EMR databases for Epic in Wisconsin. His current work includes SQL Server performance & scalability investigations, and developing best practices from research results. Lonny lives in Fitchburg, Wisconsin with his wife and two daughters. In his spare time, Lonny enjoys long walks in the woods, and considers himself extremely lucky every time he finds his way home again.

Connect with us!

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

Back to Top