{"id":6472,"date":"2013-12-15T00:00:49","date_gmt":"2013-12-15T00:00:49","guid":{"rendered":"http:\/\/craftydba.com\/?p=6472"},"modified":"2016-04-20T01:51:08","modified_gmt":"2016-04-20T01:51:08","slug":"stamford-sql-server-user-group","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=6472","title":{"rendered":"Stamford – SQL Server User Group"},"content":{"rendered":"

I am delighted about the opportunity to present to the Stamford SQL Server User Group<\/a> on December 16, 2013. <\/p>\n

I have not had the pleasure in visiting UCONN’s campus<\/a> 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. <\/p>\n

To finish the night, I will definitely be stopping at the Southport Brewing Company<\/a> Restaurant before I go home.<\/p>\n

Here is the gritty details of the presentation that I will be covering that night.<\/p>\n

Topic:<\/span><\/p>\n

How isolated are your sessions?<\/p>\n

Abstract:<\/span><\/p>\n

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.<\/p>\n

I will be covering the following topics in this presentation.<\/p>\n

Coverage:<\/span><\/p>\n

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

At the end of the talk, you will know how to fix the above scenario by changing the isolation level.<\/p>\n

presentation bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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…<\/p>\n","protected":false},"author":1,"featured_media":7269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[931,934,932,933,15,928,508,509,28,938,927,798],"class_list":["post-6472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-blocking","tag-connecticut","tag-deadlocks","tag-isolation-levels","tag-john-f-miner-iii","tag-locks","tag-pass","tag-presentation","tag-sql-server","tag-stamford","tag-transactions","tag-user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6472"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6472\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/7269"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}