Why use Stored Procs?
10 lessons from 35K tps
SQL Server:Fresh Vision
CodeGen AutoAudit Trail
PASSCamp 2008 Panel
Design and development principles for SQL Server Database Professionals: |
database architects, data modelers, database developers, web developers, and .NET developers
who want to develop high-performance SQL Server database.
Tucson, AZ Oct 26-28, 2008 $999 |
Why Smart Database Design?
Most database architects and developers spend years learning how to design and develop database projects
that perform well.
Paul has built a career of turning around failing database projects. He knows what works, what doesn't, and why. With Smart Database Design, you'll learn the key decision points for any database project, how to evaluate the options, and how to both reduce risk and develop the database faster with better results.
And, what's even more important than designing a successful project is knowing why.
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.
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
scalability while reducing the aggregate workload 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.
As you can see, Smart Database Design is more than a collection of best-practices; it's the business and architectural case for the best-practices.
You Will Learn:
Who Should Attend:
1) Data Architecture|
2) Smart Database Design|
3) Physical Schema Performance|
4) Set-based Queries|
5) Zen and the Art of Indexing|
6) Managing Transactions, Locking & Blocking |
7) Advanced Scalability |
Attendees a spiral binder with all the slides printed for note taking.
Paul's style is very interactive with lively discussions and stories. Several times during the seminar, you'll break into small groups to discuss an issue or role-play a development situation.
Absolutely. Design principles are easiest to implement on a clean slate, but they become even more critical when optimizing a production database.
Yes. A basic familiarity of SQL Server, data modeling, and T-SQL programming is assumed, but you don't need to be a SQL expert to benefit from this course.
The design principles, and almost all of the implementation details apply to both SQL Server 2005 and SQL Server 2008. Where new features of SQL Server apply, they are explained. The proofs and examples use SQL Server 2008.
Theory without practical implementation is useless. The seminar is designed around a decision template that focuses on the design and development decisions you must face with every project.
9 am until 4:30 pm with a 1 hour break for lunch.
Yes, please do. You're encouraged to try the scripts and proofs for yourself.
Yes. The average cost per day for advanced SQL Server training nationally is about $580.
Yes. Paul answers all email from students.
Yes. Paul can present in-house training customized to your specific needs. This format has the advantage of being able to address specific issues privately.
Dress is business casual. Wear comfortable clothing and bring a sweater or jacket in case the room is cool.
I don't recommend it, there may not be any available seats. It's best to register, even if it's a last minute registration.
Paul, thanks for coming out to IBS. Iíve already needed to use some of the ideas you showed us. Iím even looking forward to wading through our indexes and cleaning things out.
- Ryan Opfer
This class was great. Paul was willing to take the time needed when I had a question, and always had a good answer. I came away with an ability to explain things Iíve always heard before but could never quite articulate. I really appreciated the practical approach that made the concepts we covered applicable to my job right now. It was especially helpful to get an expert's advice on using the new features of SQL Server 2005.
- Josh Smith
I greatly appreciated the down to earth approach and the way that you presented the different topics. It was helpful to talk about indexes in depth and seeing and understanding the new features of SQL 2005 was helpful too. You not only explained the details, but you explained the design reasons why certain techniques work and when to apply them. Excellent class - so much better than a standard class, thanks!
- Marlin Brubaker
Session is very well formed, educative, and interesting.
Paul really knows his stuff.
Lots of very good advice and lots of info. Very good session. Well-worth the price.
Fun and in depth, the real world stories were interesting and good to listen to.
Very detailed and the material is what i was looking for.
Very good speaker and great session, could easily extend over several days and keep interest.
Very Enjoyable. Learned a lot.
I like SQL Server Smart Database Design.
He is a pleasure to listen to, great speaker and it makes the session very dynamic. The content was very good too.
- Pre-con Comments