25 Things All SQL Server Developers Need to Know

August 18th 2016 13:00 - 17:00
Swang 112

Track: Programming Principles, Data
Level: Intermediate

What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

In this session, you’ll learn:

1. Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags.
2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.
3. A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.

With these 25 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance.

Kevin Kline avatar
Kevin Kline

Kevin Kline, a longtime Microsoft Data Platform MVP living in Nashville, is a founder and former president of SQLPASS.org, international speaker, and the author of popular IT books such as 'SQL in a Nutshell'. Kevin tweets at @kekline and blogs at http://blogs.sqlsentry.com/KevinKline.


This website uses cookies. By continuing to browse you agree to this and Conferize's terms of service.