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. You’ve never had a formal database internals class, and you don’t really have the patience to read a book on it – but you want a quick foundation.
In this free 90-minute series of videos, you’ll learn:
- How clustered index pages are stored on disk and in memory
- How (and when) to make a covering index
- The basics of execution plans
- What determines sargability
- What SQL Server uses to estimate the memory your query needs
- What happens when those estimates are wrong
- When you should get fresh estimates by recompiling the query
- How to avoid SQL Server’s public toilet, TempDB
- And it’s all demoed with these Stack Overflow database pages (PDF)
I’m making it free because I’m more proud of it than any other session I’ve ever done, and I think it makes a world of difference in how people understand the mechanics of databases. Over and over again, when I give it in person, people say, “Wow! I had no idea it was really this simple!” I end up starting most of my in-person training classes with it, to get everybody on the same page, and I started thinking: “What if I could just get everybody out there on the same page, period?”
And what if I could make it easier for you to get your coworkers, developers, and ISVs all on that same page? What if I could move the community knowledge forward, and help jump start new presenters? The only way to do it was to make it completely free.
So watch the video class to learn how to present it, and then download the open source slide deck and give it at your user group or company’s lunch-and-learn.
I hope you enjoy it, and if you present it, I’d love to hear how it goes!
21 Comments. Leave new
Thank you!
You’re welcome!
Thank you!
(Yep. One of those pesky developers …)
Thank you very much!
Thank you so much!
What you do for the community is admirable.
Also, is it pronounced SARGable or SARGable? I suppose it’s the same consonant sound as “.gif”.
Like ‘Sargeant’…
Phil – watch the video and you can find out. 😉
Great course – you are a generous man! 🙂
Thanks Brent!
> And what if I could make it easier for you to get your coworkers, developers, and ISVs all on that same page?
This line really hit me–I recalled many scenes over the years in which i’d enthusiastically tried to explain bits and pieces to colleagues, friends, pets, candy-bearing strangers, etc. and fallen (i felt) remarkably short, and how awesome it would’ve been to be able to say: “this Brent guy here explains this stuff way better than me, check it out!”
now, I can. I mean, I have said that about this blog, many times, but now with the video i now get to add “take 90 minutes and learn, better, what took me years of stumbling around in the dark to sort of learn by bitter experience.”
Bravo!
Mike – thanks, man!
Thanks Brent. As Always, a leading light in the sometimes murky world of SQL server. An excellent resource to train developers and DBA’s alike.
As always, thanks to you and your team for help the community.
That was just…. brilliant! Best time spent ever! Thanks!
You are awesome man. I didn’t know this existed. Thank you!
I love it! Thank you!
Really appreciate the free videos as well as this blog. Very informative and easy to understand.
> “What if I could just get everybody out there on the same page, period?”
After watching these videos, I’m fairly certain that having everyone on the same page would improve performance.
😀
Excellent course. Thanks!
This is amazing… you care for the SQL Server community, thanks for sharing!
You’re welcome, glad everybody’s enjoying it.