They’ve become too easy. It’s too easy to just dump any kind of data in there. It’s too easy to query the database rather than cache data for a period of time in the app. It’s too easy to join all the tables together rather than pick just the tables you need. It’s too easy to write spectacularly, horrifically bad queries. It’s too easy to copy/paste bad designs from the web that have gradually gained good SEO over time. It’s too easy to install them and go live on really crappy hardware. It’s too easy to scale for the first couple…Read
The Price is Right Arrange this list of things in order based on how much they cost: SQL Server Standard Ed. licensing for four cores SQL Server Enterprise Ed. licensing for one core One typical day of employee time One week of a team’s time (4 people) 64GB of memory 256GB of memory A mirrored pair of 1TB SSDs Without searching the web for prices, put those items in order. Do it on a scratch piece of paper – first estimate how much you think each one costs, then put them in order. How does this impact the way you do performance tuning, and…Read
Slow and cheap, right? Managers and DBAs usually want the development server to be just slow enough to get the job done, and no faster. The dev server doesn’t have production load on it – you’re just working by yourself. If you can’t make your code fast when you’re the only person working in the server, then it’ll never scale in production with hundreds or thousands of simultaneous users. Wrong – the development server should be faster than production. Ideally, the whole database should fit in memory, and we should be using solid state drives. Amazon’s running a huge >30%…Read
Hi. I’m Brent.
I live in California with my wife Erika. I'm on an epic life quest to have fun and make a difference.
I co-founded Brent Ozar Unlimited to help make your SQL Server go faster. I also maintain sp_Blitz® and the open source First Responder Kit repo.