The PASS Board of Directors election campaign season has started, and candidate Ryan Adams asked if I had any questions I’d like to ask him. Sure! Here goes: Brent: First, thanks for everything you’ve done over the years as a volunteer. I know you work your butt off, and I’m impressed with what you’ve accomplished. How many hours a week are you putting into the community, and what does that week look like? Ryan Adams Ryan: I would say I put in about 15 hours a week on average. That time varies wildly and it is all very sporadic. There might…Read
Adam Machanic, Foodie Adam wrote sp_WhoIsActive, a troubleshooting tool used by tens of thousands of DBAs all over the world. It’s incredibly powerful, it’s saved my butt countless times, and I use it every single week. He gives it away for free to help you. He hasn’t updated it in years – because he doesn’t need to. It’s that good. He co-founded and still runs SQLblog.com. He hosts a blogging platform where a lot of really smart SQL Server people share a lot of really good articles for free. Here, Adam’s a force multiplier – he makes it easier for people to teach others.…Read
I’m a lyrics guy. Sure, I love a catchy beat and a good hook, but I don’t really love music unless the lyrics grab me too. These days, when I find a song I like, the first thing I do is look up the lyrics on RapGenius to hear what they really mean. For example, I’ve loved Sia’s music for years, and she just released a new single, Chandelier. Here’s the music video. Incredibly catchy, and at first I thought the chorus was “1,2,3 1,2, 3, 3.” (I do love Sia, but sometimes she slurs her words.) So off I went…Read
As you transition into database administration full time, you’re going to be working with more people in different departments. The developers, systems administrators, SAN admins, BI team, project managers, and end users will all interact with you because you hold the keys to the data. Jeremiah presenting at SQL Intersection in Vegas It’s tempting to think of yourself as an all-knowing magical guardian, and to think of others as morons. As you gain knowledge, you might become condescending to others. You’ll get angry with developers who don’t write flawless queries, or project managers who think they can host a multi-terabyte…Read
The process of becoming a Microsoft MVP is shrouded in mysteries and non-disclosure agreements. Even after you become an MVP, it’s not clear how Microsoft picks who gets the MVP award. Let’s start with the obvious: the Microsoft MVP nomination form. Anyone can nominate themselves (or others) on that site. The first key is the opening paragraph on the page: “To become an MVP, it takes truly exceptional, voluntary contributions to Microsoft-related social and technical communities, coupled with outstanding community leadership and a willingness to freely share deep technical knowledge with others.” Let’s break that paragraph down and analyze it.…Read
This morning, Ted Kreuger wrote a post called Microsoft Isn’t the Devil. He writes: “What does kill me is the people that insist on the public bashing of a product, like SQL Server. I’m not referring to the daily Oracle DBA that has to install SQL Server. I’m referring to the people that have based their career, income, and livelihood to supplying services to customers based on the product. Truly speaking, I’d like to see those people move on. Work on something you think is perfect in your own little world. My only hope is that really does happen and…Read
My Microsoft MVP status is up for renewal again, so it’s time for a little navel-gazing at the community work I’ve done over the last twelve months. Here’s the data I found most surprising this time around. YouTube Channel Stats This one just completely boggles my mind – you have watched OVER 23,000 HOURS of our videos this year, and that’s just since September 1st: YouTube Channel Stats 3 people are watching a Brent Ozar Unlimited video, around the clock! We must find these three people and show them a different web site or something. Maybe Taylor Smith’s goat duets.…Read
We give away sp_Blitz™, a totally free health check tool for Microsoft SQL Server. It looks for all kinds of common reliability and performance problems and gives you a prioritized to-do list. The number one question I get about it – by far – is, “Why do you give it away for free? Why don’t you charge for it?” Free Beer vs Free Speech We need to start by considering the word free. In the software world, there’s two ways to look at it. The Wikipedia article on Gratis versus Libre sums it up well: Gratis versus libre is the distinction…Read
Database administrators are lonely. In most companies, there’s only one DBA, and nobody else really understands the job duties. We don’t have anybody else we can talk to about the crazy things we run across. I think this is the biggest reason there’s such a vibrant SQL Server community on Twitter – we’re looking for other people who understand us. This January, Jeremiah turned me on to DevOpsReactions.tumblr.com, and I was hooked. DevOps is a new hybrid job, a cross between developers and system administrators. Like DBAs, they’re an unusual profession with very different challenges than most of their coworkers. I knew…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.