Steve Jones asked data professionals to cover four days in our lives, so I blogged about a normal non-client-facing day, and then an unproductive day. Today is different: I’m client-facing. We specialize in a 3-day SQL Critical Care: Day 1 – we meet with the client to dig through their SQL Server together while we ask them questions about their database, indexes, queries, designs, RPO/RTO goals, hardware, and more. Day 2 – we split up. The client goes back to doing their thing, and we write the findings for them. (You can see examples of the findings on that page above.)…Read
Yesterday, I blogged what I did in a random work day per Steve Jones’ suggestion. And yesterday, I said I’d blog today as well because it was going to be a different schedule. You shouldn’t read this. It’s useless. It’s useless because as I look back on it, I didn’t accomplish much of anything on Wednesday, July 18th. That’s not rare – there are plenty of days where I feel like I don’t make enough progress. Thing is, Steve wanted us to share the tools we’re using and what problems we’re solving, and this post is pretty well devoid of that information…Read
Steve Jones asked data professionals to cover four days in our lives, so here goes the first post: what I did on Tuesday, July 17th, 2018. Nothing special about this day, just the day that Steve prodded me to take part, heh. My days are radically different, so I’m glad he said to do this four times – otherwise I’d feel guilty about just posting this one without more explanation. (I’ll do this again for July 18th because it’ll look totally different, but then hold off for a few days before posting another.) 4:07AM – I wake up without an…Read
The 2018 Data Professional Salary Survey is open, and you can analyze the results as they’re coming in. As of this writing, we’ve just crossed 1,000 results (last year we ended up with around 3,000). Based on your feedback, I made a few tweaks to the questions and answers. I’m going to focus on a quick check of how those tweaks are doing. We split “DBA” into a few jobs. Last year, 52% of the responders identified as DBAs, so this year we broke that up into 3 titles. Responses so far: DBA (Development Focus – tunes queries, indexes, does…Read
For this month’s T-SQL Tuesday, Mal asked us to blog about our 2018 learning goals. Her homework assignment included these 3 questions: What do I plan to learn? I like being at the cutting edge, learning things today that people are going to pay a lot for 5-10 years from now. I like to skate to where the puck is going. If a technology is already popular, then it’s too late for me to start learning it. In the early to mid 2000s, that meant learning virtualization, which paid off really well as that grew wildly in popularity. Then around…Read
Generalists say things like, “Yeah, I’ve done something kinda like that before, and I’m sure I can figure it out again.” Generalists get paid to learn new things fast and adapt. Specialists say things like, “Yeah, I did that exact same task last week, and I know it forwards and backwards.” Specialists get paid for things they already know very well. Generalists are generally useful. Armed with a good set of generalists, companies can generally tackle most IT problems that come their way. As a company’s tech stack changes, the generalists can learn new skills and stay productive. Therefore, generalists get…Read
For this month’s T-SQL Tuesday, Kendra Little asked us to share our interview patterns, anti-patterns, highs, and lows. Several years ago, I was talking to a prospective employer via phone, and things were sounding really interesting. I made it past the first couple rounds of remote interviews, and they wanted me to come into the office for the final round. The interview started with a tour of the offices, and things seemed alright enough at first until we got to the part of the building where the technical people worked. We stepped into one room maybe 20′ x 20′, and…Read
Most older companies and people default to closed. They build things in private and discuss what they’re doing behind closed doors. “Collaboration” usually means by invite only. Most newer companies and folks default to open. They build things out in public in their Github accounts while conducting discussions in public Slack rooms that anyone can join. Even if they’re private Slack rooms, they’re open to anyone inside the company. (I’m making a sweeping generalization here. Of course there were people doing open source for decades, and IRC has been around for forever. But note that Github and Slack are both…Read
I’m not talking about a vacation. Yes, you need to take vacations, but this is different. Every now and then, you need to step back and ask yourself: Do I like what I’m doing? Do I like where I’m doing it? Do I like the exchange of benefits for my work? Every quarter for over ten years, I’ve gone to a coffee shop or bar and spent the day thinking through the above questions, my Getting Things Done 50k foot goals, and my Epic Life Quest. The rule: no network connectivity: just me and a notepad, thinking. It usually takes me at…Read
Several years back, I had the pleasure of working with Paul Randal (blog – @PaulRandal) – first in the Microsoft Certified Master program, and then later at SQLskills with Paul & Kim. I had a phenomenal time – they’re truly wonderful people – and I want to share two of my favorite lessons that still come in handy every week. 1. When answering, be comfortable saying “I don’t know.” When someone asks you a question that stumps you, be honest immediately and say: “I don’t know, but here’s where I would go look: ____.” Paul Randal never did teach me the…Read
Hi. I’m Brent Ozar.
I live in California 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.