Category: Presentations

• Presentation Materials – Concurrency Control

  

  2011-07-26 - Presentations

  Abstract This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affects query concurrency and performance. [more…]

• Presentation Materials – Introduction to Test Driven Development for SQL Server

  

  2011-06-15 - Presentations

  This one-day class introduces the concepts of Test Driven Development in SQL Server.
  [more…]

• Presentation Materials – SQL Server Performance Monitoring Basics

  

  2011-06-09 - Presentations

  SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to [more…]

• Presentation Materials – Mining XML Query Plans

  

  2011-06-08 - Presentations

  Execution plans contain a lot of information that can guide you in your performance tuning process. Since SQL 2005 it is possible to retrieve the execution plans stored in the cache using DMVs and DMFs. However, as they are stored in XML format it can be cumbersome and difficult to extract the information you need.
  In this session, you will learn how the XML query plan is structured and how to use SQL Server’s built-in XQuery language to extract information. Examples include indexes that the optimizer indicates would increase performance if implemented and queries that use table scans or nested loop joins. [more…]