Stamford – SQL Server User Group

I am delighted about the opportunity to present to the Stamford SQL Server User Group on December 16, 2013.

I have not had the pleasure in visiting UCONN’s campus in Stamford, CT. In fact, I have not been in that city since SQL Saturday New York last August. I am looking forward to seeing Tim Harkin and meeting members of his group.

To finish the night, I will definitely be stopping at the Southport Brewing Company Restaurant before I go home.

Here is the gritty details of the presentation that I will be covering that night.


How isolated are your sessions?


Have you ever executed a T-SQL program that crashed due to an integrity error? Upon inspecting the job history, the error code states you have duplicate key values. However; re-running the job does not reproduce the error. You probably had an transaction isolation level issue without knowing it.

I will be covering the following topics in this presentation.


1 – Maintaining the ACID quality of transactions.
2 – How SQL Server implements transaction durability?
3 – System versus User transactions
4 – Transaction basics
5 – Exploring the various transaction modes
6 – Exclusive versus Shared locks
7 – Blocking versus Deadlocks
8 – How to detect them with my free code.
9 – How Isolation levels affect transaction behavior.
10 – What is a dirty read versus a phantom read?

At the end of the talk, you will know how to fix the above scenario by changing the isolation level.

presentation bundle

Related posts

Leave a Comment