Hi, Brent here! I’m really excited to welcome you to Fundamentals of Query Tuning.

Read this whole page: there’s a lot of stuff in here for you.

To prep, watch How to Think Like the Engine.

Before we get started, I need to make sure that we’ve covered the basics. In my free 90-minute How to Think Like the Engine class, you’ll learn the foundations of clustered and nonclustered indexes, statistics, memory grants, and sargability.

That alone doesn’t guarantee that you’ll be able to keep up in class, of course – but if you hadn’t at least learned this much before starting, then you’d have been totally screwed, hahaha.

Now, get your computer ready for the live class.

To ask questions and talk to the other attendees, get an instant invite to Slack here, then join the #BrentOzarUnlimited channel. This way attendees can help each other with their questions during the live labs. (We don’t use the GoToWebinar Q&A or chat because you can’t see each other’s chats.)

To follow along with the demos, download a Stack Overflow database. I’ll be using the medium-sized 50GB StackOverflow2013 database, but if you’ve got a different one handy (either the smaller 10GB or larger 300+GB one), that’s fine too – the same concepts will still apply. If you’re on a slow desktop/laptop, feel free to use the small 10GB StackOverflow2010 database.

Attach it to any supported version of SQL Server, can be Standard, Enterprise, or Developer. (Sorry, SQL Server 2008 and Express Edition won’t cut it here.) If you want a free development or evaluation version of SQL Server, hit up SQLServerUpdates.com.

8 Comments. Leave new

  • Hi Mr Ozar,

    Is it possible for a group of people to share a single database for this class? It would be great (and much cheaper!) if I could set up one larger database that four to five people connect in to, rather than creating multiples of the same system.

    Hope you are well.

    Keith

    Reply
  • John Megens
    March 8, 2021 4:38 pm

    Hi Brent,

    The link ‘download the ~1MB zip file of slide PDFs here (last updated 2021-01-24)’ gives me an Error:


    InvalidAccessKeyId
    The AWS Access Key Id you provided does not exist in our records.
    AKIAZPBBOMEJ5XTVISOG
    VHJM7VG2CB9KC8DB
    +WZqCU2Bz4Hx+19zD4c8x6nVjvffkIyDoQb2IX/7cYXCFuil4KV35TGG8t6PjybFFWoqKPJhX60=

    Reply
  • Hi Brent,

    The link to get an invite to the Slack community is saying it is no longer active.

    Is there a new way to get access to the Slack channels?

    Thanks very much!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu