Posts by Brent Ozar

Brent Ozar

2787 posts

https://www.brentozar.com

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

When will you use SQL Server 2008 in production?

Last Updated October 23, 2009

Brent Ozar

The last several times I’ve spoken at user groups, I’ve asked for a show of hands to find out when people plan to put their first SQL Server 2008 instance in production. I ask because it helps me write better presentations – there’s no sense in me talking about something you don’t plan to use,…

Watch a former F1 driver drive his wife (crazy) around the track

Last Updated September 17, 2008

Brent Ozar

The below video records what happens when former F1 driver Riccardo Patrese drives his wife around a track in a Honda Civic Type R. Not a race car, mind you, just a street car with some special go-fast gear. Fast forward to two minutes in, when they’ve gotten off Pit Road. I had to laugh…

Spend a Day with the Experts – Oct 14 – Redmond, WA

Last Updated September 17, 2008

Brent Ozar

So you’ve been dying to meet me, but your job at Microsoft won’t allow you to leave the Redmond area? Or maybe you’re tired of hearing all those bright people at Microsoft speak, and you want to hear a rank amateur fill your head with gobbledygook? Or maybe you just want free breakfast and lunch?…

Steel Cage Blogmatch: How to Configure a SAN

Last Updated February 13, 2017

Brent Ozar

SQL Server, Storage

Jason Massie and Brent Ozar work with SQL Server for a living and write blogs for fun, but that’s where the similarities end. Jason’s a fan of shared storage SANs: putting SQL Server data and logs on the same set of physical hard drives. Brent’s a cheerleader for dedicated configurations where the arrays are separated…

The Glamour of International Travel

Last Updated September 4, 2008

Brent Ozar

Saturday It’s Labor Day weekend. I would love to hang out and relax, but I have a plane to catch. I pack my laptop bag and a single large suitcase. I’d love to take a carryon too, because it’d be a nightmare if my luggage didn’t arrive with me. I’m going to be checking the…

Surprise! I’m on the intrawebz!

Last Updated August 28, 2008

Brent Ozar

Me! I opened the company intranet this morning and got a surprise – I’m featured front and center. Looks like I’m going to have to change my browser’s home page for the next couple of weeks, because I can’t face this first thing in the morning without coffee. When I first started at Quest Software,…

SQL Server 2008’s new Central Management Server

Last Updated March 4, 2018

Brent Ozar

SQL Server

Got more than one DBA? Want to make your life easier? You might want to configure a Central Management Server. This is useful for fast-changing shops where there’s a lot of servers added and removed. At my last company, we had a hard enough time telling everybody when we’d finished adding a new server, or…

LiteSpeed v5.0 is out!

Last Updated September 5, 2009

Brent Ozar

Presto chango, version five. This one was in the oven long before I arrived at Quest back in May, and I’ve been using it for the last couple of months. Some of the big improvements are the ability to query backup files just like databases, the Backup Analyzer that automatically tests a bunch of compression…

SQL Server on a SAN: Dedicated or Shared Drives?

Last Updated January 17, 2019

Brent Ozar

SQL Server, Storage

A reader wrote in and asked: We’re running SQL Server with blades and a NetApp SAN. We have a few hundred databases from 100mb to 200gb. All data, logs, tempdb, etc. are located in the same 30-disk pool. Apparently this was setup using NetApp’s guidelines. NetApp recommendations are to put everything in one aggregate, or…

SQL P2V: What Really Killed the Dinosaurs

Last Updated February 13, 2017

Brent Ozar

Virtualization

Say we have a physical database server sitting over there in the rack. For the sake of discussion, let’s pretend it’s a slightly older model, a HP DL380 G2 with a couple of P3 CPUs, 4gb of ram, and six local 36gb drives. The storage is broken up into a mirrored pair of drives for…

Recommended Books for SQL Server DBAs and Developers

Last Updated February 14, 2017

Brent Ozar

Book Reviews, SQL Server

Here’s my favorite SQL Server books for 2016-2014: T-SQL Fundamentals – (updated for SQL 2016) – don’t be fooled by this “fundamentals” title, because everybody who writes T-SQL queries needs this book. It’s the manual we should have been given when we started, and everyone’s going to learn something about concurrency, performance, and updates here. T-SQL Querying…

Had a photo shoot by Tracy Manford

Last Updated August 13, 2008

Brent Ozar

I had a photo shoot yesterday by Tracy Manford to get some new head shots for presentations and whatnot, and I’m absolutely thrilled with how they came out. Hopefully you, dear reader, have never seen me before, because her photos make me look gooood. I’ll write more about this later (I’m on a short trip…

Microsoft DPM 2007 review

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery

I spent some time last week digging into Microsoft Data Protection Manager 2007, Microsoft’s solution for SQL Server backups, and I’m going to share some of my findings here with you, dear reader. “But You Work For Quest Software! You can’t write a Microsoft DPM review!” Yeah, disclaimer time – I work for the people…

SQL Server 2008 Release Date: Today.

Last Updated May 3, 2009

Brent Ozar

Microsoft SQL Server 2008 has been released, and the release date was Wednesday, August 6. Awesome – less than three years since SQL 2005, thereby meeting their goals and keeping the whole Software Assurance benefits worth the money. You can download it now if you’ve got an MSDN subscription – those are a great deal…

Change of travel plans

Last Updated November 1, 2009

Brent Ozar

This weekend, we changed our travel plans and headed back home to Houston instead of driving on out to California. We probably should have checked the maps a little more carefully – particularly this map: Tropical Storm Edaeiou(and sometimes y)rdo is heading right for Houston tomorrow. Both Ed and I have conflicting reservations at the…

Long live the DBA

Last Updated September 5, 2009

Brent Ozar

Jason Massie (aka StatisticsIO.com) wrote a blog post this week called The Death of the DBA. He talks about why the coming cloud computing craze creates career chaos. I have the exact opposite opinion: I can’t wait for databases to move toward the cloud because it makes database administrators even more vital. Reason #1: Cloud…

8 DBAs talk about their jobs

Last Updated February 12, 2017

Brent Ozar

Professional Development

OdinJobs.com interviewed eight different DBAs from completely different backgrounds and careers. The one thing we’ve got in common is that we blog, but outside of that, we’ve got wildly different points of view about the career and what we like about SQL Server. I shall now copy/paste Jason Massie’s hard work at listing each person’s…

SQL Server support on virtual servers

Last Updated February 13, 2017

Brent Ozar

Virtualization

The Microsoft knowledge base article on SQL Server virtualization support just got an update. Here’s the interesting part: “Versions of SQL Server after SQL Server 2005 will incorporate full support for running on a supported guest operating system that is installed on a Windows Server 2008 Hyper-V virtual machine.” That means SQL Server 2008 will…

Taking a cross-country road trip

Last Updated July 26, 2008

Brent Ozar

We’ve packed up the Honda and we’re heading out this morning on a road trip of epic proportions: Just over 5,000 miles. Erika, Ernie (our miniature Schnauzer) and I are driving from Houston to Memphis today, overnighting there. On Sunday we’re continuing up to Muskegon, Michigan to spend some time with Dad and Caryl, my…

Speaking at PASS Camp 2008 in Germany

Last Updated February 12, 2017

Brent Ozar

#SQLPass

I love my job! When a new version of SQL Server comes out, database administrators want to know what features will make an immediate difference in their lives. They want a very fast recap of what they need to do first, what they need to plan for, and what to tell the rest of their…