March 2009 - Posts

• Multiple Assignment Variables and Order By in SQL Server 2008

  A multiple assignment variable , sometimes called an a ggregate concatenation, is a fascinating method that appends a variable to itself using a select statement. Though nearly undocumented, the method's been around since at least SQL Server 2000. It’s Read More... Posted Tuesday, March 17, 2009 11:27 AM by Paul Nielsen | 28 Comments

• Ping Back: Checklists, Recipes and Algorithms

  a most excellent blog post by Mike Walsh: http://www.straightpathsql.com/blog/2009/3/16/checklists-recipes-and-algorithms.html Read More... Posted Monday, March 16, 2009 2:56 PM by Paul Nielsen | 1 Comments

• The <NDA> cloud is lifted, (for SDS anyway)

  I received confirmation moments ago from an SDS product manager that this blog post is indeed public knowledge, http://blogs.msdn.com/ssds/archive/2009/03/10/9469228.aspx The hurdle for cloud db isn't security, bandwidth, or location, it's ease of transition. Read More... Posted Tuesday, March 10, 2009 6:31 PM by Paul Nielsen | 0 Comments Filed under: SDS Cloud

• Nordic: Case Study

  As soon as my book is complete, I'm going to focus full-time on www.codeplex.com/nordic and an ISV app based on Nordic. In the meantime here's an email I recently received from an ISV that's testing Nordic as the database design for thier next version: Read More... Posted Tuesday, March 10, 2009 1:13 PM by Paul Nielsen | 2 Comments Filed under: Nordic O/R dbms

• woot! Brad's a PC!

  Our good friend Brad McGehee of the Big Island is on the big screen in the "I'm a PC" campaign! http://www.facebook.com/video/video.php?v=59493295985 Aloha Brad! Read More... Posted Friday, March 06, 2009 11:25 AM by Paul Nielsen | 1 Comments