SQL Server

Key Value Pairs in Database design
There was an interesting thread on the SQLDownUnder mailing list last week about the use of Key Value Pairs in database design. One of the Guru's on the list Jeremy Huppatz made a few posts which covered off pretty much all the issues I was thinking about. One of the key points that Jeremy made was this one: Remember that relational databases are designed with 3 key goals - reliable data entry, stable consistent storage and rapid retrieval. By using KVP's you throw the rapid retrieval capability ......

Posted On Sunday, March 12, 2006 7:02 PM | Comments (8)

Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005
This page is a work in progress, I am using it as a repository to store resources as I come across them. Preparation Guide for Exam 70-441 (lists all the skills being tested)http://www.microsoft... Skills AssessmentIntroducing Microsoft SQL Server 2005 for Database Developers BooksIntroducing Microsoft SQL Server 2005 for Classroom TrainingCourse 2734: Updating Your Database Development Skills to SQL Server 2005 Free* Microsoft E-LearningThe following e-learning ......

Posted On Tuesday, November 15, 2005 6:39 PM | Comments (8)