Chapter site: http://Mem-PASS.org

Registration: to join our group, please register by visiting the UGSS website. Use the "Access Code": MEM-PASS-Member.  If not joining, email  Dan.Evans@mem-pass.org or Alvin.Ramard@mem-pass.org to make sure there’s enough food. I’d recommend joining in order to get future meeting announcements.

Reminder: Next meeting is Thursday, Dec 10th, next week. This end of year meeting will be a big one...

Make plans to attend the end of year meeting of MEM-PASS. We will have a national PASS speaker, Louis Davidson, coming to share his thoughts on database design. Tell EVERYONE so we can have a good turnout!

Topic: Database Design

When: Thursday, Dec 10th - Pizza at 5:30 PM - Meeting at 6:00 PM

Where: New Horizons, 4775 American Way, Memphis, TN, 38118

Description: 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). Properly structured data structures make it easier to work with data in simple SQL statements rather than having to resort to functional programming and cursors. In this session we will give an overview of the common normal forms and show why they should matter to you if you are creating or modifying SQL Server databases.

Speaker Bio:

Who is Louis Davidson? Just an ordinary person like you who puts his pants on two legs at a time (try it sometimes, it is 50% faster.) Louis has been in the IT industry for more than 15 years as a corporate database developer, architect, as well as serving on the permanent unofficial committee to make sure the Internet still works. The majority of his experience has been with Microsoft SQL Server, in every version that has been released since 4.21a. Currently he is a senior data architect for Compass Technology, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. If you want a gander at the resume, you can get it here.

Louis has a bachelor’s degree in computer science from the University of Tennessee at Chattanooga, with a minor in mathematics. He has been volunteering with the Professional Association for SQL Server (PASS) for more than 5 years. He has spoken at several of the PASS conferences, though it can be said that as a speaker, he is a good writer.

In October 2004, he was awarded the Most Valuable Professional (MVP) award for SQL Server by Microsoft, an honor he is very proud to have been given. In his “free” time, he writes articles for his blog http://drsql.spaces.live.com, and answer questions on the Microsoft SQL Server newsgroups and forums.

Louis has written two books on database design (well, really three but the second one is really a retouching of a book he did for a company that no longer technically exists.)