Posts by Brent Ozar

We were looking at magnetic poetry words on a public bathroom wall (true story, insert TempDB joke here) and thought, “You know what would be really awesome? If there was one of these for databases.” So we made ’em. SQL Server Magnetic Poetry Each of us put together our own favorite database words, so we each have our own…

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope. I do this every week, and I’ll share my proven methodologies to performance tune with…

Doctors Without Borders is a truly awesome charity. Medical professionals volunteer their own personal time to go to war-torn countries and solve issues of world health. SQL Server community member, MCM, and all-around-good-guy Argenis Fernandez organizes Argenis Without Borders, a giving event to help. Last year, the SQL Server community helped raise $13,000 for this…

Jeremiah teaching in Portland We just finished up the last of our 2015 training classes, and the reviews have been glowing: “I have attended many training classes in my 19 years as a DBA, including Oracle and SQL Server. This is the first class where 75+% of the information I learned is applicable to my…

Sure, you’d much rather work with SQL Server 2014, but what’s more prevalent out in the real world? At Dell DBA Days, I saw a chart that shocked me: SQL Server version popularity as of Sept 2015 That chart shows the number of servers running Dell Spotlight Essentials, a free SQL Server monitoring tool. Note…

Our new Triage Specialist will be using tools, forms, and methodologies that we build for our SQL Critical Care® clients, but we also make a lot of those tools available to the public for free in our First Responder Kit. Here’s how to do your own quick health assessment for free: First, start your health…

Since we’re hiring again, it’s a good time to explain what we do and how it’s evolved over the last four years. When your SQL Server’s performance or reliability is causing you business pain, and you can’t get the relief you want, you call us for a SQL Critical Care®. We use specialized tools we’ve built…

Must be Dell DBA Days: https://www.youtube.com/watch?v=Gn43sOLrcVs Join us live as we performance tune – and break – SQL Servers: Thursday Morning: Finding Your Slow SQL Server’s Bottlenecks in Record Time with Wait Stats Thursday Afternoon: How to Prove Hardware is the Problem Friday Morning: SQL Server High Availability, Disaster Recovery, and Licensing Explained Friday Afternoon:…