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.