{"id":2311,"date":"2006-06-13T03:25:00","date_gmt":"2006-06-13T03:25:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/the-dbas-demise-a-recitation\/"},"modified":"2016-07-28T10:48:49","modified_gmt":"2016-07-28T10:48:49","slug":"the-dbas-demise-a-recitation","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/the-dbas-demise-a-recitation\/","title":{"rendered":"The DBA&#8217;s Demise: a recitation."},"content":{"rendered":"<p>On a doorway in Dover<br \/>I once stumbled over<br \/>a programmer wrapped in a sheet<br \/>This poor prostrate nerd<br \/>didn&#8217;t utter a word <br \/>as he lay there half-blocking the street<\/p>\n<p>&#8220;From your face I can see<br \/>that you work in IT<br \/>what has brought you to this sorry state?&#8221;<br \/>This poor wretched geek<br \/>then started to speak<br \/>and told me his terrible fate<\/p>\n<p>Cruel fortune had picked him,<br \/>as sad deadlock victim.<br \/>The conflict had left him for dead;<br \/>for wise men don&#8217;t mess<br \/>with a deadlocked process<br \/>an incident DBAs dread.<\/p>\n<p>&#8220;When I&#8217;m dead, on my harp<br \/>I shall play in C#&#8221;<br \/>On my terminal, happy I&#8217;ll be.<br \/>I&#8217;m going offline <br \/>to a site that&#8217;s divine<br \/>where all pizza and coffee is free.&#8221;<\/p>\n<p>&#8220;Insert into grave <br \/>select * from poor Dave<br \/>And put on my gravestone &#8216;Raiserror!<br \/>a victim, one time<br \/>of a deadlocking crime&#8221;<br \/>Then he died with a look of sheer terror.<\/p>\n<p>(lines written on getting the famous , and dreaded error 1205, <em>&#8216;Your server command (proces id xx) was deadlocked with another process and has been chosen as deadlock victim. Please re-run your command&#8217;<\/em>, whilst listening to &#8216;The Streets of Loredo&#8217; on Internet Radio.)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On a doorway in DoverI once stumbled overa programmer wrapped in a sheetThis poor prostrate nerddidn&#8217;t utter a word as he lay there half-blocking the street &#8220;From your face I can seethat you work in ITwhat has brought you to this sorry state?&#8221;This poor wretched geekthen started to speakand told me his terrible fate Cruel&#8230;&hellip;<\/p>\n","protected":false},"author":154613,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-2311","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/154613"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=2311"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2311\/revisions"}],"predecessor-version":[{"id":41388,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2311\/revisions\/41388"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=2311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=2311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=2311"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=2311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}