December 2006 - Posts

• Andrew's UDF Book

  One of the best things about the PASS Summit is meeting interesting folks who have a cool story to tell. Andrew Novick is passionate about SQL Server, specifically SQL Server user-defined functions. He found himself using UDF’s more and more in his consulting Read More... Posted Saturday, December 23, 2006 7:54 AM by Paul Nielsen | 0 Comments

• Why the Relational Model (as implemented) Is sufficient (part 2)

  There’s a growing trend to develop the data structures within the class diagram without any input from a data modeler, and then create a single table per class for object persistence or use an object/relational mapping layer to convert the classes and Read More... Posted Thursday, December 21, 2006 4:24 PM by Paul Nielsen | 3 Comments

• Why the Relational Model is Insufficient (part 1)

  I’ve been designing relational databases since the mid 80’s. My conclusion is that the relational model is weak and lacking. Specifically, the foreign key – that simple DRI constraint which is the keystone of the relational model - is insufficient. The Read More... Posted Monday, December 18, 2006 6:42 AM by Paul Nielsen | 17 Comments

• Short Range Scan Mr. Spock

  The reason I got into computing was to play DEC-Trek. I was a music major and the only way to get into the computer lab and get time on the PDP-11 was to be in a programming class. This was before the Apple][. So I signed up for a DEC BASIC course, got Read More... Posted Monday, December 04, 2006 7:37 PM by Paul Nielsen | 0 Comments Attachment(s): SQLtrek.jpg