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.