SQLBits 2015

Reading the SQL Server Execution Plan

In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output.

In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output. This includes looking at the graphical as well as the XML version of the execution plan. We'll explore the variety of operators that the execution plan can present you with, and show you how to tell the SQL Server that you want to change the execution plan to get rid of the operators that you don't want to be using any more.

Denny Cherry's previous sessions

Where should I be encrypting my data

In this session, we'll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work.

Selecting the correct Azure Data Solution for your application

There are several different data platform solutions for use within your application. Selecting the right option can make the difference between a well-performing application and a poorly performing one; not to mention the cost aspect of choosing the wrong solution.

Things You Should Never Do In Microsoft SQL Server

In this fun session we'll review a bunch of problem implementations that have been seen in the real world. Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes.

Database Security in SQL Server 2016 and beyond

In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.

How to decide if your database is a good candidate for Virtu

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no h

Indexing Internals

In this session we'll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes.

Reading the SQL Server Execution Plan

In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output.

I've Got A SQL Database, Now What?

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you.

Using SQL Servers AlwaysOn Availability Groups

In this session we will look at the features which are provided with Microsoft SQL Server 2012 and 2014 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution.

Optimizing SQL Server Performance in a Virtual Environment

In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.

Using SQL Server 2012s Always On

In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution.

Using SQL Server 2012s Always On

In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "Always On" features including site to site configurations to allow of a large scale high availability solution.

Deciding if Virtualization is a good choice for your servers

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea.