Posts by Brent Ozar

What Amazon RDS for SQL Server Users Need to Know about Multi-AZ Mirroring

Amazon Relational Database Service (RDS) now supports multi-availability-zone SQL Servers. This means you can have a primary database in one data center, and a secondary replica in another data center. Those Portland folks were always a little bit backwards anyway. When your primary server goes down, OR when the entire AZ goes down, you can fail…
Read More

Tiering kCura Relativity Databases (Or Any SaaS Product)

When you’re the database administrator working with a software product that stores every client’s data in a different database, the sheer number of databases can be intimidating. As you grow from dozens to hundreds to thousands of databases, you can’t treat all of them equally. Start by making a graph of the database sizes –…
Read More

Microsoft Cloud Rebranded as Microsoft Pale Blue

SQL Server
15 Comments
It’s time to learn another new set of acronyms. Effective today, Microsoft’s as-a-service brand is changing names again. As recently as last week, the product’s name had been changed from Windows Azure to Microsoft Azure, but industry observers noted that Microsoft’s web pages actually referred to a different name – Microsoft Cloud. “Our research found that the…
Read More

How to Add Nonclustered Indexes to Clustered Columnstore Indexes

SQL Server 2012 introduced nonclustered columnstore indexes, but I never saw them used in the wild simply because once created, they made the underlying table read-only. Not a lot of folks like read-only tables. (Bad news, by the way – that limitation hasn’t disappeared in 2014.) SQL Server 2014 brings clustered columnstore indexes, and they’re…
Read More

After You’ve Been a DBA, What Do You Do?

You’ve been managing database servers for a few years. Now what? Get more technical – every time a new project comes in, sharpen your skills. Get more involved in failover clustering, storage, virtualization, or the cloud. Write technical presentations to teach your own company’s staff, and then the public. Business intelligence – if you’re constantly…
Read More

When Do You Fire the DBA?

SQL Server
16 Comments
I know a lot of DBAs, but it’s really, really rare that I’ve seen one get fired. I don’t think it’s ever happened during one of my consulting engagements, and I’ve seen some incredibly horrific database disasters (not to mention a whole lotta ugly near-misses). So I asked Twitter: Thinking about a blog post. When…
Read More

The Worst Database User

SQL Server
30 Comments
“Can you tell me a little about this code?” I asked, keeping my best poker face on. “I’m really proud of it. It gathers a whole bunch of stuff from accounting, human resources, manufacturing, you name it. I want to be able to track how we’re doing over time.” He nearly hovered in his chair…
Read More

San Diego Class Recap

SQL Server
2 Comments
We had a lot of fun this month teaching SQL Server classes at the San Diego Harbor Hilton. (We wrote about how we picked the cities earlier.) Even when we teach, we learn, and then we share what we learned, so here we are. San Diego Harbor Hilton We like to try new things with our…
Read More

What If You Knew The Server Would Crash Today?

SQL Server
7 Comments
This morning you woke up with a terrible premonition – you were absolutely sure your most important production database server was going to crash today. What would you do? Step 0: stop for coffee, because it’s gonna be a long day. Here’s a quick list of places to start: Identify where the most recent backups…
Read More

Satya Slips a SQL Server Standard Secret?

SQL Server
3 Comments
Everybody wants to know the next SQL Server release date, pricing, and feature lists, but anybody who knows those facts is bound by non-disclosure agreement and can’t say it publicly. Every now and then, though, we get lucky and someone from Microsoft slips up. That’s why I pay particular attention to Microsoft interviews as we…
Read More

What Do You Ask the Leaving DBA?

SQL Server
9 Comments
The last DBA had an unfortunate accident in Alaska. When the database administrator turns in her notice, what questions should you ask her in her last couple of weeks? I’m assuming, of course, that it was a friendly departure and you’ve got the full two weeks to have good conversations. Or maybe the DBA is…
Read More

Watch Brent Tune Queries

SQL Server, Videos
17 Comments
Ever wonder how someone else does it? There’s no right way or wrong way, but in this 20-minute session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results. For the links and scripts, check…
Read More