{"id":6432,"date":"2013-11-12T00:00:04","date_gmt":"2013-11-12T00:00:04","guid":{"rendered":"http:\/\/craftydba.com\/?p=6432"},"modified":"2016-04-21T20:26:13","modified_gmt":"2016-04-21T20:26:13","slug":"6432","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=6432","title":{"rendered":"Providence \u2013 SQL Server User Group"},"content":{"rendered":"<p>I am driving thru <a href = \"http:\/\/www.offices.net\/city-slogans.htm#P\"> America&#8217;s Renaissance City<\/a>, Providence Rhode Island, to present to the Southern New England SQL Server User Group (SNESSUG) on November 13, 2013.  <\/p>\n<p>I always love the home team advantage by knowing the audience very well.  It makes for a relaxing environment to teach and attendees to learn.<\/p>\n<p>Here is the gritty details of the presentation that I will be covering that night.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p>How isolated are your sessions?<br \/>\n<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 thru America&#8217;s Renaissance City, Providence Rhode Island, to present to the Southern New England SQL Server User Group (SNESSUG) on November 13, 2013. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Here is the gritty details of the presentation that I will be covering that night. &nbsp; &nbsp; Topic: How isolated are your sessions? Abstract: Have you ever executed a T-SQL program that crashed due to an integrity error? Upon&hellip;<\/p>\n","protected":false},"author":1,"featured_media":5523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[931,932,930,933,15,928,508,509,796,929,839,28,927,798],"class_list":["post-6432","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-blocking","tag-deadlocks","tag-exclusive","tag-isolation-levels","tag-john-f-miner-iii","tag-locks","tag-pass","tag-presentation","tag-rhode-island","tag-shared","tag-snessug","tag-sql-server","tag-transactions","tag-user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6432","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=6432"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6432\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/5523"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}