Conferences and Classes

European Union Folks: Wanna Attend Mastering Index Tuning?

August 10, 2020

You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. I’ll teach you the most important advanced lessons in one day. In my one-day Mastering Index Tuning online workshop at SQLbits, you’ll learn: My D.E.A.T.H.…

Things To Consider When Submitting Sessions to Paid Online Conferences

June 29, 2020

Brent Ozar

Conferences and Classes

Lots of paid conferences are happening online these days, so some of you will be presenting an online session or pre-con for the first time. I’ve done a bunch of these and been burned in a bunch of ways, so lemme save you some time and heartache. Does the conference own the recordings? And if…

How Doug Lowing Gets the Most Out of His Live Class Season Pass

June 18, 2020

Brent Ozar

Conferences and Classes

With my Live Class Season Pass, students have the ability to attend as many of my live online classes as they want for an entire year straight, plus they can view the instant replay recordings whenever they want. Doug Lowing, one of the students, shared with me how he gets the most out of his:…

Attention Season Pass Holders: New Fundamentals of Parameter Sniffing Videos Available!

May 27, 2020

Brent Ozar

Conferences and Classes

No Comments

If you’ve got a Recorded Class Season Pass or Live Class Season Pass, time to get your learn on: yesterday’s Fundamentals of Parameter Sniffing class recordings are now available in your account here. As a reminder, here’s the class abstract: Sometimes the exact same query goes slow out of nowhere. Your current fix is to…

Announcing Two New Parameter Sniffing Classes

May 5, 2020

Brent Ozar

Company News, Conferences and Classes

During the quarantine downtime, I’m working on a couple of new classes that I think you’re gonna like. Both of them are 100% demos, no slides (other than introductions at the start of the day), complete with hands-on lab assignment challenges for you to solve. They’re both half off this month to celebrate the launch,…

Free Webcast on Dynamic SQL Pro Tips

May 1, 2020

Brent Ozar

GroupBy Conference, T-SQL

Dynamic SQL is one of the most powerful tools in the database developer’s arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by leveraging better indexes. However, when done wrong, it’s extremely painful to troubleshoot. I’ve been working with…

Want SQL Server Training? Copy/Paste This Email To Your Boss.

April 8, 2020

Brent Ozar

Company News, Conferences and Classes

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Saturday presentations. These days: The events you wanted to…

Announcing Two Free Live Fundamentals Courses This Wednesday & Thursday

April 6, 2020

Brent Ozar

Conferences and Classes

During the quarantines, I’m trying to keep you busy with free online training. Last week, I unveiled the new free Quest Database Training Days, and this week, I’ve got another one. I’m going to teach my Fundamentals classes live, free! Wednesday, Fundamentals of Index Tuning – 9:00-5:00 Eastern (13:00-21:00 UTC) – click to see in your own…

Announcing Quest Database Training Days: Free Live Training with Me, Janis, and Pinal

March 30, 2020

Brent Ozar

Conferences and Classes

During the quarantines, I’m trying to find as many ways as possible to get y’all free training. Today & tomorrow are the last days that you’ve got free access to the recordings of my Fundamentals of Index Tuning and Fundamentals of Query Tuning classes – get those while you can, because they’ll disappear when March…

How COVID-19 Affects Conferences

March 11, 2020

Brent Ozar

Conferences and Classes

SQLBits just postponed their event, and I’m stepping out of SQL Saturday Iceland as well. I’ve had the unusual position of being a conference attendee, speaker, and sponsor, all at different times of my life, so I wanted to do a quick brain dump explaining some of the gotchas involved behind the scenes. Canceling a…

What Should I Submit to the PASS Summit?

February 12, 2020

Brent Ozar

#SQLPass

Our industry’s biggest conference, the PASS Summit 2020, just opened their pre-conference workshop call for speakers. I’m going to submit a couple of sessions, but I want to hear from you first: if you were going to try to convince your boss to buy you a pre-conference workshop at Summit, what would be the topics…

How to Pick a 2020 Microsoft Database Conference

February 10, 2020

Brent Ozar

Conferences and Classes

As a consultant and speaker, I’m lucky enough to go to a crazy number of SQL Server conferences. Here’s what I think of each mainstream conference out there – who they’re for, and who they’re not for. SQL Saturdays 2020 dates: all over the world, size varies by city, typically 200-300 attendees Length: Friday pre-conference…

Voting Open for #SQLBits Sessions, and Here’s My Oddball Idea

December 19, 2019

Brent Ozar

SQLBits

No Comments

Voting is open now for SQLBits sessions, and I have to warn you that there are a LOT of sessions to choose from. Bits doesn’t just flat out take the top vote-getting sessions – they use votes as part of the session selection factor – and I don’t want you to think I’m campaigning for…

Join Me in London for My SQLBits Pre-Con Workshop: Mastering Index Tuning

December 16, 2019

Brent Ozar

Company News, Conferences and Classes

I’m teaching an all-new hands-on workshop, Mastering Index Tuning. I’m taking my favorite, toughest modules of my 3-day online class and condensing them down into a 1-day workshop. You’ll learn quick, easy techniques to use the right nonclustered indexes, filtered indexes, indexed views, and columnstore indexes that will work on SQL Server 2019, 2017, 2016,…

I’m coming to SQL Saturday Stockholm! Registration is open now.

November 15, 2019

Brent Ozar

Conferences and Classes

Hello again, Sweden! I’m coming to SQL Saturday Stockholm in May 2020. I’ll be teaching my Performance Tuning in 21 Demos workshop: 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…

I’m coming to Gothenburg & Oslo next summer.

October 1, 2019

Brent Ozar

Conferences and Classes

The Nordic countries are some of the most beautiful places I’ve ever seen. Erika and I are scheduling a few trips over there in 2020, and the first one I can announce is SQL Saturday Gothenburg and SQL Saturday Oslo. I’m teaching my one-day workshop before each event: Performance Tuning in 21 Demos. You’re a…

How to Set Up Your Own Mastering Class VM

September 11, 2019

Brent Ozar

Conferences and Classes

When you buy one of my Live Class Season Passes, you can save a lot of money by building your own VM to follow along with the labs. Or, you might just wanna re-run the labs later to see if you can do a better job, or if you’re still mastering a concept. You’re going…

Registration Open for My SQLSaturday Sacramento Workshop

March 28, 2019

Brent Ozar

Conferences and Classes

I’m coming to Sacramento this year for SQLSaturday #885. On Friday, I’ll be teaching a one-day pre-con: 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…

Registration Open for My SQLSaturday Boston Pre-Con

March 19, 2019

Brent Ozar

Conferences and Classes

No Comments

I’m coming to Boston this year for SQLSaturday #877. On Friday, I’ll be teaching a one-day pre-con: 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…

Poll Results: What Conference Schedule Did You Prefer?

March 18, 2019

Brent Ozar

Conferences and Classes

Last week, I asked you a couple of questions: When you attend a 1-day conference like a SQLSaturday or SQL Relay, what is your preferred session schedule? You said: 31.8% (211 votes): 6 60-minute sessions 31.3% (208 votes): A mix of 45-minute and 90-minute sessions 25.3% (168 votes): 7 45-minute sessions: 25.3% 11.6% (77 votes):…