SQL Server

Welcome to sp_BlitzCache™ v2.4. This release brings a few changes and bug fixes. Fixed a logical error in detecting the output table. Thanks to Michael Bluett for pointing that out. Sorting by executions per second finally works. Thanks to Andrew Notarian and Calvin Jones for submitting this week. Added a @query_filter parameter – this allows…

Jeremiah has coffee at the PASS Summit We’re a group of specialists and teachers here at Brent Ozar Unlimited. But we didn’t start that way– we started out as engineers and developers. So what was it that changed our career trajectories? For each of us, we had a lot of smaller factors along the way, but…

If you’re going to a SQL conference for the first time, join us to learn how things work. We’ll share what happens when you walk in the door for the first time, where to go after hours, what to bring, and what NOT to bring. http://youtu.be/wUuX4gUKyOE

We’ve added two new one-day pre-conference classes to our 2015 calendar: SQLSaturday Boston Pre-Con: Developer’s Guide to SQL Server Performance – You’re stuck with a database server that’s not going fast enough. You’ve got a hunch that the biggest bottleneck is inside the database server somewhere, but where? In this one-day class, you’ll learn how to use powerful…

So you’ve got a great idea for a new feature to add to sp_BlitzSomethingOrOther, what’s the best way to get started? The Documentation Says… If you read our code contribution guidelines, you should write new code, write a test, sign an agreement, and then send us your code. That’s technically correct, but it’s a daunting task. After…

How it feels to say the exact wrong thing. It can be a tricky to introduce yourself to people at conferences when you read their blogs and watch their presentations and videos. You feel like you know them, but they don’t know you yet. What the heck do you say? So you take a deep…

If you lead a local SQL Server user group, and you’re coming to the PASS Summit in Seattle next month, we’d like to say thanks. We’re giving away 5 seats to our Make SQL Server Apps Go Faster class that runs on Monday/Tuesday before Summit. We know you probably have duties you need to attend…

We’re really excited about our new video because Epipheo managed to capture our work and our personalities. Here’s our favorite parts: Brent Loves the Beer Pong My favorite part is almost a throwaway gag – the database emergency is over, and our hero is moving on to other things: Back to Work It’s only on…

I love going on the RunAs Radio podcast because Richard Campbell is so much fun to talk to. In this show, we talk about the amazing new hardware that has come out lately for SQL Server. Dell and HP have brought out some amazing gear – support for 1.8″ SSDs, 64GB DIMMs, and more. The…

SQL Server Agent is one of my favorite tools – it allows you to automatically schedule jobs, alert you if things are going badly, and capture information into database tables. One common request is to execute a query and send the results via email on a regular basis. This task is a great match for SQL Server…

We had a comment recently on Five Things That Fix Bad SQL Server Performance that got me thinking. The comment came from a frustrated system administrator, who wrote: Chucking resources at a problem is not solving that problem, it’s just temporarily masking the symptoms of that problem. Funnily enough, I’ve heard the exact same thing from…