Brent Ozar Unlimited's specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable.
Visit brentozar.com → RSS feedOn Hacker News Nov 2011 – May 2025
Databases & Data 5Tech Industry & Business 3Systems & Performance 1Software Engineering 1
Hi. I’m a former developer who’s moved into database administration, and here’s what I wish somebody would have told me when I got started. 7. SQL functions rarely perform well. Good developers like to reuse code by putting it into functions, and then calling those functions from multiple places. That’s a great…
Bad news: that page is gone. We try to keep our site as accurate and up-to-date as possible so that if you’re reading advice here, you can rely on it. That means from time to time, we decide that a page isn’t a great reference anymore, and the work to update it is beyond what […]
The best new features in SQL Server 2014 probably won't come with the cheap prices or licensing. Learn why the release date will probably be an expensive one.
Update 2025/07/21: Microsoft heard the complaints, and fixed the reliability added a better status page. Baby steps. Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about it? Let’s talk about why. First, Fabric’s status page is fabricated bullshit. The link…
Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes, formerly of Microsoft (LinkedIn) – was working on measuring database performance. His team wrote a benchmark, ran it against Oracle, and Oracle didn’t fare well in the results. Oracle reacted as one would expect – they were…