Aha!

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:

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.”

Aha!

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
"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."

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
"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."

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
"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."

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
"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."

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
"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."

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
"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."

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
"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."

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!"

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
"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."

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."
5.0
10
Aha!

Agenda & Breakdown

img_day1
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

img_day1
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
  • The double edged sword of Indexing
    • Index Overhead
    • Workload Capturing
    • Workload Replay
    • Measure Index Impacts

img_day1
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

img_day1
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

img_day1
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

Aha!

Dates & Location

img_day1
April 24 – April 28 in Frankfurt/Germany

img_day1
May 29 – June 2 in Zurich/Switzerland

Aha!
SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top