One of my training class attendees had an interesting observation: “All this week, when questions have come up about niche topics, you’ve been able to immediately give the name of one person who specializes in that topic. For example, when columnstore indexes came up, you immediately referred us to Niko Neugebauer’s blog post series. When Extended Events came up, you referred us to Jonathan Kehayias’s blog post series. If we wanted to start blogging about something, what areas are wide open for the taking?” With every release of SQL Server, Microsoft brings out cool new features. No one person can…Read
I’ve been watching Steve Stedman’s Database Corruption Challenge with glee. Steve (@SQLEMT) is running one of the toughest kinds of blog posts you can do: an ongoing series that involves a lot of prep, urgent timings, and dealing with plenty of contributions/questions/answers from a lively audience. That is seriously hard work. So I emailed Steve and put even more work on his plate – an email interview. Here’s how it went: Brent: What made you decide to do a corruption challenge? Steve Stedman Steve: I was working on a blog post to explain the concept of how to pull in data from…Read
From about 2012 to 2014, this was my about-me slide at the start of a presentation: About Me, 2014 I’d show that and say, “I’m Brent Ozar, a Microsoft Certified Master and MVP. That just means I’ve made a lot of expensive mistakes, and now I try to help other people avoid those mistakes. I cofounded a consulting company with a couple of my best friends, and it happens to have my name on it.” Then I’d go on to the next slide. In early 2015, we switched to widescreen presentation templates, and for a quick temporary fix, I switched to six…Read
When you’re writing a blog post, stop for a moment to ask: Why is someone reading this blog post? Are they a regular reader who devours all of your posts, in order, and knows you and your style well? Are they walking into Cheers? Or are they hurriedly searching Google for an answer to a question, and they have no idea (or concern) of who you are? Are they running into McDonald’s for a fast meal? A great way to understand the difference is to think about two popular – but very different – SQL Server bloggers: Pinal Dave’s blog SQLauthority.com…Read
Today is the day you stop being afraid. SQLbits Speaker and Topic Board For a long time, you’ve been telling yourself, “Yeah, I should probably start blogging one of these days,” but you’re afraid. Afraid someone else has already written about a topic. Afraid that your writing isn’t impressive enough. Afraid nobody will leave a comment. Well, Ed Leighton-Dick is calling your bluff. His #SQLNewBlogger Challenge is a dare to publish one new post per week, every Tuesday in April. If you’re a new blogger, here’s how I’d do it: Sign up for a blog at WordPress. Use your name as…Read
Every year, I finish up by emptying out my list of blog post ideas. It’s a freeing feeling, letting go of these ideas that I just couldn’t find a way to flesh out, and lets me feel better about new ideas in 2015. Here’s the ideas I just couldn’t hit Publish on in 2014: Database Administrator Warning Labels – you know those big cigarette warning labels in black and white print? Wouldn’t it be cool if Books Online carried similar warnings on certain pages? WARNING: TRIGGERS MAY CAUSE LONG, PAINFUL TROUBLESHOOTING. How to Publish Scripts – whenever you put a…Read
I spoke at my local SQL Server user group last month. I delivered one of my very favorite presentations, and it’s got one of my favorite punch lines. I ask the attendees where SQL Server does its sorting, and someone inevitably answers TempDB. I then say, “Yes, TempDB – or as I call it….” TempDB: SQL Server’s Public Toilet You have no idea what other filthy, disgusting things people are doing in TempDB. It’s a sloppy mess. I’m quite proud of that slide, and every single time I deliver that punch line – every time – it brings the house…Read
I keep a list of blog post ideas in RememberTheMilk.comin case I run out of ideas. After piling up dozens of them, I’m giving up and setting some of my favorites free. If I couldn’t write these in 2011, I’ll probably never get around to it. If you’re looking for inspiration, here you go: Why Bad People Hate Good DBAs – Developers hate us because we find flaws. Sysadmins hate us because we identify hardware problems. Network admins hate us because they can’t blame the database. Just because people hate you doesn’t mean you’re doing a good job, though. 5…Read
Hi. I’m Brent.
I live in Iceland with my wife Erika. I'm on an epic life quest to have fun and make a difference.
I co-founded Brent Ozar Unlimited to help make your SQL Server go faster. I also maintain sp_Blitz® and the open source First Responder Kit repo.