Your SQL Residency

Our events include webcasts that you can attend as well as conferences and seminars that take place in the real world. We’ll try to post videos and lessons from physical events on our blog!

If you missed one of our previous events, check out our video archive.

Jes Schultz Borland

April 29

Spotting Trouble – and Help! – in Execution Plans

Triage Tuesday 30 minute Webcast starting at 11:30 AM Central
The execution plan is a step-by-step map of how SQL Server has returned the data from your query to you. Sometimes, there are detours and potholes in the road that make the journey more difficult. Sometimes, there’s an alternate, faster route. Attend this webcast to find out how to read the warning signs and identify the helpful information. Register now.


Jes Schultz Borland

May 6

Treasure Hunt: SQL Server Error Log Edition

Triage Tuesday 30 minute Webcast starting at 11:30 AM Central
What secrets lie within SQL Server’s error log? Many! This day-by-day record of your server’s actions can be a treasure trove of information. Jes Schultz Borland will teach you what to look for, how to effectively search it, and how to get alerted of potential problems. Register now.


Brent Ozar

May 11

Global Hebrew Virtual Chapter:
Troubleshooting Shared Storage for DBAs

Your SQL Server’s data lives on the SAN, and you’re not happy about that. All the Perfmon metrics you gather seem to point to a storage problem, but the SAN admin says the storage is sitting around bored, so it must be a SQL Server problem. Brent Ozar feels your pain – years ago, he was a DBA in the same position, so when his SAN admin quit, Brent took the job. In just 60 minutes, he’ll teach you what’s inside the SAN, why multipathing is so important, how to test storage throughput, and why TempDB should be on local SSDs. Register now.


Kendra Little

May 13

Temp Table and Table Variable Showdown

Triage Tuesday 30 minute Webcast starting at 11:30 AM Central
Should you use temp tables or table variables in your code? Join Microsoft Certified Master Kendra Little to learn the pros and cons of each structure, and take a sneak peek at new Memory Optimized Table Variables in SQL Server 2014. Register now.


Brent Ozar

May 13

Making SQL Server Work in VMware and Hyper-V
Sponsored by Idera

The company has decided to virtualize everything, but you’re worried that SQL Server won’t play nice. It will – but you just need to know the basics of how SQL Server handles virtual CPU, memory, and storage first. Microsoft Certified Master Brent Ozar has worked with virtual servers in good times and bad, and he’ll share his tips on how to get started quickly with a successful virtualization project. If yours is already on fire, learn why. Register now.


Brent Ozar

May 13

How to Work Around SQL Server Standard Edition’s Limits
Sponsored by Netlib

Champagne taste, beer budget: you need a fast, reliable, and secure SQL Server, but your budget just won’t cover Enterprise Edition. Join Brent Ozar as he covers the most painful limitations of SQL Server 2008, 2008R2, and 2012, and shows some ways to work around them. He’ll also explain which pains go away in SQL Server 2014 – and which ones don’t. Register now.


Jeremiah Peschka

May 20

Introducing sp_BlitzCache

sp_Blitz® and sp_BlitzIndex® help you explore SQL Server’s settings and indexes. sp_BlitzCache takes analysis of the execution plan cache to a whole new level. Join Jeremiah Peschka as he unveils this free tool that makes it easy to perform in-depth analysis on the SQL Server execution plan cache. Register now.


Kendra Little

May 27

The Hidden Evil of Scalar Functions in SQL Server

Triage Tuesday 30 minute Webcast starting at 11:30 AM Central
Are you sure functions in your SQL Server aren’t dragging you down? Join Kendra in this free 30 minute talk to find out the secrets of sneaky scalar functions. You’ll learn which tools misleadingly hide the impact of scalar functions and how you can snoop out the secrets of what’s really going on in your SQL Server. Register now.


Brent Ozar

June 4

FoxPASS Northeast Wisconsin:
Troubleshooting Shared Storage for DBAs

Your SQL Server’s data lives on the SAN, and you’re not happy about that. All the Perfmon metrics you gather seem to point to a storage problem, but the SAN admin says the storage is sitting around bored, so it must be a SQL Server problem. Brent Ozar feels your pain – years ago, he was a DBA in the same position, so when his SAN admin quit, Brent took the job. In just 90 minutes, he’ll teach you what’s inside the SAN, why multipathing is so important, how to test storage throughput, and why TempDB should be on local SSDs.


Brent Ozar

July 17-19

SQLBits XII – Telford UK

Brent is flying across the pond for one of his favorite conferences in the world, SQLBits.

Saturday: Free Sessions – Like a SQLSaturday, but in the UK. Brent’s Saturday sessions will include:

  • How the SQL Server Engine Thinks - When you pass in a query, how does SQL Server build the results? We’ll role play: Brent Ozar will be an end user sending in queries, and you’ll be the SQL Server engine. Using simple spreadsheets as your tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.
  • How to Pick SQL Server Hardware - You don’t buy a lot of servers, but you’re about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions. Which SQL Server edition do you need, does your RPO/RTO dictate shared storage, and does your app need 2, 4, or 8 sockets? Armed with the right questions, you’ll know exactly what hardware to ask for.

Learn more or register now for SQLbits.



Register for the Upcoming Webcasts

  • Scroll up to see the full description of each webcast.
  • The very first name you ever got from your parents. Well, not including your surname. I guess that was first, come to think of it.
  • Your surname. (See, this is really the first name you ever got, because it came by default, like a default value constraint.)
  • The kind people who pay your grocery bill.
  • Has to be a real one because the meeting info will be sent here.

If you register for sponsored webcasts like Dell’s or Idera’s, your name and email will be given to the sponsor for marketing purposes. (Hey, somebody has to pay for all this free training!) If you don’t want your registration details shared with the sponsor, don’t register for those particular webcasts.

css.php