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 third 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 - Q&A Session / Door Prizes / Wrap-up

 

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

August

27

Election Night & Every Byte Counts: Why Your Datatype Choices Matter

5:30 PM - 5:45 PM: General Announcements

5:45 PM - 6:00 PM: Election Candidate Mini-Speeches

6:00 PM - 6:15 PM: Election

6:15 PM - 6:45 PM: Dinner & networking

6:45 PM - 8:00 PM: Main Presentation

8:00 PM: Closing comments & wrap-up

You can vote in the election in person at this meeting. If you are unable to attend the meeting, you can vote by mail. Download this ballot and mail it in with the instructions on the ballot.

Featured Presentation:

Every Byte Counts: Why Your Datatype Choices Matter

Andy Yun, Senior MS SQL Server Database Developer The SAVO Group

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.

About Andy:
Once a DBA, Andy is a Database Developer and self-proclaimed T-SQL performance junkie. Over the past decade, he has worked with SQL Server in highly transactional environments, in the trading and credit card industries. Leveraging knowledge of SQL Server Internals, Andy strives to make T-SQL leaner and meaner. He is very passionate about the SQL Server community, loves making new connections, and is excited to keep presenting. Andy is a co-leader of the recently restarted Chicago Suburban SQL Server User Group PASS Chapter.

Connect with us!

 

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids