Product has been added to your cart.

Posts by Brent Ozar

Brent Ozar
2446 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.
I'll pull in close to the island so they can see me fail.

DBA Darwin Awards: Log File Edition

Brent Ozar
Right after the DBA says “Uh oh,” they call in the consultants.  We get to see some really amazing acts of career suicide. DBSEASEA SINK You wouldn’t believe some of the stuff we’ve seen, and some of these things are probably happening in your environment right now.  In this session, we’ll talk about some of…
Read More

The Art of the Execution Plan

Brent Ozar
Execution Plans
25 Comments
There’s beauty everywhere – even in SQL Server.  I was just staring at this plan when I was struck by its beauty: Stored Procedure Part 1 Oh, sure, it’s ugly, and I recoiled in horror at first, but when you get over that reaction, there’s an amazing amount of stuff there.  Someone – probably many…
Read More
From a trip to DC

What 2012 Work Scares You?

Brent Ozar
Professional Development
94 Comments
Right now, this very moment, there’s an ugly piece of work tapping on your shoulder – and I don’t mean your boss. Or bacon. Bacon works too. You agreed to do it months ago during the 2012 planning sessions, but you never really expected January 2012 to arrive.  Now that it’s here, you’re starting to…
Read More

sp_Blitz® Updated to v5

Brent Ozar
SQL Server
6 Comments
Happy holidays! Santa SQL comes bringing tidings of cheer with a new sp_Blitz® – but also doom and gloom about configuration problems in your servers.  Here’s some of the recent contributions from readers: John Miner suggested tweaking checkid 48 and 56, the untrusted constraints and keys, to look for is_not_for_replication = 0 too.  This filters…
Read More

Consulting Lines: SQL Server Needs a Dog

Brent Ozar
Consulting Lines
29 Comments
SQL Server isn’t lonely, but it needs a dog.  In today’s Consulting Lines series post, I’ll share my very favorite consulting line of all – one that makes people laugh while illustrating a point. The Situation: Bob the Button Basher My Blitz script helps me quickly spot SQL Server settings that have been changed from…
Read More
For the record, he didn't really trust the Soviets either.

Read-Only View Permissions and Roles in VMware vSphere

Brent Ozar
SQL Server, Virtualization
11 Comments
When Ronald Reagan said, “Trust, but verify,” he was talking about DBAs working with their VMware sysadmins. "Trust, but verify." Ronald Reagan As a consultant, I get to see a lot of SQL Server implementations – both successes and failures.  The successes have one thing in common: transparency.  The database administrators, VMware admins, and storage…
Read More

SQL Server App Store Reviews

Brent Ozar
Humor
21 Comments
If SQL Server cost $4.99 in the App Store, what would the reviews look like? Not as good as the Access app – ** By B. Analyst, December 6, 2011 I don’t understand what all the fuss is about.  The GUI in this app sucks.  It’s hard to build reports, and it’s overpriced.  $4.99?!? Save…
Read More

Brent’s 2012 Conference Schedule

Brent Ozar
#SQLPass
5 Comments
I feel like the luckiest guy in the world: I get to take part in six major SQL Server events in 2012.  Here’s where I’m going and why: January 26-Feb 4: SQLCruise Miami SQLCruise is the highlight of my year.  This year, we’ve transitioned SQLCruise completely to Tim Ford – he owns the event start…
Read More

3 SQL Server Book Review Short Takes

Brent Ozar
Book Reviews
13 Comments
Here’s what I’ve been reading lately on the SQL Server front.  I’d like to thank all three authors and publishers for providing these books for review. Securing SQL Server by Denny Cherry Paperback – Kindle Denny’s a jack of all trades, and a Microsoft Certified Master of SQL Server to boot.  I’ve had the pleasure…
Read More

Virtualization and SAN Basics for DBAs Video

Brent Ozar
SQL Server
4 Comments
These two technologies can make a very big — and very bad — difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and…
Read More

What People are Finding with sp_Blitz®

Brent Ozar
SQL Server
4 Comments
My new sp_Blitz® stored procedure helps you take over SQL Servers, identify risks, and build an inventory of what needs to be fixed.  Here’s the video from our Tech Tuesday Triage webcast series this week when I explained how to use it: https://www.youtube.com/watch?v=OUdIe_eLpco In the sp_Blitz® output, I include a link to learn more about…
Read More
Submit Your Feedback and Vote

Interview with #SQLPASS Presidents Rushabh Mehta and Bill Graziano

Brent Ozar
#SQLPass
5 Comments
PASS takes bloggers seriously. This is the third year I’ve been offered press-style sit-down interviews with members of the PASS Board of Directors. On Friday, outgoing President Rushabh Mehta (@RushabhMehta), upcoming President Bill Graziano (@BillGraziano), and PASS Marketing’s Alison MacDonald talked with me for over an hour about PASS, the Summit, finances, membership, web sites,…
Read More
Bill Graziano Supporting #SQLKilt Day

PASS Summit 2011 Day 2 Keynote Liveblog #sqlpass

Brent Ozar
#SQLPass
2 Comments
Time for another keynote liveblog.  Let’s get started. It’s #SQLKilt day!  Bill Griaziano is kicking things off in a kilt: Bill Graziano Supporting #SQLKilt Day 8:19am – Bill introducing Tim Radney and Jack Corbett as outstanding volunteers. 8:22 – Lori Edwards is the 2011 PASSion award for her outstanding work making this such a great…
Read More