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