Catching up on resources – the Accidental DBA workshops!

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 “resources post”. 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 – it’s really never the same twice!).

• Checkout the whitepapers on SQLskills:
  https://www.sqlskills.com/whitepapers.asp
  
• Blog Post Tripp: 8 Steps to better Transaction Log throughput:
  https://www.sqlskills.com/blogs/kimberly/2005/06/25/8StepsToBetterTransactionLogThroughput.aspx
  
• RD Grok Talks (general):
  http://www.groktalk.net/
  
• Stored Procedure Grok Talk (Tripp):
  http://www.groktalk.net/Videos/kimberly_l_tripp.wmv
  
• Stored Procedure Blog posts (Tripp):
  https://www.sqlskills.com/blogs/kimberly/CategoryView,category,Optimizing%2BProcedural%2BCode.aspx
  
• MSDN Webcast Series (series wrap-up blog post with links):
  https://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=4daca6d9-c52b-4f85-a47c-20f252883e20
  
• Microsoft Events Calendar:
  http://www.microsoft.com/events/webcasts/calendar/monthview.aspx?audience=it%20professional&series=0&product=0&presenter=0&tz=0&wt.svl=interactivecalendar
  
• KB Article 329526: File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005:
  http://support.microsoft.com/kb/329526
  
• KB Article 328551: Concurrency enhancements for the tempdb database:
  http://support.microsoft.com/kb/328551
  
• Whitepaper: Working with tempdb:
  http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
  
• KB Article 243586: Troubleshooting stored procedure recompilation:
  http://support.microsoft.com/kb/243586
  
• Whitepaper: Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005:
  http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
  
• For all of the different topics Paul discussed he placed links to corresponding blog posts, I’ve duplicated them here so you can get a refresher for these links:




• TechEd 2007 video: Secrets of Fast Detection and Recovery from Database Corruptions
  
• Inside the Storage Engine: Anatomy of a record:
  https://www.sqlskills.com/blogs/paul/2007/09/30/InsideTheStorageEngineAnatomyOfARecord.aspx
  
• Inside the Storage Engine: Anatomy of a page:
  https://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAPage.aspx
  
• Inside the Storage Engine: Anatomy of an extent:
  https://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAnExtent.aspx
  
• Inside the Storage Engine: GAM, SGAM, PFS, and Other Allocation Maps:
  https://www.sqlskills.com/blogs/paul/2008/03/14/InsideTheStorageEngineGAMSGAMPFSAndOtherAllocationMaps.aspx
  
• Inside the Storage Engine: IAM pages, IAM chains, and allocation units:
  https://www.sqlskills.com/blogs/paul/2007/10/04/InsideTheStorageEngineIAMPagesIAMChainsAndAllocationUnits.aspx
  
• Corruption: Last resorts that people try first…
  https://www.sqlskills.com/blogs/paul/2007/09/15/CorruptionLastResortsThatPeopleTryFirst.aspx
  
• How to tell if the IO subsystem is causing corruptions?
  https://www.sqlskills.com/blogs/paul/2007/09/12/HowToTellIfTheIOSubsystemIsCausingCorruptions.aspx
  
• Blog Category – CheckDB from Every Angle:
  https://www.sqlskills.com/blogs/paul/CategoryView,category,CHECKDB%2BFrom%2BEvery%2BAngle.aspx
  
• Blog Category – Shrink (and why it’s EVIL!):
  https://www.sqlskills.com/blogs/paul/CategoryView,category,Shrink.aspx

Also, I used a few “interactive” (or build) slides in my presentation – specifically on transaction log backups and the concepts of “clearing the log” which really only clears the inactive portion of the log. To help you visualize this, I’ve added these slides here: TrippRandal_ClearingTheLog-BuildSlides.zip (647.2 KB).

Finally, we’ve taken all of the scripts that we demo’ed and placed them on SQLskills on our Past Events page here: https://www.sqlskills.com/pastConferences.asp.

And, if you were there and you think we missed something, feel free to ping me (or Paul!) with an email and we’ll make sure to update this resources post (and/or [at least] help you find it what you’re looking for!!).

Next stop – Microsoft TechEd ITPro in June (we’re back in Orlando again)!
kt