Welcome to SQLServerBible.com
I'm planning my next round of seminars... What are you looking for in a SQL Server Development Seminar? Quick Seminar Survey

SQL Server Bible eNewsletter

Your free weekly dose of data architecture advice and SQL Server developer know-how.

Archives: May 13, 2009 - Bill of Materials Parts Explosion Query Apr 16, 2009 - Free SSWUG Community Event Oct 6, 2008 - Denormalization, Seminar Report, Peter DeBetta Sept 15, 2008 - Top 10 reasons to Upgrade to 2008, LogRhythm, Nordic ScreenCast Aug 4, 2008 - Vancouver User Group, Database Ports, Indexing ScreenCast, Jean-René & SQLTeach July 23, 2008 - ARCast Interview, Mousetrap Designs, Debugger ScreenCast, Erland Sommarskog July 14, 2008 - Easter Egg, Absent-Minded Modeler, Mike White, From Row Constructor July 1, 2008 - Data Arch Blunders, Denis the SQL Menace, SQL Teasers June 25, 2008 - Data Audit Trails, Dr. SQL, Find Duplicate Indexes

I've always wanted a cool Euro-style "SQL" sticker for my notebook, so I had some made up. They're top quality vinyl designed specifically for notebook computers running SQL Server. If you want one, it's your's for the asking - no strings. Request a free SQL Euro Sticker (I'll need your snail mail address) SQL Stickers Around the World!

AutoAudit
	Code-Gen complete insert, update, & delete audit trail triggers. Update modified date and rowversion Reconstruct deleted rows using the generated vTable_deleted views original AutoAudit blog post / thread (now on CodePlex)

SQL Server 2008 Bible I'm excited about SQL Server 2008. I believe it will be the best SQL Server release so far. These days I spend nearly every waking moment researching and writing SQL Server 2008 Bible. For this edition Mike White joins me as BI expert and co-author. SQL Server 2008 Bible will have 82 chapters in 1540 pages. You can pre-order now from Amazon. Watch: SQL Server 2008 Panel Discussion New from Colorado PASSCamp / CSTechCast with Kevin Cox (SQL Cat Team), Ben Hoelting (.Net developer), and myself db_compression procs (requires Katmai CPT6) blog post New estimate compression or compress every object and index with a single proc

SQL Server 2005 Bible Seasoned database developers think inside the box, because that's where the cool code is. This comprehensive reference takes you inside the latest, coolest, and most powerful box, Microsoft's SQL Server 2005. Each of the book's seven sections focuses on key elements in a logical sequence, so you can easily find what you need including all the basics, best practices, dozens of targeted examples, and sample code. If you develop, manage, or maintain SQL Server 2005 databases, this in-depth book is what you need to succeed! Sample Chapter: Ch 11 - Aggregating Data (.pdf) (206Kb) Sample Databases and Chapter Scripts (740Kb)

Nordic O/R dbms for SQL Server
	Nordic (New Object/Relational Database Design) is an O/R dbms design and facade for SQL Server that merges the query, integrity, and vendor strengths of the relational engine with the design power of the object orientation to create an alternative database development environment. Microsoft Architecture Journal article SQL-Down-Under podcast interview about Nordic
Using T-SQL code-generation, Nordic transforms SQL Server into an O/R dbms: Seemless Classes / Sub Classes and Attribute Inheritance Polymorphism (Select * from superclass and retrieve all subclass objects) Collections & Aggregations Inheritable Class Workflows with Object Workflow State Complex Associations including Workflow State Constraints & Triggers Indirect multi-level Association spidering Still Easy to Query using SQL Nordic 2.09

	Total Training for SQL Server Development Follow along as Paul presents 8 hours of SQL Server development instruction. Recorded live in the Total Training studios in Nyack, NY, this training is the fastest way to get up to speed quickly with T-SQL development.

FK Indexing (v 1.00) Code-Gen script that automatically creates a (composite) non-clustered index for every Foreign Key without a complete matching (composite) index

sys.queries (v 1.00) Explore SQL Server 2005's Catalog views and DMV's