Special Event
Date: July 28-29, 2008 (2 days)
Room: Salon Belair
Note: register for the 2 days workshop and get a free book dedicated
to you by the author.
Database performance, scalability, and extensibility don't happen by accident.
The truth is that the way the database is designed is the single greatest factor
determining the performance of the database.
This flow from layer to layer becomes a methodology for designing, developing, and optimizing databases.
The core of Smart Database Design is based on the six primary goals of every database:
Usability, Data Integrity, Performance/Scalability, Extensibility, Security, and Availability.
Every option and pattern for every design and development decision for each layer (schema,
queries, indexing, concurrency, adv. scalability) is analyzed by how the option impacts,
improves, or risks these six goals.
Smart Database Design is more than a collection of best-practices;
it's the business and architectural case for the best-practices.
As we go through each section outlined, we will also spend time discussing best practices.
Who Should Attend
Data Architects who want to design balanced, extensible database
Data Modelers who want to design high-performance database physical schemas
Database Developers tasked with improving the performance of a legacy database
Database Professionals designing and developing a new database
.NET or web developers who design their own SQL Server databases
You Will Learn How To:
Design an elegant efficient database physical schema that's fast, easy to query, and flexible so it works today and can handle changes in the future.
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 and,Analyze design decisions from a sound architectural point of view
1) Data Architecture
Defining Data Architecture / Enterprise Data Architecture
Data Architecture Principle
Six Database Design Goals
2) Smart Database Design
RDBMS System
Smart Database Design Layers
Applying the Methodology
3) Physical Schema Performance
The Modeling Process
Designing Entities
Normalization and the Rules of One
Data Design Patterns
Generalization
Responsible Denormalization
Primary and Foreign Keys
Situational Modeling
Muck Tables
Managing Optional Data
4) Set-based Queries
Recommended Solutions
Logical Query Flow
Cursor Strategies and Refactoring Cursors
Hierarchical Patterns
T-SQL Best Practices
Query Plan Reuse
5) Zen and the Art of Indexing
Index Structures
Scans, Seeks, and SARGS
Query Paths
Base Indexes
Comprehensive Indexing Strategy
6) Managing Transactions, Locking & Blocking
Transactional Integrity & ACID
Isolation Levels and Locks
Transaction Log Flow
Locking and Blocking
Optimistic Locking
Triggers
7) Advanced Scalability
Disk Subsystem Planning
Partitioning
Indexed Views
Filtered Indexes
Data Compression
What materials will I receive at the workshop? What's the seminar's style? We're not designing a new database but trying to optimize our current
database. Will these optimization techniques still apply? I'm not a SQL Expert, will I be able to keep up with an advanced
course? We're planning on upgrading but still running SQL Server 2005. How much
of the course is specific to SQL Server 2008? Theory's great, but is the seminar is practical? What are the seminar hours? May I bring my notebook computer? Is the seminar competitively priced? Are questions answered after the class? Can we offer an in-house seminar within our organization? What is the dress code? Can I just "show up" for a seminar?
Date: July 28-29, 2008 (2 days)
Room: Salon Belair
Day 1 July 28
8:00 AM – 8:30 AM 8:30 AM – 10:30 AM 10:30 AM – 10:45 AM 10:45 AM – 12:00 PM 12:00 PM – 1:00 PM 1:00 PM – 03:30 PM 03:30 PM – 03:45 PM 03:45 PM – 05:00 PM
Day 2 July 29th
8:30 AM – 10:15 AM 10:15 AM – 10:30 AM 10:30 AM – 12:00 AM 1:00 PM – 03:30 PM 03:30 PM – 03:45 PM 03:45 PM – 05:00 PM 05:00 PM – 05:15 PM
The cost of this 2 Days workshow is 999.00$ plus taxes. Every attendees will get a free copy of the book SQL Server 2005 Bible. A value of 69$
Space is limited. Register early!
Date: July 28-29, 2008 (2 days)
Take advantage of the SQLTeach special hotel rate at 217$. Contact Jean-René Roy by email. We can get
you that rate. Jrroy@devteach.com
Maximize your training experience by bringing a laptop. There will be free internet wireless on site.
During the sessions you can download the sessions material and try it during the presentations.
Having a free internet access can let you be in touch with the office and you can also write
in you blog the cool tips and tricks you’ll learn onsite.
Paul Nielsen, SQL Server MVP, is a hands-on database architect and the author of the SQL Server Bible series from Wiley & Son. Paul leads SQL Server Bible Workshops and speaks at several conferences. Paul will be giving the welcome address at the Colorado PASS SQL Server Code Camp next week in Denver, and he serves on the PASS Board of Directors.
Copyright © 2003-2008, DevTeach Inc., All Rights Reserved SQL Server Conference
370 Greber Suite 215, Gatineau, Quebec, J8T 5R6
SQL Server Training Telephone: 1-866-913-0430 Fax: 1-819 205-1422 Email: Info4You@devteach.com
Smart Database Design is the premise that an elegant physical schema makes the data
intuitively obvious and enables writing great set-based queries that respond well to indexing.
This in turn creates short, tight transactions which improves concurrency and scalability
while reducing the aggregate workload of the database.
