Conferences

Brent Jazz Hands

Upcoming Conferences

I present at a lot of database conferences. Here’s where to find me next:

SQL Intersection
Nov 18-21, Las Vegas

Friday post-con: Developer’s SQL Server Recipe Book – You and your team have to build a lot of queries: transactional insert/update/deletes, batch jobs, and reports. You’re comfortable writing queries to get data in and out, but they’re just not as fast as you’d like. You’re looking for a set of examples that you can follow – plus a list of anti-patterns that seem good until they just don’t scale. I’m Brent Ozar, recovering developer and now a DBA. I’ll share my favorite T-SQL starting points for different business requirements. We’ll implement them on the Stack Overflow database, and you can follow along on your laptop. We’ll cover techniques like pagination, row-level security, building and maintaining denormalized reporting tables, and passing lists of parameters into procedures. Attendees get their choice of a Recorded Class Season Pass, SQL ConstantCare®, or the Consultant Toolkit. Register for a post-con here.

Thursday regular session: What’s New in SQL Server 2019: 100% Demos – You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don’t have time to rewrite all your queries or learn new languages – you just want the database to go faster. I’m Brent Ozar, and I’ll give you the whirlwind tour. I’ll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I’ll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect. No slides here – not even an about-me slide. Let’s dive into some queries!

Thursday regular session: Writing Fast, Safe Dynamic T-SQL – Your users want one query that does EVERYTHING, like searching products by size, color, stock quantity, price, and more. You’ve tried using OR, COALESCE, and ISNULL, and you just can’t get your queries to perform well. In this all-demo session, we’ll build dynamic SQL the professional way, making sure that SQL Server uses indexes when it can, make our troubleshooting as easy as possible, and avoid SQL injection.

SQL Saturday Jacksonville
May 1-2

Friday 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 jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.” Attendees get their choice of a Recorded Class Season Pass, SQL ConstantCare®, or the Consultant Toolkit. Learn more and register now.

SQL Saturday Stockholm
May 8-9

Friday 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 jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.” Attendees get a year of my Consultant Toolkit. Learn more and register for the pre-con now, and register for SQL Saturday Stockholm here.

SQL Saturday Oslo
August 28-29

Friday 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 jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.” Attendees get a year of my Consultant Toolkit. Learn more and register now.

SQL Saturday Gothenburg
September 4-5

Friday 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 jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.” Attendees get a year of my Consultant Toolkit. Learn more and register now.

Upcoming Conference Roadmap

Here are a few events I’ve got penciled into my schedule, but they aren’t official yet, just holding dates in case things work out:

  • 2020/05 – SQL Saturday Helsinki, Finland
  • 2020/06 – SQL Saturday Los Angeles
  • 2020/09 – SQL Saturday San Diego
  • 2020/11 – PASS Summit in Houston
Menu
{"cart_token":"","hash":"","cart_data":""}