SQL Server Query Tuning Workshop |

Dear SQL Server developers,

Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to query tuning? When you look at execution plans, do you understand how to interpret and analyze them? Are your queries slow? And yet you don’t know how to fine tune them and improve them?

Because of these reasons I’m holding my SQL Server Query Tuning Workshop that will cover everything you need to know about SQL Server query tuning. Take a look at what you get:

Strategies to solve all your day-to-day query tuning problems – especially the ones you hate the most!
Ways to make your database faster – even if you have already tried everything!
How to get faster performance – as much as 1,000 TIMES better – just by working on a few specific queries in your database!
Why you can use my proven methods to solve problems – INSTEAD OF buying new hardware!

Whether you are “new” to SQL Server query tuning and you want everything from the “BASICS” on up to the “EXPERT” level, that’s what you’ll get at my workshop. I don’t leave ANYTHING out. You’ll also appreciate the REAL-WORLD KNOW-HOW you will get from attending my workshop. It’s not “theory” or “wishful thinking.”

Here is some feedback

Bob from Zoetermeer, Netherlands

"The SQL Server Query Tuning Workshop helped me as a developer to realize how important a good indexing strategy is for a responsive application. In my opinion every developer, working with SQL Server, should know how the indexes are build up, and how the query optimizer is getting to his query plan."

5.0

2015-01-22T12:38:33+00:00

https://www.sqlpassion.at/archive/testimonials/bob-from-zoetermeer/

Roger from Hertogenbosch, Netherlands

"During the workshop I have learned a lot about the query optimizer internals and how I can use that knowledge to write optimal performing queries. Klaus obviously knows a lot about these topics and is able to teach them very well. I can’t wait to attend one of his workshops in the near future."

5.0

2015-01-13T15:28:08+00:00

https://www.sqlpassion.at/archive/testimonials/roger-from-hertogenboschnetherlands/

Thomas from St. Margrethen, Switzerland

"I was lucky enough to attend the 4 day long SQL Server Query Tuning Workshop from Klaus in Zurich. He has presented in a very easy way the performance related internals of SQL Server that will help you to write better performing SQL queries. Based on that knowledge I finally know now why sometimes queries are fast, and sometimes are slow. It was an amazing workshop, which makes the day-to-day work with SQL Server now very easy."

5.0

2015-01-13T15:23:09+00:00

https://www.sqlpassion.at/archive/testimonials/thomas-from-st-margrethenswitzerland/

Arun from London, United Kingdom

"My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address performance issues that came up this week in capacity testing."

5.0

2015-01-13T15:19:20+00:00

https://www.sqlpassion.at/archive/testimonials/arun-from-londonunited-kingdom/

Bernd from Monheim, Germany

"After attending the 4 days long workshop you know very exactly how SQL Server executed SQL queries on the logical and physical level through execution plans. In addition you will know how you can improve queries by applying the right indexing strategy. This in-deep knowledge was very well explained and presented by Klaus."

5.0

2015-01-13T15:22:12+00:00

https://www.sqlpassion.at/archive/testimonials/bernd-from-monheimgermany/

Ina from Oberhaching, Germany

"Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries and their optimization."

5.0

2015-01-13T15:21:05+00:00

https://www.sqlpassion.at/archive/testimonials/ina-from-oberhachinggermany/

Willem from Maastricht, Netherlands

"I’ve never gained this level of database knowledge in this short period of five days! Furthermore Klaus provides enough valuable studymaterial such as scripts, tips, weblinks to articles and so on to help you in your day-to-day life as a SQL DBA or Developer."

5.0

2015-10-16T11:45:06+00:00

https://www.sqlpassion.at/archive/testimonials/willem-from-maastrichtnetherlands/

Ronald from De Meern, Netherlands

"Klaus explains the "Double Edged Sword of Indexing" and provides a solution to measure the impact of changes in the Indexing Strategy very clear!"

5.0

2015-10-16T11:47:36+00:00

"Klaus explains the "Double Edged Sword of Indexing" and provides a solution to measure the impact of changes in the Indexing Strategy very clear!"

https://www.sqlpassion.at/archive/testimonials/ronald-from-de-meernnetherlands/

Wang from Stuttgart, Germany

"It is a very intensively SQL server query tuning workshop in Frankfurt last week. I have learned a lot of things about query tuning from Klaus, such as "Execution Plans", "Index Tuning", "Statistics & Plan Cache" etc. As he said he don’t leave anything out, that you need know all about SQL Server query tuning. I highly recommended this workshop to my colleagues. I'm looking forward to attend another workshop by Klaus in the near future."

5.0

2016-05-08T11:23:01+00:00

https://www.sqlpassion.at/archive/testimonials/wang-from-stuttgartgermany/

Jago from Hilversum, Netherlands

"I have been working at Microsoft SQL support for 5 years but still learned in this week so many things I didn't know about."

5.0

2016-11-23T10:54:48+00:00

"I have been working at Microsoft SQL support for 5 years but still learned in this week so many things I didn't know about."

https://www.sqlpassion.at/archive/testimonials/jago-from-hilversumnetherlands/

5.0

Agenda & Breakdown

Query Processing

Execution Plans

Overview
Input Trees
Estimated Execution Plan
Actual Execution Plan

How to access your data through Indexes

Clustered Index
Non-Clustered Index
Index Scans
Index Seeks

Physical Operators

Data Access Operators
Join Operators
Aggregation Operators
Spool Operators
Halloween Protection

Index Tuning

Index Tuning Strategies

Search Arguments
Bookmark Lookups
Tipping Point
Index Intersection
Filtered Indexes
Indexed Views

GUIDs as Primary Key Values

Overview
Index Fragmentation
Fill Factor
Primary Key as Non-Clustered Index
Latch Contentation

Statistics & Plan Cache

Statistics

Auto Create
Auto Update
Statistics Analysis
Multi Column Statistics

Cardinality Estimation

Conjunctions
Disjunctions
Ascending Key Column Problem

Plan Caching

Adhoc Query Caching
Parameterization
Optimize for Adhoc Workloads

Parameter Sniffing

Local Variables
Recompilations
Plan Guides

Parallel Execution Plans

Overview

Why Parallelism
Advantages
Configuration Options

Working with Parallelism

Exchange Operators
Demystifying CXPACKET Waits
Best Practices

ColumnStore Indexes

Overview

Why ColumnStore Indexes
Advantages
Limitations

Changing Data

Trickle Loading
Partition Switching
Improvements in SQL Server 2014/2016

Operational Analytics

Why Operational Analytics
Indexing Guidelines
Improvements in SQL Server 2016

In-Memory OLTP

Overview

Why In-Memory OLTP
Advantages
Limitations

Working with In-Memory OLTP

Memory Optimized Tables
Hash Indexes
Range Indexes
Hash Collisions
Native Compiled Stored Procedures

Transaction Processing

Writer-Writer Conflicts
Read-Write Conflicts
Serializable Violation Conflicts
Snapshot Violation Conflicts

Scalability

SQL Server Query Tuning Workshop