You searched for sp_blitz - Page 7 of 44 - Brent Ozar Unlimited®

Product has been added to your cart.

Office Hours: One-Word Answers Edition

Last Updated October 13, 2022

Production Database Administration

Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done. LetTheDbaHandleIt: My friend needs to track who has accessed what data. This is easy at OS and app level, but how can my friend verify that those who have direct DB access are not snooping on data inappropriately? e.g. payroll or…

[Video] Office Hours Live: Ask Me Anything

Last Updated October 3, 2022

Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…

Erik Darling’s Month of Free Tools Training

Last Updated October 3, 2022

Production Database Administration

Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to show how he uses different SQL Server Community Tools that are free and open source to troubleshoot SQL Server issues. You should read all of them. I did. (I also shamelessly copy/pasted this intro, plus the below,…

[Video] Office Hours: Ask Me Anything at the Mediterranean Sea

Last Updated September 28, 2022

On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered ’em, standing in front of the beach. Here’s what we covered: 00:00 Start 00:37 AllThePartyPeople: On our server, MAXDOP=1 (not my choice); we had a poor performing SP call (called as dynamic SQL; again not my choice);…

[Video] Office Hours: Six-Minute Speed Round

Last Updated September 19, 2022

The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style: Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, Canada. A support person told me today that when creating a table, an ID column…

[Video] Office Hours: Ask Me Anything About SQL Server and Azure

Last Updated September 11, 2022

Got questions about the Microsoft data platform? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today’s episode finds me in my home office in Vegas: 00:00 Intros 02:10 GeorgeDAX: Hello Brent, I’m a dealing with a huge sales table which contains around 500 columns with 50m rows. Business asks…

And it looks bad even in shades.

Office Hours, Short Text Answers Edition

Last Updated September 5, 2022

Production Database Administration

Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you also touched on scrubbing or synthetic data as a way to populate dev environments. Are there any resources/tools you would…

And it looks bad even in shades.

PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing

Last Updated August 24, 2022

Parameter Sniffing, SQL Server 2022

Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which doesn’t work out well for widely varying parameters. Here’s a primer for the basics about how it happens. SQL Server 2022 introduces a new feature called Parameter Sensitive Plan optimization. I’m not really sure why Microsoft capitalized…

Office Hours Speed Round, Text Edition

Last Updated August 10, 2022

Production Database Administration

Got questions for me? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. I filter out the ones that are too short for video answers, and here’s the latest batch: Corrupted: Should DBCC CheckDB be run on secondary replicas in AG as well ? Is it recommended to attach corrupted…

Office Hours Speed Round: Text Edition

Last Updated July 29, 2022

Production Database Administration

Got questions for me? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. I filter out the ones that are too short for video answers, and here’s the latest batch: Thomas Franz: When I have a very large table with no statistics (or not on a specific column in the…

Why Adding Some Memory Doesn’t Fix All Caching Problems

Last Updated July 18, 2022

It seems obvious: add some memory, and SQL Server should be able to cache data, thereby making queries run faster … right? Well, if you can’t cache everything you need for a query, you might be surprised to find that SQL Server may still read the entire table up from disk, regardless of what parts of the…

Updated First Responder Kit and Consultant Toolkit for July 2022

Last Updated July 19, 2022

First Responder Kit Updates

Summer has turned the corner. Sure, right now the First Responder Kit is wearing its swimsuit, basking in the sun, but already as we speak, the days are getting shorter. It’s only going to be a matter of time before the Pumpkin Spice release of the First Responder Kit. Go outside and take a walk,…

Office Hours - ask me anything.

Office Hours Speed Round: Text Edition

Last Updated July 13, 2022

Production Database Administration

Not all of the questions you post at https://pollgab.com/room/brento are hard. Some of ’em can be answered in one line: Q: accidentalDBA: Hi Brent, My friend is moving from two physical servers (production + failover) to VMs on the same host and SAN. His manager wants to keep log shipping as a DR solution. I…

Office Hours - ask me anything.

[Video] Office Hours Speed Round

Last Updated July 7, 2022

In ten minutes, let’s cover as many questions as possible from https://pollgab.com/room/brento: Here’s what we raced through: 00:00 Introductions 00:17 dbacat: We’ve been fighting an AG issue for a while. Sometimes during failover, one or a few databases go into initializing/recovery state on the new secondary. It’s random, never consistent. Only fix is to drop…

Columnstore Indexes are Finally Sorted in SQL Server 2022.

Last Updated July 12, 2022

Columnstore Indexes

There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column. I debunk that myth in the first 30 minutes of my Fundamentals of Columnstore class, where I explain that a better way to think of them is that your table is broken up into groups of rows (1M rows…

[Video] Office Hours in Moab, Utah

Last Updated May 25, 2022

On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:20 YourbiggestFan: Do you have any plans to write an Azure first version of the first responder kit (sp_blitzfirst and sp_bitzcache)which can get the metrics from query store and thus overcome the issue…

10. How SQL Server 2022 Tries Fixing Parameter Sniffing

Last Updated July 8, 2022

Microsoft is aware of how big this problem is, so in 2022, they introduced Parameter Sensitive Plan (PSP) Optimization. We’ll take the simple query we’ve been working on so far, set compatibility level to 2022, and see what happens. Demo Script /* Fundamentals of Parameter Sniffing How SQL Server 2022 Fixes Easy Sniffing Problems v1.0…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Fundamentals of Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access or Fundamentals of Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access, or log in if you already shelled out the cash.

And it looks bad even in shades.

Office Hours Speed Round: Text Edition

Last Updated May 31, 2022

Production Database Administration

Some questions that come in at https://pollgab.com/room/brento have such straightforward answers that I don’t need to cover them on video. It’s time for a rapid-fire speed round: Q: Uncle Buck: Is there a good way to tell if a given include column for a NC index is being used at all? No. Q: Steve E:…

[Video] Office Hours: Cabo Balcony Edition

Last Updated May 15, 2022

Post your questions at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch. Here’s what we covered: 00:00…

[Video] Office Hours: Cabo Pool Edition

Last Updated May 15, 2022

You posted SQL Server questions and upvoted the ones you’d like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through ’em: Here’s what we covered: 00:00 Introductions 00:53 Neil: Does putting up a giant monitor on the wall with SQL Server info…