www.sqlpass.org    Professional Association for SQL Server
Sponsors Minimize  

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

sql_ca_sm.gif 

Office 365 

 

   
Minimize  

Please REGISTER or LOGIN to the site to become a MADPASS member!

   
MADPASS
Welcome Minimize  

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 - Short Presentation
6:15 - 6:45 - Food & Networking
6:45 - 7:45 - Main Presentation
7:45 - 8:00 - Door Prizes & Q&A Session

Meeting Location:  2310 Crossroads Drive Madison, WI 53718. 
It's the building with the Cisco sign facing the interstate near East Towne Mall.

 

   
EventDisplay Minimize  

Next Meeting: Wed, Aug 27 2014

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

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

Summary: 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.

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.

When

Event Time : Wed, Aug 27 2014 17:30 - 20:00 Central Daylight Time
Add the meeting to your calendar: iCal

Where

Meeting Location: 2310 Crossroads Dr Madison, Wisconsin


Directions: It's the building with the Cisco sign facing the interstate near East Towne Mall. Park behind the building and walk in main entrance. Our room will be straight ahead on the first floor. Get a Bing map to the meeting location.

Online Meeting

https://meet.lync.com/madpass/madpass/BWLU4YKF

If you are having trouble joining the meeting, try adding ?sl=1 to the URL to use the Lync web client.

Need Lync? (64-bit) (32-bit)Other Downloads

Attachments

   
Useful Links Minimize  
   
Twitter Minimize  
   
PASS Summit 2014 Minimize  

 Save $150

&

help MADPASS

when you use

discount code

USMIS33

at 

registration!