|
|
|
|
|
|
Start Date:
|
3/16/2010
|
|
End Date:
|
3/16/2010
|
|
Start Time:
|
2:30:00 PM
|
|
End Time:
|
5:30:00 PM
|
|
Timezone:
|
(GMT-06:00) Central Time (US & Canada)
|
|
|
|
|
|
ABCs of CTEs & Database Design Fundamentals
|
|
|
|
|
ABCs of CTEs & Database Design Fundamentals
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.
|
|
|
|
|
Community Event
|
|
|
|
|
|
Return To Events
|
|
|
|
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.
PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
|
|