April 2009 - Posts

• SQL in a Nutshell as an iPhone App

  My editor at O'Reilly & Associates sent me an email the other day. It read "I'm pleased to tell you that SQL in a Nutshell will be one of 19 titles submitted to Apple by early next week. It may take up to 3 weeks after that for them to appear." From Read More... Posted Thursday, April 30, 2009 2:05 PM by KKline | 2 Comments Filed under: Opinion

• Is it Time for a Professional Code of Ethics for DBAs?

  The root of this blog post is witnessing one too many DBAs, either through direct action or indirectly by failing to act, damage or destroy the very databases they are charged with protecting. In a sense, DBAs are the guardians of an extremely valuable Read More... Posted Tuesday, April 21, 2009 4:13 PM by KKline | 15 Comments Filed under: Opinion

• Looking for Good DMV/Database Admin Queries!

  I like to collect useful database administration queries that leverage the SQL Server 2005 and 2008 DMVs. Heck, I'm still interested in SQL Server 2000 queries too. I thought I'd make my search public so that a) you can share your favorite queries here Read More... Posted Tuesday, April 07, 2009 5:19 PM by KKline | 14 Comments Filed under: SQL Programming, Best Practices