I’m excited to announce that I will be hosting a full day workshop on Query Performance Tuning in SQL Server. This workshop will be held on Friday, September 19th, 2014 at SQL Connections. Whether you are working on SQL Server 2005 or the latest version, SQL Server 2014, this workshop will provide valuable insights and techniques to optimize your query performance.

The workshop will begin by covering the different mechanisms available to capture query metrics. We will explore dynamic management objects and extended events, which are essential in understanding which queries need tuning. Understanding how the optimizer works is crucial, and we will delve into the importance of statistics, indexes, and constraints in helping the optimizer make informed choices. Throughout the day, we will extensively cover execution plans, as they are fundamental in understanding the choices made by the optimizer.

Common problems in query performance will be discussed, along with methods to identify, troubleshoot, and solve them. We will debunk myths and address easily fixable issues. The workshop will cover both older versions of SQL Server and SQL Server 2014, ensuring that attendees gain a comprehensive understanding of query tuning techniques.

To conclude the day, we will explore the new opportunities unique to SQL Server 2014, including their usage and limitations. By the end of the workshop, attendees will have the knowledge and tools to identify problematic queries, understand the underlying issues, and implement effective solutions. You will gain the ability to read execution plans and develop a fascination for extended events. The techniques and methods learned can be applied to your own code, applications, and servers.

Don’t miss out on this incredible opportunity to enhance your query tuning skills. Register now for the workshop at SQL Connections. This workshop will be held after the IT/Dev Connections event in Vegas, making it a perfect way to continue your learning journey.

Join me for a full day of query tuning and take your SQL Server performance to the next level!

The post A Full Day of Query Tuning appeared first on Home Of The Scary DBA.