User Group Support Services - User Group Event

Event information
User Group Name:	PASSMN - Minnesota SQL Server User Group
Event Title:	PASSMN March 2010 Meeting
Event Description:	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 Agenda: 2:30 –3:00 : Networking 3:00 –3:15 : Announcements 3:15 –3:25 : Sponsor 3:25 –4:25 : ABCs of CTEs (Jason) 4:25 –4:30 : Break 4:30 –5:30 : Database Design Fundamentals (Louis) Presentations: ABCs of CTEs 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. Jason Strate www.jasonstrate.com Jason Strate, Digineer Inc, is a database architect and administrator with over twelve years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Database Design Fundamentals 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). Session Level: Intermediate Louis Davidson http://drsql.spaces.live.com I have been in the IT industry for 16 years as a corporate database developer and architect. I have been a Microsoft MVP for 6 years and have written 4 books on database design. Currently I am the Data Architect for the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. I have a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics.
Event Time:	16 March 2010 15:00 to 16 March 2010 17:30 (GMT-6: Central Time US & Canada)
Event Location:	8300 Norman Center Drive Suite 900, Bloomington, Minnesota, 55437, United States
Event URL:	http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=354
Programming Language Topics:	VB.NET, SQL
Technology Area Topics:	SQL Server and Data Access, Enterprise Architecture and Patterns, Microsoft