Posts by Brent Ozar

  1. Home
  2. Brent Ozar
  3. (Page 97)

SQL performance tuning: it’s about training too

1 Comment
When developers and SQL Server database administrators work together to make an app faster, it shouldn’t just be the DBA working alone in the dark.  If the DBA takes the slow code, goes into his cube, tweaks it (and indexes) and comes back out with a faster system, that fixes the problem once – but…
Read More

SQL Server 2008 new feature recap

1 Comment
Kevin Kline put together a great paper on the new features in SQL Server 2008 called “Worth the Wait: Why SQL Server 2008 is Great” and it’s a good read.  It’s the best DBA-focused paper I’ve seen on the topic.  People have asked me what’s coming, and this is probably the best handout to use…
Read More

Behind the times or ahead of the curve?

1 Comment
I have this strange personality quirk – I can’t decide whether I’m behind the times or ahead of the curve.  I found out about Dinner With The Band, an HDTV podcast where a music-savvy chef (Sam Mason) cooks for a band, and then they play a couple songs in his NYC apartment.  It’s a slick…
Read More

SQL Backup Software: Part 4 – Features Still Missing

Backup and Recovery
1 Comment
In this issue of my multi-part series about SQL Server backup compression software, I’m going to talk about some features that database administrators might find useful, but don’t yet exist in the current generation of backup software. In-Depth Backup & Restore Progress Monitoring On multi-terabyte data warehouses – especially those running new backup compression software…
Read More

What’s the Largest Database You’ve Worked With?

When hiring a production DBA, I start by asking them, “In terms of file size, what’s the largest database you’ve worked with?” In a perfect world, we’d only hire very experienced candidates, people who’ve worked with larger databases than we’re dealing with. In reality, though, we can’t always afford those candidates – if they’re even…
Read More

SQL 2008 release date pushed back

0
Remember all the hoopla when SQL 2005 came out? Microsoft swore we’d get more frequent releases because the 5-year lag after SQL 2000 meant it wasn’t worth paying for Software Assurance on SQL Server. They promised we’d get new stuff faster. Fast forward to today’s announcement: “Microsoft is excited to deliver a feature complete CTP…
Read More

Dell EMC AX150i review

Storage
15 Comments
Dell AX150i The iSCSI EMC AX150i is resold by Dell, and refurbished versions are available pretty inexpensively through the Dell Outlet. We just picked up our second AX150i with 12 500gb SATA drives for around $6,000 total, or about $1,000 per raw terabyte. It’s a great deal for lab or development storage, but there are…
Read More

Microsoft Technology Center: The DBA Experience

4 Comments
Our contacts at Microsoft offered us the services of a Microsoft Technology Center to do a two-week lab exercise on our data warehouse. We’d kept piling one application after another on our data warehouse SQL Server until the poor thing was plain out of maintenance windows and couldn’t keep up, and we needed info from…
Read More

At Microsoft’s Technology Center in Chicago

0
Carlos and I flew into Chicago midday yesterday, and a winter storm came in right after us. We’re at Microsoft’s Technology Center on Wacker drive, and our work area on the 23rd floor has a wall of windows with a great view of the city.  We watched the sky get darker in the afternoon as…
Read More

SQL Performance Tuning: Estimating Percentage Improvements

1 Comment
When I’m doing performance tuning on an application in the early stages of its lifecycle (or any app that’s never had DBA attention before), I end up with a ton of recommendations within the first day of performance tuning.  The resulting to-do list can seem overwhelming to project managers and developers, so I include one…
Read More

Sunday Buffet at The Lady & Sons

2 Comments
As part of our road trip this week to Oklahoma City, we stopped at Paula Deen’s The Lady and Sons in Savannah. For those of you unfamiliar with The Food Network, Paula Deen and her two sons are food celebrities, great people with a great story. The restaurant doesn’t take advance reservations: instead, hopeful diners…
Read More

PASS Summit 2007: Day Three Notes

#SQLPass
2 Comments
Bill Baker: Keynote on Office PerformancePoint 2007 Bill’s a fantastic speaker, and this is an interesting product, but our organization’s BI isn’t mature enough to take on this product yet. The product has a lot of potential; in a nutshell, it combines the flexibility and agility of Excel with the data safety & consistency of…
Read More

PASS Summit 2007: Day Two Notes

#SQLPass
4 Comments
Tom Casey: Keynote Tom covered basic SQL Server marketing slides about the BI stack. Yawn. Good presenter, but couldn’t overcome the dry material. Then he handed it off to a Dell woman to announce that they’ll be selling packaged BI solutions with hardware, software, storage, etc all in one bundle. They’re targeting customers in the…
Read More

PASS Summit 2007: Day One Notes

#SQLPass
2 Comments
My notes on the sessions I’ve attended so far: Ted Kummert: Keynote on SQL 2008 I’d already seen most of this PowerPoint deck during a South Florida SQL meeting at Microsoft, but the demos kicked butt.  Finally, we have Intellisense in Management Studio!  Woohoo!  There was other fun stuff, but I’ve already forgotten it. One…
Read More

In Denver for SQLpass 2007 Summit

#SQLPass
0
I splurged and forked over $180 for a first class upgrade for my flight from Miami to Denver. It’s been years since I’ve flown, and it was scheduled to be a four hour flight, so it seemed like a good – albeit decadent – option. Turned out to be a lucky gamble: the plane was…
Read More
Menu