www.sqlpass.org    Professional Association for SQL Server

Sponsors

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

sql_ca_sm.gif 

Office 365 

 

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

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

 

Next Event

Next Meeting: Wed, Sep 24 2014

Twice in a Lifetime: T-SQL Refactoring 101

Speaker: Mike Donnelly, Consultant Digineer

Summary: Whether it’s because you inherited the code from the “last guy,” or your stored procedures haven’t been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn’t just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn't know about five years ago. This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can’t be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.

About Mike: Mike works for Digineer as a SQL Server Consultant in the Twin Cities. He has been working with SQL Server for 13 years, holds the MCSE: Data Platform certification and currently serves as the chapter leader for PASSMN. He is an avid runner, blogger, and a wannabe gourmet chef.

Agenda

5:30 PM - 6:00 PM: General Announcements
6:00 PM - 6:30 PM: Dinner & networking
6:30 PM - 7:45 PM: Main Presentation
7:45 PM - 8:00 PM: Closing comments & wrap-up

When

Event Time : Wed, Sep 24 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

None

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

Twitter

PASS Summit 2014

 Save $150

&

help MADPASS

when you use

discount code

USMIS33

at 

registration!