Welcome to SQLServerBible.com

free e-Newsletter

Weekly dose of data architecture advice and SQL Server developer know-how.

Smart Database Design Design and development principles for SQL Server 2000/2005 Database Professionals who want to develop high-performance SQL Server database.

Learn the secrets of how to: Design an elegant efficient database physical schema that's fast, easy to query, and flexible. Design performance into the schema - why 3rd Normal Form and denormalization alone aren't enough. Use the right set-based solution to solve query problems. Tighten transactions for scalability with thousands of users. Refactor complex cursors into high-performance set-based queries Develop a comprehensive indexing strategy for overall best performance Dramatically improve the performance of legacy databases

Seminars - world tour 2008 Vancouver July 28-29 London Sept 22-23 Copenhagen Sept 25-26 Edinburgh Sept 29-30 Ft. Lauderdale Oct 13-14 Chicago Oct 16-17 Los Angeles Oct 20-21 Charlotte TBD

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

In the SSWUG Studio in Tucson, AZ recording my sessions...

	Kill the Cursor - how and when to use a cursor, and how to refactor cursors into set-based queries. Intro to Query Execution Plans - a gentle introduction to reading your first query execution plan. Top Ten Database Development Blunders - how to evaluate a database. what were they thinking? What did they risk? What should they have done instead?

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 e-mail pauln@SQLServerBible.com, if you're instersted in testing Nordic.
Database Design ROI White Paper Smart database design is smart business. The Database Design ROI White Paper documents how investing in the database design pays off in reduced development and maintenance costs. More importantly, the database design is the key to developing software that's flexible, extensible, and enables the IT organization to quickly respond to changing business requirements - which improves the business' competitiveness and profitability. Database Design ROI White Paper (pdf) (107Kb)

	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

AutoAudit (v 1.08) New Generate complete insert, update, & delete audit trail triggers for any single-column PK table. Update modified date and rowversion Reconstruct deleted rows using the generated vTable_deleted views AutoAudit blog post / thread

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