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 ......

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 ......

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online
Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: