SQLSaturday #193 Phoenix–Randy Knight

Randy Knight, President and Principal Consultant at SQL Solutions Group and a Microsoft Certified Master, shared two presentations at the Phoenix SQLSaturday event on April 27, 2013.

Understanding Transaction Isolation Levels.”

SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inappropriate) use cases for each.

But it worked great in Dev! Performance for Devs

If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, execution plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

 
 
Loading Map....

Date/Time
Date(s) - 04/27/2013
8:00 AM - 5:30 PM

Location
Chandler-Gilbert Community College Pecos Campus

Categories