Product has been added to your cart.

Videos

Home
Videos

Office Hours

[Video] Office Hours: Open Q&A About SQL Server

Last Updated September 3, 2020

Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook channels. I’ll be: Live coding in the First…

Watch Brent Tune Queries at SQLSaturday Oslo

Last Updated August 29, 2020

Execution Plans, Videos

This morning, I had the honor of presenting virtually at SQLSaturday Oslo. The session title, Watch Brent Tune Queries, explains it all. Enjoy! In the session, I used the 2018-06 Stack Overflow database, but any recent full-sized copy (not the 2010-2013 copies) will work. Here’s the query I worked with: /* Watch Brent Tune Queries:…

Date Tables are Great for Users, but Not So Great for Performance

Last Updated August 5, 2020

Execution Plans, Videos

Date tables help users filter data based on day of week, holiday, this year vs last year, and other kinds of filters that business users usually wanna add to their reports. If you haven’t used a date table before, here are a couple of primers on how to create one and use it: Creating a…

[Video] The Top 10 Developer Mistakes That Won’t Scale on Microsoft SQL Server

Last Updated July 30, 2020

Development, Videos

You’re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you’ll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big…

[Video] How to Think Like Clippy (Subtitle: Watch Brent Wear Another Costume)

Last Updated July 27, 2020

Indexing, Videos

Remember Clippy, the Microsoft Office assistant from the late 1990s? He would pop up at the slightest provocation and offer to help you do something – usually completely unrelated to the task you were trying to accomplish. Sadly, the Office team told Clippy that he didn’t make the stack rankings cut, so he relocated over…

Office Hours Podcast

Announcing Saturday & Sunday Office Hours.

Last Updated July 20, 2020

During the quarantines, I’m doing free training. It looks like we’re going to be stuck inside here for another long while, so for the next couple of months, I’m bringing back Office Hours, but on a different schedule. Every Saturday & Sunday morning from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook…

[Video] How to Find Queries Using OPTION RECOMPILE (And Their Parameters)

Last Updated June 23, 2020

Development, Videos

For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution plans. Hated it. SQL Server just doesn’t make it easy to find queries with recompile hints. Then Erik Darling’s sp_HumanEvents came along. And now troubleshooting frequent compilations is as easy as this: Transact-SQL EXEC dbo.sp_HumanEvents @event_type =…

[Video] Top 3 Pitfalls of Managing Your Azure SQL DB Costs

Last Updated June 23, 2020

Azure SQL DB, Videos

You manage servers, not invoices. Your company has started to move their databases into Azure, and they’re asking questions that you’re just not ready to answer. How big does your server need to be when you’re moving an existing database up to the cloud? How are servers measured? How do you measure to know if…

SQL ConstantCare

SQL ConstantCare® Population Report: Spring 2020

Last Updated June 1, 2020

SQL Server Population Report, Videos

Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the spring 2020 version of our population report. Our SQL ConstantCare® service lets users send data in about their SQL Servers and get health & performance advice via email. Users can opt in to…

[Video] Watch Brent Write Queries

Last Updated June 23, 2020

This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a varied workload I’ve got running, the more realistic it feels. For this session, I specifically wanted to…

[Video] Watch Brent Write T-SQL

Last Updated June 23, 2020

First Responder Kit, Videos

This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write the proof-of-concept query: In part 2, the second hour, I…

How to Think Like the SQL Server Engine

[Video] How to Think Like the SQL Server Engine: All-Demo Edition

Last Updated May 18, 2020

How to Think Like the SQL Server Engine, Videos

You’ve heard of my free How to Think Like the Engine class, and maybe you even started watching it, but…it has slides, and you hate slides. Wanna see me do the whole thing in Management Studio, starting with an empty query window and writing the whole thing out from scratch live? This session is for you.…

[Video] The Database Community is Bigger Than It Looks.

Last Updated May 14, 2020

Right now, in times like this with insane amounts of change, it can feel like you’re alone, especially as a data professional. You’re not. In this 16-minute Twitch live stream, I explain how data professionals can feel so isolated and alone even in a good year, let alone a really challenging year like this.

[Video] How Can I Measure If My Database Does More Reads Than Writes?

Last Updated April 5, 2020

Production Database Administration, Videos

When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users run a lot of queries all day that are simply satisfied from the buffer pool. SQL Server caches your data so it doesn’t have to hit…

[Video] Watch Brent Work on sp_Blitz

Last Updated April 5, 2020

sp_Blitz, Videos

During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you…

[Video] What Percent Complete Is That Index Build?

Last Updated March 24, 2020

Index Maintenance, SQL Server 2017, Videos

SQL Server 2017 & newer have a new DMV, sys.index_resumable_operations, that show you the percent_completion for index creations and rebuilds. It works, but…only if the data isn’t changing. But of course your data is changing – that’s the whole point of doing these operations as resumable. If they weren’t changing, we could just let the operations…

“Working” From Home? Watch A Bunch of Free SQL Server Videos on YouTube.

Last Updated March 13, 2020

You’re new at this working from home thing, and you’re trying to put Game of Thrones up on a second monitor while you work? Listen, that’s not gonna play out well. You’re gonna get distracted and you’re not gonna get any work done. Instead, if you’re gonna have something in the background, learn about SQL…

[Video] Watch Brent Tune Queries

Last Updated January 31, 2020

Execution Plans, Videos

Ever wonder somebody else does it? Watch over my shoulder as I spend 9 minutes in PowerPoint explaining the big picture, and then about 40 minutes working on this stored procedure in the StackOverflow2013 database: If you enjoy that, the Watch Brent Tune Queries page has another video and other query examples. Enjoy!

[Video] What’s New in SQL Server 2019

Last Updated June 25, 2020

SQL Server 2019, Videos

We must be getting pretty close to the official release of Microsoft SQL Server 2019. There are less than 80 days left in the year. (Interestingly, it’s been almost 60 days since Release Candidate 1 shipped – that’s unusually long for a delay between builds. Hmm.) With the clock ticking down, now’s a good time…

Help! SQL Server 2008 is Still Here!

[Video] Help! SQL Server 2008 is Still Here!

Last Updated July 9, 2019

SQL Server 2008, Videos

Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing’s changing at your company. You still have SQL Server 2008 in production, and you’re a little nervous. How should you approach the conversations with management? Brent Ozar will help: he’s been there too, fighting…

Menu