November 2007 - Posts

• September BOL publicly posted

  Download an updated version of Books Online for Microsoft SQL Server 2005, the primary documentation for SQL Server 2005. http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx Read More... Posted Friday, November 30, 2007 12:56 PM by Paul Nielsen | 2 Comments

• Data Architecture

  from SQL Server 2008 Bible Appendix A. Data Architecture is the overarching design of the database(s) and how they interact with other software. Data architecture is defined by the Information Architecture Principle and the six attributes by which every Read More... Posted Sunday, November 25, 2007 11:16 AM by Paul Nielsen | 5 Comments Filed under: Data Architecture, Extensibility

• OT: Camtasia: Vista UI Tips

  Please check out my new screencast, Vista UI Tips (9:29). First free day after a long five month contract and what do I do? I play with Camtasia and my new Samson C01U USB microphone. Although I made this for a friend who just bought a new computer with Read More... Posted Wednesday, November 21, 2007 10:29 PM by Paul Nielsen | 2 Comments Filed under: Vista, Screencast

• OT: Amazon Kindle

  Last night on PBS Jeff Bezos was talking about his new Kindle device on the Charley Rose show. When asked if he felt more emotion about Kindle than Amazon.com, Jeff replied with an enthusiastic yes. To paraphrase, “Books are technology and every technology Read More... Posted Tuesday, November 20, 2007 8:31 AM by Paul Nielsen | 3 Comments Filed under: books

• Columnar Databases

  Josh Jones, all around good guy and author of an upcoming book on database design, presented a rousing talk on Columnar Databases at last night’s Colorado Springs’ SQL Server User Group. There are several commercial and open source columnar databases Read More... Posted Thursday, November 15, 2007 9:35 AM by Paul Nielsen | 20 Comments

• Will the Real Null Please Stand Up? Part 1

  Thinking more about null, I seems to me that the primary problem with nulls is that the theoretical definition of null is very different than the pragmatic use of null. We all learned in DB101 that Null means "unknown" and this is why Null = Null is false. Read More... Posted Sunday, November 11, 2007 6:09 PM by Paul Nielsen | 6 Comments Filed under: null

• Multiple Inheritance for Nordic?

  <Background> I’ve been playing with Nordic (New Object/Relational Design) for a few years, but this year I began to work on a product app using Nordic which was the impetus for beefing up the API. The Nordic 2.0 API and a .net front-end app will Read More... Posted Saturday, November 03, 2007 11:52 AM by Paul Nielsen | 4 Comments Filed under: Nordic O/R dbms