PASSMN March 16, 2010 Monthly Meeting
Posted by denglishbi on March 7, 2010
The next Minnesota SQL Server User Group meeting is coming up in a couple of weeks on Tuesday, March 16 from 3 to 5:30 at the local Microsoft office in Bloomington. This month we will be looking at common table expressions (CTEs) and database design and both sessions will be done by SQL Server MVPs, Jason Strate and Louis Davidson. The second presentation will be done remotely by Live Meeting.
In order to RSVP for the event you will need to login to the national PASS site and click on the RSVP link. This month our sponsor for the event is Idera.
PASSMN March 2010 Meeting – ABCs of CTEs & Database Design Fundamentals
- Meeting sponsor: idera
- Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
- Please RSVP here for the event to assist in making sure there is enough snacks and beverages ordered.
- Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=3QWHW4&role=attend&pw=r%22P%21_x%7C%3D3 Code: r"P!_x|=3 (to get the audio you will need to download and install the full Live Meeting client)
2:30 – 3:00 : Networking
3:00 – 3:15 : Announcements
3:15 – 3:25 : Sponsor
3:25 – 4:25 : ABCs of CTEs (Jason Strate)
4:25 – 4:30 : Break
4:30 – 5:30 : Database Design Fundamentals (Louis Davidson)
ABCs of CTEs (presented by Jason Strate) – Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
Database Design Fundamentals (presented by Louis Davidson – session level Intermediate) – In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).
We also added a new annual sponsor for our user group, Intertech. We are very excited to be expanding on our sponsor list for our user group and we will have some additional giveaways for this event.