THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Paul Nielsen

Rocky Mountain Tech Tri-Fecta / Saturday Feb 21 / Denver

If you’re in the neighborhood, I’d like to invite you to the Rocky Mountain Tech Tri-Fecta. I’m giving the SQL keynote: Lessons learned while writing SQL Server 2008 Bible. I’ll talk about choosing a great tech editor and the importance of style guides and Word templates – no just kidding.  


Lessons learned while writing SQL Server 2008 Bible

March 3rd the SQL Server 2008 Bible will go to press. I’ve spent most of a year digesting SQL Server 2008 and writing the book. Here’s my take on the strategic positioning of SQL Server 2008, my top 10 favorite new features, and where SQL Server 2008 belongs in your IT plans.

My other two sessions…

Nordic - Object/Relational

Objects and databases don’t mix well. But, Nordic is a CodePlex open source T-SQL code-gen project that fully emulates object orientation within SQL Server, supporting class/attribute inheritance, workflow state w/inheritance, and associations with workflow state dependencies and inheritance. Associations with inheritance is very significant feature – it takes the 2D relational model and makes it 3D.  Adding workflow state to associations is like adding business logic to foreign keys without any code. Using a generic .Net UI to display the data, Nordic is makes it easy to model and build an object/relational database with a clean database abstraction layer. And it’s fast.

In this session Paul demos the Nordic UI, walks though the stored procedure calls, and discusses how to design an object database using SQL Server.

Pure T-SQL Code

Fresh, never frozen, not from concentrate, extra pulp pure T-SQL Code. This session starts with about 12,000 lines of T-SQL sample code scripts from the SQL Server 2008 Bible ranging from simple queries to audit trail, to data compression and change tracking. The attendees will select the scripts for the detailed walkthroughs.

Published Monday, February 9, 2009 6:39 PM by Paul Nielsen



jdelator said:

Anyway that you will release the ppt of the presentations? Looking forward towards reading the sql2k8 book.

February 9, 2009 8:34 PM

Andy Irving said:

Ah, but the relational model isn't 2d, (to quote Chris Date) "It's actually n-dimensional"

February 10, 2009 4:30 AM

Paul Nielsen said:

Hi Andy,

Chris Date is great, but show my a relational database diagram that doesn't look 2d....


February 10, 2009 9:44 AM

Steve Perry said:

Maybe you should take a step or two back and read up on database fundamentals again. You don't seem to have much of a grasp on the most basic concepts of n-ary relations and many of the other foundations of the mathematical underpinnings of the Relational Model. Perhaps you should go back to the Chris Date?  Maybe try "Database in Depth" -- it explains all of these concepts in a very straightforward manner.

February 10, 2009 10:26 AM

Paul Nielsen said:

Let me clarify,

I wasn't referring to the mathematical foundations, I was referring to the practical methods of doing database modeling. My book is one of the few SQL Server books that actually has a section on relational algebra. I'm with you on the theory.

In the session abstract I was referring to the dramatic practical differences between modeling an ER diagram with PKs and FKs vs. modeling an object database with associations connecting at various levels of the class/subclass structure requires a 3-d visualization of the class structures. If you haven't seen an object database diagram, it's STRIKINGLY DIFFERENT than a typical ER diagram.

There's a struggle going on in the software world between the database and the EF/LINQ crowd. Nordic provides object-orientation within a strong database abstraction - no Entity Framework, and no LINQ. Nordic is a good thing for the database community.

February 10, 2009 11:19 AM

Jason said:

Hi Paul,

Is there any way that you can change the name of your book?  As a believer in God, I find it very sacrilegious to use the word "Bible" for any book that is not The Holy Bible.  If you keep the name as it is I guess I will have to buy one of your competitors' books.

Peace be with you.

April 13, 2009 5:05 PM
New Comments to this post are disabled

About Paul Nielsen

Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.

This Blog



news item test
Privacy Statement