Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at http://twitter.com/Aschenbrenner.

Vote for my precon workshop for PASS SQLRally

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

Comments

Posted by rhandloff on 26 October 2010

I voted for your rally because I think a lot of .NET developers need to understand SQL Server better. I would encourage you to spend a lot of time on good table design and good query writing skills. I'm troubled by how many .NET developers either cannot or will not write good SQL. Perhaps they do not realize the power of SQL and how it can make their lives easier and their applications faster.

Leave a Comment

Please register or log in to leave a comment.