SQL Server Presentations and Conference Talks

David has a catalogue of SQL Server based talks that he has delivered at SQL Bits, SQL Saturdays and other conferences around Europe.

If you would like him to deliver any of these talks to you organisation please contact us

The titles and abstracts of these presentations are:

A real DBA don’t need a GUI - A Guided Tour of SQL Server Management Studio

SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted  but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive. 
This presentation will show you how to use SSMS and will look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there.
At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.

A Beginner’s Guide to Cloud Computing and SQL Azure

Putting Your head in the Cloud– A Beginner’s Guide to Cloud Computing and SQL Azure Although Microsoft Azure and the concept of Cloud Computing has been around for a number of years it is still a mystery to many. 

This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages. 

We’ll then look at Windows Azure  and specifically SQL Azure DB, to see how to create and manage SQL databases in the Cloud. By the end of this talk you will be ready to put your head in the cloud and start taking advantage of what the cloud has to offer.

Putting Your head in the Cloud – Working with SQL Azure

Your company’s data is probably the most important thing that they have, if that data is lost your company may not be able to continue trading and you will be out of a job.
One of the fundamental responsibilities of a DBA is to ensure that the databases you manage are safe and secure, not just protection from malicious attack but also safeguarding data from accidental unwanted changes by users.
In this talk we will look at the recommended SQL Server Security best practices such as compliance, security, design, auditing, backups and encryption that DBAs and developers can implement to keep your databases and instances secure.

Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA

Today, SQL Server DBAs are more than likely at some point in their careers to come across Oracle and Oracle DBAs.
To the unwary this can be very daunting and, at first glance, Oracle can look completely different with little obvious similarities to SQL Server.

This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.

At the end of this session you will have a better understanding of Oracle and the differences between the Oracle RDBMS and SQL Server. 

Although you won’t be ready to be an Oracle DBA it will give you a foundation to build on.

Taming the Beast – How a DBA can keep Kerberos under control


The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators. 

What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works. 

  • We will look at
  • What is the purpose of Kerberos in relation to SQL Server?
  • When do we need to use it?  Do we need to worry about it at all?
  • How  do we configure it?  What tools can we use?
  • Who can configure it?  Is it the DBA job to manage and configure Kerberos?
  • Why does it cause so many issues?

Because on the face of it setting up Kerberos for a SQL Server is actually straightforward but it is very easy to get wrong and then sometimes very difficult to see what is wrong

No comments:

Post a Comment

Featured post

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...