30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

SQL Server Architecture: The life of a query

In this session I will be bringing together all the components of SQL Server to illustrate what happens when you issue a query from a client. From the TDS packet, through ODS, the optimizer and the buffer manager to returning the result. I'll walk you through when the transaction log is used, what happens when a checkpoint occurs and what the lazy writer does.I've illustrated the process in a way that's easy to consume and helpful to put SQL Server's architecture into context.

Speaker focus

Christian Bolton

_MG_0036.jpg

Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting to organisations in the UK and Europe. Prior to this, Christian worked for 5 years as a Senior Premier Field Engineer for Microsoft UK working with some of Microsoft’s biggest customers. He is a Microsoft Certified Architect, Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2008 Internals and Troubleshooting. He works out of London and lives in the south of England with his wife and children and can be contacted through http://coeo.com.


Christian Bolton's blog http://sqlblogcasts.com/blogs/christian



Downloads

No items to download

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL