I’m one of the 3 lucky guys whose submitted precon workshop for the developer category for PASS SQLRally is in the final selection for community voting! 🙂
Here’s the abstract that I have submitted which gives you a good overview what I’m talking about, and what you’ll learn in my precon. If you think this sounds good for you, and you want to hear me at SQLrally, please vote for my precon workshop. Voting should be available within the next days at SQLRally.com.
What every .NET developer MUST know about SQL Server
Are you building database applications with the .NET framework for SQL Server? You know how you can perform INSERT, UPDATE, DELETE, and SELECT statements, but all the other areas of SQL Server are a black box for you? And sometimes you don’t know why your database application is getting slower and slower and consume more and more memory on SQL Server? If you are answering one of these questions with yes, then you are the right person for this intensive 1-day long SQL Server internals workshop presented by Klaus Aschenbrenner. In this workshop you will learn the inner workings of SQL Server, and how you can use this know-how when building your next database driven .NET application for SQL Server.
Klaus will give at the beginning an general overview about SQL Server, its architecture, and how SQL Server uses Execution Plans to execute a query. You will also learn about Plan Cache Polution, why it is bad, and how you can avoid it, when working with the .NET framework. After laying out these foundations, Klaus moves into the storage details of databases and tables, and shows you how SQL Server physically stores tables in the database file and how you can fine tune the physical storage with correct chosen data types and an intelligent table design. After you know the basics of Execution Plans and storage details, Klaus teaches you the architecture and the inner workings of indexes in SQL Server. You will see the differences between Clustered- and Non-Clustered Indexes and how they relate to each other. With this knowledge in your hand, you will then finally see how you can use different index tuning methods to speed up the execution time of your database queries.
Agenda
- Overview about query execution in SQL Server 2008
- Database Internals
- Database Structure
- Page-Design
- Fixed data types
- VAR data types
- LOB data types
- Sparse Columns
- FILESTREAM Storage
- Data Modification Internals
- Transaction Log
- Architecture
- Backup/Recovery
- Recovery Strategies
- Execution Plans
- Reading & Understanding
- Operators
- Physical JOIN operators
- Capturing Execution Plans
- Procedure Cache/Procedure Cache Polution
- SQL Server Index Architecture
- Heap Tables
- Clustered Index
- Non-Clustered Index
- Index Depth
- Clustered Key/Clustered Key Dependencies
- Unique/Non-Unique Clustered Key (UNIQUIFIER)
- Clustered Index Structure
- Unique Clustered Index
- Non-Unique Clustered Index
- Non-Clustered Index Structure
- Unique Non-Clustered Index
- Non-Unique Non-Clustered Index
- Non-Clustered Index on Heap Tables
- Non-Clustered Index on Clustered Tables
- Index Tuning
- Covering Index
- Avoiding Bookmark Lookups
- Index Intersection
- Index Join
- Index Access Methods
- Filtered Index
- Indexed Views
- Statistics
- Usage in SQL Server 2008
- Auto Stats
- Statistics Maintenance
- Analyzing Statistics
- Multi-Column Index Statistics
- Fill Factor
- Index Reorganize
- Index Rebuild
- Online Index Rebuild
- Statistics & Table Variables
-Klaus
