May 2009 - Posts

• Glenn Berry's way cool diagnostic DMV queries

  Last Thursday evening at the Denver SQL Server User's Group, SQL Server MVP Glenn Berry demoed his script of diagnositc queries. Way Cool. http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!1446.entry Read More... Posted Sunday, May 24, 2009 4:00 PM by Paul Nielsen | 1 Comments Filed under: DMV diagnostics

• Slashdot: Interesting Thread about MySQL forks and db vs db debate

  http://developers.slashdot.org/article.pl?sid=09/05/21/2040220 Read More... Posted Friday, May 22, 2009 8:52 AM by Paul Nielsen | 0 Comments

• What do you want in a SQL Server Dev Seminar?

  With the SQL Server 2008 Bible winding down, I'm ready to begin planning another round of SQL Server seminars. Since this crowd is smart, opinionated, and vocal, who better to ask for advice? If you have a minute, I’d sure appreciate it if you took this Read More... Posted Tuesday, May 12, 2009 8:11 PM by Paul Nielsen | 6 Comments

• Why use Stored Procedures?

  There are as many opinions for and against using stored procedures as there are database-related roles. I believe the position that is most qualified to speak to stored procedures is the data architect’s role. Data architecture is the role that studies Read More... Posted Saturday, May 09, 2009 11:57 AM by Paul Nielsen | 56 Comments Filed under: Data Architecture, Stored Procedures, DAL