February 2010 SQL Lunches

#10-Introduction to Partitioning

Report Builder
Speaker: Patrick LeBlanc

View Recording: Watch Now!

Download: Download Now!

BIO: Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He has written several blogs and articles on his blog at http://patrickdleblanc.com, www.sqlservercentral.com and www.bidn.com. Along with his 10+ years experience he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of four SQL Server books. His past work experiences include Sr. Consultant at Pragmatic works and Database Architect at several companies. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community.

Topic: #10-Introduction to Partitioning
Table Partitioning was introduced in SQL Server 2005. In this session I will give you a high-level overview of how to implement partitioning and a few tips for validating your implementation.

#11-Introduction to Graphical Execution Plans

Report Builder
Speaker: Brad McGehee

View Recording: Watch Now!

Download:  Not Available

BIO: Brad M. McGehee (www.bradmcgehee.com) is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 15 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge. In 2009, Brad made 33 public presentations to a total of 1,853 attendees, in six different countries. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 100 published articles. His most recent books include “How to Become an Exceptional DBA (2nd Edition)”, “Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs”, “Mastering SQL Server Profiler”, and “Brad’s Sure Guide to Database Maintenance Plans”. These eBooks are available free in PDF format at: http://www.sqlservercentral.com/Books/.

Topic: #11-Introduction to Graphical Execution Plans
One of the black arts of being a DBA is learning how to read and interpret graphical execution plans. This is an important skill, as knowing how to read and interpret graphical execution plans can help the DBA tune queries for optimal performance. Without this crucial knowledge, the DBA won’t be able identify potential query problems, nor understand how to fix them. In this short, introductory level session, which is designed for DBAs with little or no knowledge of query execution plans, you will learn why execution plans are important, how they are created, learn about the different execution plan formats, discover different ways to produce them, find out about the difference between estimated and actual execution plans, and learn the basics of how to read them. Because this is an introductory session, after attending, I highly recommend you download this free eBook to learn more about execution plans: “SQL Server Execution Plans” by Grant Fritchey. http://www.sqlservercentral.com/articles/books/65831/ This session assumes attendees have a basic foundation of DBA knowledge. After attending the session, attendees will be able to immediately put what they have learned into practice.