Session: Hands-on Fundamentals for Good SQL Server Programming

SPEAKER: Kevin Kline, Director of Engineering Services, SQL Sentry

You’ve figured out how to write queries to read data, transactions to write and modify data, and Transact-SQL to bring programmability to your code. However, you’ve never taken your code beyond “It works. Put it in production!” This 24 Hours of PASS session will teach you the fundamentals of writing quality SQL and T-SQL code, code testing, and performance assessment. You’ll learn how to isolate your SQL code with a test harness, evaluate alternative approaches, and determine which version is optimal for your your workload. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries from adequate to outstanding.

To access your 24 Hours of PASS session recording, please provide the following: