June 2009 - Posts

• Best Thing I Learned at PASS Summit

  I have learned many things at every PASS Summit I have attended. First off, all of the people who are speakers are just human beings like you and me (including everyone's favorite Kalen Delaney). I learned that it is really expensive to put on a conference Read More... Posted Tuesday, June 30, 2009 9:29 PM by drsql | 0 Comments

• Read/Write Ratio versus Read/Write Ratio?

  So, Jason Massie ( http://twitter.com/statisticsio ) had a blog post ( http://statisticsio.com/Home/tabid/36/articleType/ArticleView/articleId/324/Is-8020-a-90rsquos-Estimate.aspx ) that Kendal Van Dyke ( http://twitter.com/sqldba ) alerted me to at SQL Read More... Posted Saturday, June 20, 2009 2:44 PM by drsql | 14 Comments

• SQL Quiz: Gilligan’s Island

  Tagged, I was by the Rambling SQLSarg, Jonathan Kehayias , to answer the following question: So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with it; we’ll Read More... Posted Wednesday, June 17, 2009 6:25 PM by drsql | 3 Comments

• What is a physical database?

  A bit of terminology that gets beaten to death is that of the “physical” database.  I would think most every DBA uses this term (I do), but…to mean what?  I think there are two common utilizations: The layer of tables, constraints, indexes, Read More... Posted Thursday, June 11, 2009 6:26 PM by drsql | 5 Comments Filed under: Database Design, Best Practices, Development, Writing, Requirements, Design, Terminology

• disallow results from triggers

  A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.   Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor Read More... Posted Saturday, June 06, 2009 10:38 PM by drsql | 1 Comments Filed under: T-SQL, SQL Techniques, Best Practices, Development, Tips