SQLRally Session Submissions

StrateSQL, 2010-12-16

SQLRally Winner[11]

Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session.  I’m not going to be a pot calling the kettle black.

Below are the two sessions that I submitted.  Hopefully they will appeal to enough people that I’ll get a chance to present one of them at SQLRally.

Discovering the 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.


  • Understanding of basic T-SQL coding
  • Understanding of basic XQuery statements


  1. Discuss information available in an execution plan
  2. Demonstrate use of XQuery to query plan cache
  3. Demonstrate methods to use the plan cache for performance tuning


XQuery Basics for the DBA

For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery. Oh, and if you aren’t a DBA you can come to.


  • Understanding of basic T-SQL coding


  1. Discuss the importance of learning XQuery
  2. Discuss the XQuery methods
  3. Demonstrate methods of using XQuery

Related posts:

  1. Last Call SQLRally Call for Presenters
  2. PASS Summit Submissions Complete
  3. SSWUG Spring ’10 Ultimate Virtual Conference





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads