Conferences and Classes

Conferences and Classes

On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special presentation: SQL Query Optimization. Why is it so hard to get right? Dr. David DeWitt The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the…

Performance Tuning in 21 Demos at the PASS Summit 2018

Last Updated October 21, 2018

#SQLPass, Company News

Performance Tuning in 21 Demos You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning by watching slides or reading white papers – you want to jump right into the code and see what happens. You’re the kind of person who loves watching…

Attending our SQLBits Pre-Con? Prepare Your Laptop Now.

Last Updated November 26, 2020

SQLBits

If you’re joining Erik & me at our SQLBits precon, Expert Performance Tuning for SQL Server 2016 & 2017, you’ll be able to follow along with the demos on your laptop. We’re going to be showing you some common and not-so-common query anti-patterns, and explaining how they’re easier to solve with SQL 2016 & 2017.…

Tom Roush, the SQL Server community’s best storyteller.

Last Updated January 30, 2018

You, dear reader, know a lot of SQL Server community names from their blogs, webcasts, podcasts, presentations, books, etc. It can feel pretty overwhelming – there’s so many sites to keep up with, so much good technical material. But even still, you’re only seeing the tip of the iceberg. There are so many wonderful people…

Free Upcoming Webcasts: Query Store, R, AGs, Encryption, Security, and More

Last Updated November 14, 2017

Here’s the lineup for the next free GroupBy online conference: Friday, December 1: 8:00 AM Eastern – Query Store and Query Optimization on SQL Server 2017 by Dean Savovi? 9:00 – Elegant T-SQL Solutions for Real World Problems by Matan Yungman 10:30 – SQL Server R Services in SQL 2016 by Chris Hyde 12:30 – SQL Server Health Checks…

#PASSsummit Day 2 Keynote: Dr. Rimma Nehme on Azure Cosmos DB

Last Updated November 2, 2017

#SQLPass, Microsoft Azure

Dr. Rimma Nehme Summit day 2 keynotes have become special. Over the last few years, Microsoft has dedicated the day 2 keynote to a technical dive into an advanced, future-looking topic. Past examples have included future-looking guidance on Hekaton, columnstore indexes, and how Azure SQL DB protects data. I love Microsoft for doing this. It costs…

#PASSsummit Day 1 Keynote Live Blog

Last Updated November 1, 2017

Good morning, folks, and welcome to our annual live blog of the PASS Summit Day 1 keynote. Open the free live video stream at PASSsummit.com in one browser tab, and then refresh this page every couple/few minutes. I’ll be adding my thoughts at the end of the page, in chronological order, for easier reading later. Today’s…

#PASSSummit Expert Performance Tuning Pre-Con: Stretch Goals

Last Updated October 6, 2017

Sure, they look trustworthy Eric and I are doing a PASS Summit pre-con class called Expert Performance Tuning for SQL Server 2016 & 2017. To encourage signups, we’re giving every attendee a free Enterprise/Everything Bundle, plus some other surprises you’ll get during the event. Response has been absolutely bonkers – over 300 of you have…

Register Now for Next Friday’s Free GroupBy Conference

Last Updated August 21, 2017

It’s that time again! Register for free now to attend next Friday, September 1. Here’s the lineup: 8AM Eastern – Why Defragmenting Your Indexes Isn’t Helping – Brent Ozar (@BrentO – BrentOzar.com) 10AM – How to Evaluate if SQL 2016 In-Memory OLTP is Right for Your Workload – Ned Otter (@NedOtter – NedOtter.com) Noon –…

Abstracts Open for GroupBy December

Last Updated August 11, 2017

Want to present at the upcoming GroupBy December 1 & 8 online conference? Read the abstracts submitted so far Submit your own abstract Readers will comment on your abstract, helping you improve it (so don’t kill yourself working really hard on the first draft – think of it as a living abstract that you’ll work…

[Video] Last Season’s Performance Tuning Techniques

Last Updated August 1, 2017

#SQLPass, Development, Videos

You’re kinda-sorta comfortable doing performance tuning on SQL Server. You’ve read a few blogs, you monitor Page Life Expectancy, you rebuild your indexes, and you add an index here or there. However, you haven’t been to a day-long performance tuning class yet, and you’re wondering what you’re missing. Thing is, in SQL Server, performance tuning…

Last Season’s Performance Tuning Techniques: Slides & Demos

Last Updated August 1, 2017

#SQLPass, Development

Right now, Erik and I are presenting at the 24 Hours of PASS. We’re talking about Last Season’s Performance Tuning Techniques: Wanna play along with us as we show how your performance skills might be a little out of date? Here’s the demos and the slides: Last Season's Performance Tuning Techniques from Brent Ozar Fill…

24 Hours of PASS: Last Season’s Performance Tuning Techniques

Last Updated June 22, 2017

Brent, last season (and I have so many good bad photos to share) I’m excited to announce that Erik and I are presenting the opening session at this year’s free online 24 Hours of PASS webcasts! Here’s our session: Last Season’s Performance Tuning Techniques You’re kinda-sorta comfortable doing performance tuning on SQL Server. You’ve read…

New #SQLPASS Summit Pre-Con: Expert Performance Tuning for SQL Server 2016 & 2017

Last Updated October 6, 2017

#SQLPass, Company News

Going to the PASS Summit in Seattle this year? Join me & Erik Darling on Tuesday, the day before the conference, at our pre-con session, Expert Performance Tuning for SQL Server 2016 & 2017. Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out.…

This Year is Your Best Chance to Speak at the PASS Summit.

Last Updated May 22, 2017

#SQLPass, Writing and Presenting

Me presenting, photo by John Martin The call for speakers at the PASS Summit is open now. As of this writing, there are less than 120 sessions submitted. To put that in perspective, in 2016, there were 758 sessions submitted overall, and about ~175 general session spots. Your chances have never been better. Get in…

Wanna speak at the PASS Summit? Here’s how.

Last Updated April 16, 2017

#SQLPass, Writing and Presenting

The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. Getting in is legendarily difficult because competition is fierce. Many sessions are submitted for each one that’s accepted, and you have to work hard to stand out from the pack. This year’s Call…

How to Join the SQL Server Community Chat in Slack

Last Updated December 11, 2020

Just another day on Slack Slack is a team chat system where you can: Go to SQLslack.com to get a free instant invite, and then join Go to https://SQLcommunity.Slack.com, or download the Slack app Meet cool people and join their chat rooms Chat rooms at SQLCommunity include: #SQLhelp and #PowerShellHelp – very active #FirstResponderKit – questions and…

It’s #GroupBy time! Wanna watch free SQL Server training?

Last Updated April 17, 2017

You voted in a great lineup for this Friday’s free GroupBy.org conference: 8AM Eastern – How to Use Parameters Like a Pro and Boost Performance by Guy Glantser 10AM – Introducing the SQL Server 2016 Query Store by Enrico van de Laar Noon – Worst Practices & Less Known Limitations for Columnstore Indexes by Niko Neugebauer 2PM – Gems to…

Registration is Open for GroupBy.org’s April Free Conference

Last Updated March 18, 2017