I’m starting my own SQL Server Consulting business!

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting my own SQL Server Consulting business. I’ve been working with SQL Server for almost 10 years now, so now its time for me to give my learning’s back to you through consulting. From 2000 to 2005 I’ve used SQL Server completely as a black-box from .NET application, not knowing how SQL Server works internally. I’ve used directly SELECT, INSERT, UPDATE, and DELETE statements, and sometimes also O/R mapping tools, and thought that I’m doing “good” things with SQL Server. But since 2005 I’ve learned more and more about SQL Server, it’s architecture, it’s internal working, and how SQL Server can be used in really large scale-out scenarios.

And if I’m applying this know-how to my database applications that I have written from 2000 to 2005, it’s awesome to see how wrong I have used SQL Server in the past. Therefore my main area of consulting is how to apply SQL Server’s architecture and internals to .NET developers and how to write great, performing, and scale able SQL Server applications based on the .NET framework, and how you can troubleshoot those database applications in the production (e.g. as a DBA) if you have scary problems. I’ve seen in the past, that we are using SQL Server wrong, when we are creating new databases for our applications, or even when we are installing SQL Server with the default settings without knowing how SQL Server will be used in our environment.

Starting with tomorrow I’m providing SQL Server Consulting services in the following areas of SQL Server:

  • SQL Server Internals
  • SQL Server Performance/Index Tuning
  • SQL Server Troubleshooting
  • SQL Server Monitoring
  • SQL Server Service Broker
  • SQL Server Business Intelligence Stack
  • SQL Server StreamInsight
  • Performing SQL Server Health Checks
  • SQLCLR

If you want to know more about my SQL Server services offerings, don’t hesitate to contact me directly.

-Klaus

Vote for my precon workshop for PASS SQLRally

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

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