Christian Bolton

Christian Bolton is a Microsoft Certified Architect, Microsoft Certified Master and former MVP for SQL Server. He is a certified architect in both Azure and AWS.

Christian Bolton's Sessions

Coeo Managed Support-More interesting support cases!SQLBits 2015

Come and hear about some of our most interesting SQL Server support cases from the last 12 months

Extending your datacentre to the cloud with SQL Server 2014SQLBits 2014

Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud. In this session we'll look at these features with end-to-end demos, discussions and scenarios so you can understand what the future could look like in your own SQL Server environment.

Advanced SQL Server 2012 HA and DR ArchitecturesSQLBits 2013

In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads.

The top 10 biggest SQL Server configuration mistakesSQLBits 2012

Based on healthcheck reviews of hundreds of SQL Servers across dozens of customers, I'll talk you through the 10 most commonly made mistakes by action or inaction and what you can do to make sure your SQL Servers get a clean bill of health.

Investigating parallelism and the CXPACKET wait typeSQLBits 2011

In this session you'll learn how SQL Server chooses parallel operations, how to investigate what's going on when you see the CXPACKET wait type, and whether your parallel query is running as efficiently as it could be.

Consolidating data collection with SQLDIAG and analysing it all with SQLNexus SQLBits 2010

SQLDIAG is a great tool that was introduced in SQL Server 2005 to help co-ordinate the collection of perfmon logs and SQLTraces as well as gathering other system data. In this session you’ll learn how to configure, customize and run SQLDIAG as well as the perfstats script from Microsoft which adds locking, blocking and wait stats to the list of collectors that SQLDIAG co-ordinates. This tool is one of the secrets of the trade for efficient data collection and this session is a must for anyone not using it extensively already. Using the output from sqldiag we'll then look at SQLNexus to analyze the results. I'll show you how to configure, run and draw conclusions from the reports created by this tool which is by far the most useful piece of software in the troubleshooting kit bag of people that have taken the time to learn it. This session is based on 2 chapters from Professional SQL Server 2008 Internals and Troubleshooting.