Presentations – 2015
During 2015 I delivered the following public sessions on SQL Server topics. Where possible I have provided a link to a recording or session material.
This list does not contain product related recordings that I have made for my former employer Dell Software Group (formerly Quest Software). These recordings can be found at http://www.quest.com/events/list.aspx. Recordings made for SQL Sentry can be found at SQLSentry.tv
Wait Watchers – Gain Performance Increases Fast!
In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you, as a SQL Server professional, can make better informed decisions on which areas of your environment to tune to greater effect .After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate. Not just to fix that problem query, but improve overall performance for all of your users.
- Cork (Ireland) SQL Server User Group – 21st Jan
- SQL South West – 6th Nov
- London PASS Chapter – 19th November
The Big Backup Theory
In this session, you’ll gain invaluable guidance for optimizing your backup strategies. Actually that is a lie, I will be advocating the mind shift from backup strategies and the devastating affect they can have on a company and instead move you to thinking about implementing restore strategies. Things become much simpler when you consider the purpose of a backup, and the effects of the different recovery models and backup options have on your customers and effectively your livelihood. Using trace flags the session will also cover how SQL Server manages its own backup options and how you can tune them to make sure that you meet the time constraints of your enforced maintenance windows.
- SQLBits XIV – 7th March
Performance Troubleshooting for the (Accidental) DBA – Pre Con
We spend a lot of time every day working on SQL Server tracking down performance related issues, in this day long session we will run through different approaches to troubleshooting these issues.
We will be looking into how to diagnose high disk I/O , high CPU, memory issues, missing indexes, locking, blocking and deadlocking – everything every SQL Server DBA needs to know about.
We will examine how to gather the essential information to identify performance issues and how to mitigate them.
This training day is perfect for every experienced and accidental DBA.
In this day long session we will cover the following topics.
– SQL Server architecture.
– Hardware considerations.
– Database design considerations
– Important Perfmon counters
– Wait statistics.
– Useful DMV’s
– Workload analysis with Profiler / XEvents
– Plan cache
– Execution plans
– Indexes and Maintenance
– SQL Profiler
– SQL Nexus
– Generating and testing load
- SQL Saturday #372 Exeter – 24th April
SQL Server 2014 Features EVERYONE Can Use
You love technology and have a passion to get things done, so when a new release of SQL Server comes out you’re ecstatic! Unfortunately your employer’s budget can’t stretch to the premium Enterprise edition and all the new sessions are showing Enterprise only features. Don’t worry, in this session Richard Douglas will show you all the new features available in the Standard and Business Intelligence Editions that EVERYONE can benefit from. After this session you will be able to outline why you need to upgrade to the latest edition of SQL Server as well as the benefits and how they can improve your business.
- SQL Saturday #372 Exeter – 25th April
The Day After Tomorrow; Why You Need To Baseline
Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best possible performance, you need to make sure you’re monitoring the right things. But how do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.
This session shows you how to get the most from them. We explain what a baseline is, why and when you need to take one, and how you can create one. You also learn about native Windows and SQL Server tools that enable you to do just that. Don’t wait for a disaster to fully realize the importance of baselining.
- SQL Relay – Nottingham – 7th October
- PASS Summit – Seattle – 29th October
- Edinburgh SQL User Group – 12th November
Natural Born Killers, Performance Issues to Avoid
Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.
You will leave this session with a list of things that you can check for in your environment to improve performance for your users.
- SQL Relay – Reading 8th October
Understanding the Transaction Log, Your Key to Unlocking Greater Throughput
Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log?
There’s no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It’s as if it doesn’t matter, an afterthought, a relic of the platform architecture.
In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
- SQL Relay – London 12th October
- SQL Saturday Southampton – 5th Dec
Indexing presents daunting challenges for even the most seasoned professionals, as it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment and improve the overall performance of your SQL Server applications. In this session you will learn all about the different architectures of indexes, from that how to make the right choices when designing your indexes so that both the database engine and your DBA will love you for it.The session will also cover how to find missing and unused indexes, the cause and how to resolve fragmentation issues as well as how to maintain your indexes after they have been deployed.
After attending this session you will have a much better understanding of how to create the right indexes for your entire environment, not just for that one troublesome query.
- SQL Relay – Cardiff – 14th October
- SQL Relay – Birmingham – 15th October
Being a DBA – A Day in the Life – Pre Con
Being a DBA, you are responsible for helping to protect the most important asset that a business has, it’s data. In this pre-conference session we will look at some of the mainstream tasks that you as a DBA will encounter and need to successfully deal with in order to maintain a fully functional and efficient SQL Server Environment.
– Setup and Configuration
– Maintenance, Backup, and Recovery
– Monitoring, Baselines, and Performance
– Security and Administration
This session is primarily aimed at junior to intermediate level DBA’s, however even an experienced DBA will learn new techniques for dealing with some of today’s most demanding data challenges.
- SQL Saturday Southampton – 4th Dec