{"id":6434,"date":"2013-11-19T01:21:04","date_gmt":"2013-11-19T01:21:04","guid":{"rendered":"http:\/\/craftydba.com\/?p=6434"},"modified":"2016-04-20T17:22:52","modified_gmt":"2016-04-20T17:22:52","slug":"hartford-sql-server-user-group","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=6434","title":{"rendered":"Hartford &#8211; SQL Server User Group"},"content":{"rendered":"<p>I am driving to the <a href =\"http:\/\/www.offices.net\/city-slogans.htm#H\">Insurance City<\/a> to present to the Hartford SQL Server User Group on November 19, 2013.  <\/p>\n<p>To-date, I have not been to Microsoft building in Farmington, CT.  It should be quite an adventure.  I am looking forward to seeing John Flannery and meeting members of his group.<\/p>\n<p>Here is the gritty details of the presentation that I will be covering that night.<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p>How isolated are your sessions?<\/p>\n<p><span style=\"color: #008000\">Abstract:<\/span><\/p>\n<p>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<p>I will be covering the following topics in this presentation.<\/p>\n<p><span style=\"color: #008000\">Coverage:<\/span><\/p>\n<p>  1 &#8211; Maintaining the ACID quality of transactions.<br \/>\n  2 &#8211; How SQL Server implements transaction durability?<br \/>\n  3 &#8211; System versus User transactions<br \/>\n  4 &#8211; Transaction basics<br \/>\n  5 &#8211; Exploring the various transaction modes<br \/>\n  6 &#8211; Exclusive versus Shared locks<br \/>\n  7 &#8211; Blocking versus Deadlocks<br \/>\n  8 &#8211; How to detect them with my free code.<br \/>\n  9 &#8211; How Isolation levels affect transaction behavior.<br \/>\n  10 &#8211; What is a dirty read versus a phantom read?<\/p>\n<p>At the end of the talk, you will know how to fix the above scenario by changing the isolation level.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2013\/11\/transactions.zip\">presentation bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am driving to the Insurance City to present to the Hartford SQL Server User Group on November 19, 2013. To-date, I have not been to Microsoft building in Farmington, CT. It should be quite an adventure. I am looking forward to seeing John Flannery and meeting members of his group. Here is the gritty details of the presentation that I will be covering that night. Topic: How isolated are your sessions? Abstract: Have you ever executed a T-SQL program that crashed due to an integrity error? Upon inspecting the&hellip;<\/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,936,933,15,928,508,509,28,927,798],"class_list":["post-6434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-blocking","tag-connecticut","tag-deadlocks","tag-hartford","tag-isolation-levels","tag-john-f-miner-iii","tag-locks","tag-pass","tag-presentation","tag-sql-server","tag-transactions","tag-user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6434","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=6434"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6434\/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=6434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}