“BEGIN…COMMIT” is Not Enough: Understanding Transactions

Speaker: Denise McInerney, Staff DBA at Intuit (http://www.intuit.com/)

Denise will explain the fundamentals of transactions and how they behave in SQL Server. She will delve into ACID properties, isolation levels and nested transactions. She'll also review how to structure transactions to satisfy business rules and ensure efficient performance.

You'll see live demos, including the behavior of implicit and explicit transactions the differences between various isolation levels and how nested transactions work.

You'll Learn:

• The ACID properties of transactions
• The different isolation levels supported by SQL Server
• How to code transactions that protect your data integrity
• Why you can’t take transactions for granted.

Denise McInerney is a Staff DBA at Intuit in Mountain View. Her focus is design and performance tuning OLTP databases that support web-based applications. Her primary job is to design, tune and manage databases that support one of the company’s eCommerce web sites.

Denise has served on the PASS (http://www.sqlpass.org/) Program Committee. She also founded the PASS Women in Technology Virtual Chapter (http://twitter.com/#!/pass_wit).