Evening Session

We are going to have a Fun evening planned for you who have atteneded the conference or are just coming in for the evening session, with a Experts Panel with a lot of the presenters from the day’s conference taking part to answer those burning questions (wonder if we can stump them) that you bring Some fun with our […]

Read more

The Backup Tune-up | 300

Have you ever gotten tired of your database taking hours to back up? Are you sick of your users breathing down your neck because the database restore is taking too long? Now you won’t have to worry about that anymore. In this session I show you some little known tricks, methods, and trace flags you […]

Read more

Inside SQL Server Indexes | 400

Ever wondered what indexes look like at the page level? Or how an index’s design affects the query optimiser’s choices of plan? Wonder no more. In this session we’ll dig into index internal structures and look at how different index design choices affect the index architecture. After that we’ll look at some uses of indexes […]

Read more

Why are we Waiting ? | 400

While the waits and queues performance tuning methodology is well known, there can be some confusion still about what various waits mean and what, if anything, needs to be done about them. In this session we’ll take a dive into the SQL Server execution model and see why waits occur, and then look at some […]

Read more

Loading SQL Server Data with Powershell | 400

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types […]

Read more

Responding to Extended Events in Near Real Time | 300

Extended Events provide deep insight into SQL Server’s behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking. In this session we will see how […]

Read more