Presentations

On this page you can find my speaking history, as well downloadable materials from my presentations.

Faster Transactions: Query Tuning for Data Manipulation

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.

(Download slides and scripts)

SELECT Start FROM Here: Querying for T-SQL Beginners

Have you been asked to begin querying data in SQL Server databases? Or are you just curious to try T-SQL? Great – let’s get started! In this session we’ll cover the basics of the SELECT statement, your T-SQL tool for getting that data. We’ll also show the individual parts of a query, discuss basic aggregation, and demonstrate common filtering options using operators and functions. You’ll walk away with a solid foundation, ready to start your journey to become a T-SQL expert.

(Download slides and scripts)