Announcing Internals for Query Tuning Training Class By Kalen Delaney

Published On: 2015-12-03By:

expertWe at Denny Cherry & Associates Consulting are thrilled to announce that we have partnered up with the SQL Server internals guru Kalen Delaney to deliver training classes.  Our first class will be Internals for Query Tuning and will be held Monday-Wednesday April 4th, 5th and 6th of 2016 in Orange County, CA.

This is an advanced course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques.  While this course will focus on SQL Server 2014 the information presented will be relevant for older versions of SQL Server as well.  In addition, some of the changes due in the upcoming SQL Server 2016 will be described.

This three day course is made up of 6 parts which are outlined below.  The cost for this fantastic three day class is $2225 US.  Seating is limited, so get signed up today.

The outline for this class is:

Part 1: SQL Server Metadata

  • Architecture Overview
  • Metadata Overview
  • Dynamic Management Views

Part 2: Index Structures

  • Metadata for Storage
  • Space Allocation
  • Tools for Examining Physical Structures
  • Heaps and B-Trees
  • Clustered Indexes
  • Nonclustered Indexes
  • Fragmentation
  • Filtered Indexes
  • Rebuilding Indexes
  • Partitioning Overview
  • Creating and Maintaining Partitions
  • Metadata for Partitioning
  • Columnstore Index Storage

DAY 2

Part 3: Query Processing and Query Plans

  • SHOWPLAN Options
  • Query Plan Elements
  • Types of Joins
  • Aggregation
  • Sorting
  • Columnstore Indexes: Batch vs Row Mode
  • Data Modification

Part 4: Optimization and Recompilation

  • Optimization Overview
  • SQL Server’s Query Optimizer
  • Plan Management and Reuse
  • Causes of Recompilation
  • Forcing Recompilation
  • Plan Cache Metadata

DAY 3

Part 5: Index Tuning

  • Special Index Features
  • Statistics
  • Indexed Views
  • Covering Indexes
  • Filtered Indexes
  • Included Columns
  • Indexing Guidelines

Part 6: Query Tuning

  • Query Improvements
  • Search Arguments
  • Constants and Variables
  • User Defined Functions and Computed Columns
  • Plan Guides
  • Query Hints

The post Announcing Internals for Query Tuning Training Class By Kalen Delaney appeared first on SQL Server with Mr. Denny.


Contact the Author | Contact DCAC

3 responses to “Announcing Internals for Query Tuning Training Class By Kalen Delaney”

  1. Richard King says:

    How many openings are left for this class? I have to submit this as part of our training budget. May take a couple of business days to get an answer.

    • Denny Cherry says:

      Richard,
      We are plenty of seats left in the class. A couple of business days shouldn’t be a problem. We are in the middle of a large marketing blast about the class, so I’d let Management know you don’t want to wait to long.

  2. What are the times of each class? I couldn’t find it.

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner    Microsoft MVP    Microsoft Certified Master    VMWare Partner    VMWare vExpert
   Best Full-Service Cloud Technology Consulting Company    Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link