March PASSMN Meeting (03/16/2010)

Posted by & filed under , , , , , .

It’s that time of the month again.  Time to network and learn about SQL Server with your peers.

Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
Date: March 16, 2010
Time: 2:30 – 5:00

Please click here for meeting details and to RSVP.

Registration has changed with the move from our previous hosting site and you will be required to log into www.sqlpass.org in order to register for our events. If you have any issues with this, please contact support@mnssug.org.

 

ABCs of CTEs
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
Louis Davidson

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