{"id":576,"date":"2008-04-28T01:29:12","date_gmt":"2008-04-28T01:29:12","guid":{"rendered":"\/blogs\/kimberly\/post\/Catching-up-on-resources-the-Accidental-DBA-workshops!.aspx"},"modified":"2013-01-02T06:56:54","modified_gmt":"2013-01-02T14:56:54","slug":"catching-up-on-resources-the-accidental-dba-workshops","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/catching-up-on-resources-the-accidental-dba-workshops\/","title":{"rendered":"Catching up on resources &#8211; the Accidental DBA workshops!"},"content":{"rendered":"<p><P>OK, we were in Iceland and then Florida for our Accidental DBA workshops and both went really well. People agree that there are quite a few involuntary\/accidental DBAs out there and overall, we helped quite a few to see a lot of options for better performance, availability, recovery, and\/or just manageability.<\/P><br \/>\n<P>So, this is our &#8220;resources post&#8221;. We waited until after the SQL Connections delivery to post these as we figured we might add a few more to the list (as is typical when you deliver content more than once &#8211; it&#8217;s really never the same twice!).<\/P><br \/>\n<UL><br \/>\n<LI>Checkout the whitepapers on SQLskills:<BR><A href=\"https:\/\/www.sqlskills.com\/whitepapers.asp\">https:\/\/www.sqlskills.com\/whitepapers.asp<\/A><br \/>\n<LI>Blog Post Tripp: 8 Steps to better Transaction Log throughput:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/2005\/06\/25\/8stepstobettertransactionlogthroughput.aspx\">https:\/\/www.sqlskills.com\/blogs\/kimberly\/2005\/06\/25\/8StepsToBetterTransactionLogThroughput.aspx<\/a><br \/>\n<LI>RD Grok Talks (general):<BR><A href=\"http:\/\/www.groktalk.net\/\">http:\/\/www.groktalk.net\/<\/A><br \/>\n<LI>Stored Procedure Grok Talk (Tripp):<BR><A href=\"http:\/\/www.groktalk.net\/Videos\/kimberly_l_tripp.wmv\">http:\/\/www.groktalk.net\/Videos\/kimberly_l_tripp.wmv<\/A><br \/>\n<LI>Stored Procedure Blog posts (Tripp):<BR><A href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/CategoryView,category,Optimizing%2BProcedural%2BCode.aspx\">https:\/\/www.sqlskills.com\/blogs\/kimberly\/CategoryView,category,Optimizing%2BProcedural%2BCode.aspx<\/A><br \/>\n<LI>MSDN Webcast Series (series wrap-up blog post with links):<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=4daca6d9-c52b-4f85-a47c-20f252883e20\">https:\/\/www.sqlskills.com\/blogs\/kimberly\/PermaLink.aspx?guid=4daca6d9-c52b-4f85-a47c-20f252883e20<\/a><br \/>\n<LI>Microsoft Events Calendar:<BR><a href=\"https:\/\/msevents.microsoft.com\/cui\/default.aspx?culture=en-US&amp;community=1\">http:\/\/www.microsoft.com\/events\/webcasts\/calendar\/monthview.aspx?audience=it%20professional&amp;series=0&amp;product=0&amp;presenter=0&amp;tz=0&amp;wt.svl=interactivecalendar<\/a><br \/>\n<LI>KB Article 329526: <STRONG><EM>File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005<\/EM><\/STRONG>:<BR><a href=\"http:\/\/support.microsoft.com\/kb\/329526\" class=\"broken_link\">http:\/\/support.microsoft.com\/kb\/329526<\/a><br \/>\n<LI>KB Article 328551: <STRONG><EM>Concurrency enhancements for the tempdb database<\/EM><\/STRONG>:<BR><A href=\"http:\/\/support.microsoft.com\/kb\/328551\">http:\/\/support.microsoft.com\/kb\/328551<\/A><br \/>\n<LI>Whitepaper: <STRONG><EM>Working with tempdb<\/EM><\/STRONG>:<BR><a href=\"http:\/\/technet.microsoft.com\/library\/Cc966545\">http:\/\/www.microsoft.com\/technet\/prodtechnol\/sql\/2005\/workingwithtempdb.mspx<\/a><br \/>\n<LI>KB Article 243586: <STRONG><EM>Troubleshooting stored procedure recompilation<\/EM><\/STRONG>:<BR><a href=\"http:\/\/support.microsoft.com\/kb\/243586\" class=\"broken_link\">http:\/\/support.microsoft.com\/kb\/243586<\/a><br \/>\n<LI>Whitepaper: <EM><STRONG>Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005<\/STRONG><\/EM>:<BR><a href=\"http:\/\/technet.microsoft.com\/library\/Cc966425\">http:\/\/www.microsoft.com\/technet\/prodtechnol\/sql\/2005\/recomp.mspx<\/a><br \/>\n<LI>For all of the different topics Paul discussed he placed links to corresponding blog posts, I&#8217;ve duplicated them here so you can get a refresher for these links: <\/LI><br \/>\n<UL><br \/>\n<LI><a class=\"navigatorLinksLinkStyle broken_link\" href=\"http:\/\/www.microsoft.com\/library\/errorpages\/smarterror.aspx?aspxerrorpath=http%3a%2f%2fwww.microsoft.com%2femea%2fspotlight%2fPaul_Randal_Secrets_to_Fast_Detection_and_Recovery_from_Database_Corruptions.aspx\"><STRONG><FONT color=#696969>TechEd 2007 video: Secrets of Fast Detection and Recovery from Database Corruptions<\/FONT><\/STRONG><\/a><br \/>\n<LI>Inside the Storage Engine: <STRONG><EM>Anatomy of a record<\/EM><\/STRONG>:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/30\/insidethestorageengineanatomyofarecord.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/30\/InsideTheStorageEngineAnatomyOfARecord.aspx<\/a><br \/>\n<LI>Inside the Storage Engine: <STRONG><EM>Anatomy of a page<\/EM><\/STRONG>:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/03\/insidethestorageengineanatomyofapage.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/03\/InsideTheStorageEngineAnatomyOfAPage.aspx<\/a><br \/>\n<LI>Inside the Storage Engine: <STRONG><EM>Anatomy of an extent<\/EM><\/STRONG>:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/03\/insidethestorageengineanatomyofanextent.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/03\/InsideTheStorageEngineAnatomyOfAnExtent.aspx<\/a><br \/>\n<LI>Inside the Storage Engine: <STRONG><EM>GAM, SGAM, PFS, and Other Allocation Maps<\/EM><\/STRONG>:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2008\/03\/14\/insidethestorageenginegamsgampfsandotherallocationmaps.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2008\/03\/14\/InsideTheStorageEngineGAMSGAMPFSAndOtherAllocationMaps.aspx<\/a><br \/>\n<LI>Inside the Storage Engine: <STRONG><EM>IAM pages, IAM chains, and allocation units<\/EM><\/STRONG>: <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/04\/insidethestorageengineiampagesiamchainsandallocationunits.aspx\"><BR>https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/10\/04\/InsideTheStorageEngineIAMPagesIAMChainsAndAllocationUnits.aspx<\/a><br \/>\n<LI><STRONG><EM>Corruption: Last resorts that people try first&#8230;<\/EM><\/STRONG><BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/15\/corruptionlastresortsthatpeopletryfirst.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/15\/CorruptionLastResortsThatPeopleTryFirst.aspx<\/a><br \/>\n<LI><STRONG><EM>How to tell if the IO subsystem is causing corruptions?<\/EM><\/STRONG><BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/12\/howtotelliftheiosubsystemiscausingcorruptions.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/2007\/09\/12\/HowToTellIfTheIOSubsystemIsCausingCorruptions.aspx<\/a><br \/>\n<LI>Blog Category &#8211; <STRONG><EM>CheckDB from Every Angle<\/EM><\/STRONG>:<BR><A href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/CategoryView,category,CHECKDB%2BFrom%2BEvery%2BAngle.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/CategoryView,category,CHECKDB%2BFrom%2BEvery%2BAngle.aspx<\/A><br \/>\n<LI>Blog Category &#8211; <STRONG><EM>Shrink (and why it&#8217;s EVIL!)<\/EM><\/STRONG>:<BR><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/categoryview,category,shrink.aspx\">https:\/\/www.sqlskills.com\/blogs\/paul\/CategoryView,category,Shrink.aspx<\/a><\/LI><\/UL><\/UL><br \/>\n<P>Also, I used a few &#8220;interactive&#8221; (or build) slides in my presentation &#8211; specifically on transaction log backups and the concepts of &#8220;clearing the log&#8221; which really only <U>clears the inactive portion of the log<\/U>. To help you visualize this, I&#8217;ve added these slides here: <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/tripprandal_clearingthelog-buildslides.zip\">TrippRandal_ClearingTheLog-BuildSlides.zip (647.2 KB)<\/a>.<\/P><br \/>\n<P>Finally, we&#8217;ve taken all of the scripts that we demo&#8217;ed and placed them on SQLskills on our Past Events page here: <a href=\"https:\/\/www.sqlskills.com\/pastconferences.asp\">https:\/\/www.sqlskills.com\/pastConferences.asp<\/a>.<\/P><br \/>\n<P>And, if you were there and you think we missed something, feel free to ping me (or Paul!) with an email and we&#8217;ll make sure to update this resources post (and\/or [at least] help you find it what you&#8217;re looking for!!).<\/P><br \/>\n<P>Next stop &#8211; <a href=\"http:\/\/northamerica.msteched.com\/\" class=\"broken_link\">Microsoft TechEd ITPro<\/a> in June (we&#8217;re back in Orlando again)!<BR>kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>OK, we were in Iceland and then Florida for our Accidental DBA workshops and both went really well. People agree that there are quite a few involuntary\/accidental DBAs out there and overall, we helped quite a few to see a lot of options for better performance, availability, recovery, and\/or just manageability. So, this is our [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,50,58,65],"tags":[],"class_list":["post-576","post","type-post","status-publish","format-standard","hentry","category-events","category-optimizing-procedural-code","category-resources","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=576"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/576\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}