Home |  Writing |  Consulting |  Schedule |  Scripts |  Links |  About










Paul's Blog...
Top Posts
Why use Stored Procs?
10 lessons from 35K tps
SQL Server:Fresh Vision
SQL Myths
Data Architecture
CodeGen AutoAudit Trail

Interviews...
CS TechCast
TechEd ArCast
PASSCamp 2008 Panel
SQL DownUnder


Locations of visitors to this page

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