Posts by Brent Ozar

Getting Ready for GDPR Compliance

1 Comment
By now, you’ve probably heard of the EU’s General Data Protection Regulation (GDPR). It’s a hugely far-reaching set of regulations, but here’s a very abridged background: If your business holds data for EU citizens or residents – regardless of where your business is located – you’re affected When EU folks are handing over their data,…
Read More

What to Do When SQL Server is Unusually Slow

Target Audience: You use Activity Monitor to figure out what’s going on, and you feel like you might be missing something. Abstract: “Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it…
Read More

Getting Better Query Plans by Improving SQL’s Estimates

Target Audience: You want faster queries, and you’re starting to read execution plans to figure out what to do. Abstract: You’ve been writing T-SQL queries for a few years now, and when you have performance issues, you’ve been updating stats and using OPTION (RECOMPILE). It’s served you well, but every now and then, you hit…
Read More