Skip Main Navigation
Page Content
This event has ended

Discovering the Plan Cache

Digineer, Turn Results On

Thursday, February 16, 2012 from 1:00 PM to 2:00 PM (CST)

Discovering the Plan Cache

Ticket Information

Type End Quantity
Discovering the Plan Cache Ended Free  

Share Discovering the Plan Cache

Event Details

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.  Using XQuery to browse and search the plan cache can help you find potential performance issues and opportunities to tune your queries.  Additionally, this information  can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or simply just  discovering  exactly which queries are using what indexes.  All of this and more is readily available through the plan cache.

In this session, MVP Jason Strate will explore the plan cache and start you on your road to discovery.

Date: Thursday, February 16, 2012

Time: 1:00 PM – 2:00 PM CT

Speaker: Jason Strate, MVP

Hosted by: Digineer,Turn Results On (www.digineer.com)

About the Speaker:

Jason Strate, Digineer Inc, is a database consultant with over fifteen years of experience. 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. He is a recipient of the Microsoft Most Valuable Professional (MVP) award for SQL Server since July 2009. He also knows how to make a mean grilled cheese sandwich.

 

Have questions about Discovering the Plan Cache? Contact Digineer, Turn Results On

When

Thursday, February 16, 2012 from 1:00 PM to 2:00 PM (CST)


  Add to my calendar

Organizer

Digineer, Turn Results On

MDX Trek: First Contact

WEDNESDAY, AUGUST 1, 2012

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions.

In this session, Digineer's very own Mark Vaillancourt will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment and take you to a place no man has gone before.

Date: Wednesday, August 1, 2012

Time: 1:00 PM – 2:15 PM CT

Speaker: Mark Vaillancourt

Hosted by: Digineer, Turn Results On (www.digineer.com)

About the Speaker:

Mark is an information management consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server for 5 years and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in theater and improvised comedy, Mark makes sure that his presentations are both informative and fun.

 

 

 

 

 

  Contact the Organizer

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.