|
|
|
|
|
|
Date:
|
7/28/2010
|
|
Start Time:
|
12:00:00 PM
|
|
End Time:
|
1:00:00 PM
|
|
Timezone:
|
(GMT-05:00) Eastern Time (US & Canada)
|
|
|
|
|
|
DBA Virtual Chapter Live Meeting Event
|
|
|
|
|
Topic: Using XML to Query Execution Plans
Speaker: Jason Strate
Abstract: SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your fingertips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. In this session we'll look at how you can begin to understand and query the structure of the execution plans in the procedure cache. Also, we'll review how to uncover some potential performance issues that may be lurking in your SQL Server.
Bio: 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. He is actively involved with the local PASS chapter (SQL Server User Group) and is currently serving as the Director of Program Development. In the past year, Jason has presented at the 2009 PASS Summit, SSWUG Virtual Conferences, TechFuse 2009/2010, SQL Saturdays, and at PASSMN user group meetings.
Door Prize: $50 Amazon Gift Certificate
You do not have to register in order to attend the meeting, but if you want to enter the drawing for the gift certificate, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=9llj1hqt2pf45g02 no later than 5:00 PM Eastern on July 27
Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=Q7CT4H&role=attend
This meeting is sponsored by  |
|
|
|
|
Community Webcast
|
|
|
|
|
|
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.
|
|