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.

Jeremiah Peschka

April 22

Introduction to Extended Events

Triage Tuesday 30 minute Webcast starting at 11:30 AM Central
Extended Events were introduced with SQL Server 2008R2. Extended Events is a replacement for Server Side Traces and so much more – it’s a lightweight way to look at SQL Server performance, events, deadlocks, locking, blocking, and more. In this webcast, Jeremiah Peschka provides a high-level introduction to Extended Events. You’ll learn about how Extended Events are structured, how to find out what’s available, and where to get started. Register now.


Jeremiah Peschka

April 24

Building a Health Check Report

Rochester PASS SSUG, in person event starting at 6:30PM Eastern
Just like you need a regular physical exam, your SQL Servers need regular critical care from a trained professional. A good check up is more than just running a few DMV queries and producing a laundry list of best practices – when done right a health check will give you a list of symptoms, a set of risks and potential mitigations, and a prioritized action plan. In this session, you’ll learn the basic tools and techniques that a database administrator needs to get started creating a process to assess server health and start performing regular SQL Server checkups.


Brent Ozar

April 26

SQLSaturday Chicago

How to Think Like the Engine – You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.

Real-Life SQL 2012 and 2014 Availability Group Deployments – You want to deploy AlwaysOn, but you’re concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 and SQL 2014 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he’s found in real-life deployments of AlwaysOn.

Register now.


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.

Thursday: Brent’s All-Day Pre-Con on Virtualization, Storage, and Hardware for SQL Server – £275 – You’re a DBA who manages SQL Servers, and you’re frustrated with slow performance. The VMware and SAN admins tell you it must be a SQL Server problem, but you’re not so sure. Microsoft Certified Master Brent Ozar went through the same problems, and he decided to go behind enemy lines. He became a SAN admin and VMware admin, learned how to tie these parts together, and figured out how to configure both sides of it to work well.

Friday: Deep Dive Training Day – £150 – Multiple tracks of top-notch speakers doing deep dive sessions. You can pick and choose the sessions that are right for your needs. Brent will present Watch Brent Tune Queries, a completely demo-filled session where he takes sample Stack Overflow queries and makes them go faster with query tuning and index tuning.

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