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, Nov 19 2014

Bridging The Gap: Embracing Set-Based Thinking

Speaker: Larry Toothman, Database Administrator UnityPoint Health

Summary: For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.

About Larry: Larry has a BFA in Theatre and several MS certifications. He has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the "SQL Family" Larry is always looking for opportunities to pay it forward, spread the word & mentoring.

Agenda

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

5:45 PM - 6:30 PM -- Food & Networking

6:30 PM - 7:45 PM -- Main Presentation

7:45 PM - 8:00 PM -- Wrap-up

 

 

When

Event Time : Wed, Nov 19 2014 17:30 - 20:00 (GMT-06:00) Central Time (US & Canada)
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/DHBJL400

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!