Posts by Brent Ozar
July 2009 PowerShell Poll
The Ozar Family Tradition of Performance Monitoring
When my Grandpa Ozar wanted to find out if his 10 megabyte 5.25″ hard drive was responding fast enough to handle his database loads, he monitored the Perfmon counter Physical Disk: Disk Queue Length.
Things have changed since Grandpa’s time, though, and now it’s time to learn a new performance tuning trick – SQL Server waits.
Why Your Servers Need a Physical
Two DBAs Walk Into a Bar
Nice Overalls You Got There
SQL Azure Pricing: $10 for 1GB, $100 for 10GB
Why Excel in the Browser Matters to DBAs
What I Want Versus What I Can Afford
Why do some interviewers insist on asking ridiculously impossible questions when they’re interviewing the most junior candidates? I explain why you should use questions people can actually answer, and quit trying to hit the lotto.
Happy Birthday to @SQLBelle
Stunt Car Drivers, Eggs Benedict, and You
SQL Server Index Tuning Tip: Identify Overlaps
Sometimes less is more – and indexes are definitely one of those times. Learn how to identify overlapping indexes and why they’re so bad for performance, and learn about SQL Server 2005’s new INCLUDE feature.