Special FREE event at QuickStart Intelligence in Irvine, Monday December 9th.
Jason Strate and Bradley Ball will be visiting Southern California on Dec 9th. They are part of the PASS community and have offered to speak to the local SQL Server Community.
Enjoy pizza and networking from 6:30 to 7:00 pm followed by two great presentations by Jason and Bradley.
Please register at Eventbrite as there are a limited number of seats available.
BIO: Jason StrateJason is a SQL Server database architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. He writes, blogs, and presents on SQL Server and has been known to let loose with karaoke and unicorns
Session: Performance Tuning with SQL Server’s Plan Cache
Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
BIO: Bradley Ball
Bradley Ball is a MCITP 2005 & 2008 DBA with over a decade of experience. Currently the Data Platform Management Lead with Pragmatic Works specializing in DBA solutions, he has presented at many SQL Saturdays, for PASS SSUG’s, SQL Rally, DevConnections & the PASS Summit. He wrote Chapter 14 Page & Row Compression for PRO SQL Server 2012 Best Practices and he can be found blogging on http://www.sqlballs.com about SQL Server or anything else that interests him.