HNHacker News
TopNewBestAskShowJobs

BrentOzar

3,765 karma · joined May 21, 2011

I make databases go faster. I love teaching, travel, cars, and laughing. Las Vegas. He/him, pan. Email: Brento at BrentOzar.com.
submissionscomments
BrentOzar··on So thieves broke into your storage unit again
> How to with rental cars?

Some credit cards like American Express offer their own insurance as part of the membership fee as long as you pay for the rental with their card, and decline the coverage offered by the rental car company.

BrentOzar··on Synthetic diamonds are now purer, more beautiful, and cheaper than mined
> If I buy a good loose lab grown diamond will I be able to find someone who will fit it into a high quality gold ring?

Yes, and even better, don't design the ring by yourself. Get a nice jewelry box for the diamond, use it for the proposal, and when you open the box, say:

"Our relationship is something we're going to build together. I want your opinion on everything for the rest of my life, because you're going to be my partner. I got the diamond, but let's design the ring together, you and I, because this is too important for me to do by myself. I need your help."

They'll melt, and the ring will mean even more.

BrentOzar··on Ask HN: What is in C-00000291*.sys?
> Crowdstrike is finished

Unlikely, just as Solarwinds wasn't finished when they distributed malware that got government agencies hacked. You underestimate the slow turning radius of giant company purchasing departments.

BrentOzar··on Finding New Pastures: Big Nerd Ranch's Next Chapter
To anyone considering writing for Pakt, you owe it to yourself to read any random 5 of their books, and then consider whether you want your name to be attached to that reputation.

The books really are that bad. I think less of someone when I know they've written a book for Pakt.

BrentOzar··on Show HN: PostgreSQL index advisor
Read that link carefully: only automatic plan regression is available in SQL Server, not the automatic index tuning portion. The index tuning portion only applies to Azure SQL DB.
BrentOzar··on Show HN: PostgreSQL index advisor
Source? I’ve been working with SQL Server for a couple of decades and I don’t believe it will automatically create or drop indexes under any circumstances. You might be thinking of Azure SQL DB.
BrentOzar··on Nearly all of California's reservoir's are above their historical averages
> Is a nuke particularly expensive or something? Google tells me they are less than a billion dollars each.

Yeah but that's from Shein, and you don't wanna buy your nukes from a company that uses child labor and unsustainable materials.

BrentOzar··on [dead]
"Bootstrapped" from a super-cushy Manhattan office building, heh.
BrentOzar··on For Car Thieves, Toronto Is a 'Candy Store,' and Drivers Are Fed Up
I had to laugh at the photos of "high end luxury vehicles" - Subarus.
BrentOzar··on For Car Thieves, Toronto Is a 'Candy Store,' and Drivers Are Fed Up
> What happened to the shipping container? Who owned the rural property? Where was the shipping container going?

Everyone's going to feign ignorance. The container owner will say they didn't realize the container had been stolen from their property, or they rented it to someone who's responsible for whatever they do with it.

The property owner will say they didn't give anyone permission to put a container there, or that they rented it to someone else.

The destination can be just a port, and a moving company can be hired to pick up the container from the port.

(Source: my spouse shipped a lot of stuff from China, and I was horrified at how little security and documentation was involved. I can see how cars cross borders so easily.)

BrentOzar··on Readyset: A MySQL and Postgres wire-compatible caching layer
> I wonder why the caching layer can't just pass any query it is unable to process on to the underlying database?

Because sometimes it's not about the query you pass in - it's about a new data type, for example. The layer may think it understands the query, but may not be able to handle the format of the results, or may cache them incorrectly.

For example, when SQL Server added the JSON data type, one of my customers found that the caching layer mangled it for some clients, but not others, or would return the correct result the first time, but the cached result was formatted incorrectly.

Another problem can be the connection itself, like when SQL Server added support for Always Encrypted, an end-to-end encryption method.

BrentOzar··on Readyset: A MySQL and Postgres wire-compatible caching layer
In the Microsoft SQL Server space, several of these vendors have come and gone. My clients have been burned badly by 'em, so a few quick lessons learned:

Be aware that there are hundreds of open issues[0] and dozens of pull requests [1], some of which involve clients being unable to connect or not supporting all components of the SQL language. Just because your database supports something, doesn't mean your caching layer will.

It gets really ugly when a new version of your database comes out, with brand new features and language enhancements, and the caching layer doesn't support it. It may take months, or in some cases years, before the caching layer is feature-complete with the underlying database. If you want to use some of those language enhancements, then your app may have to maintain two connection strings - one for the caching layer, and one for direct database queries that the caching layer doesn't support.

Your support teams need to learn how to diagnose problems with the caching layer. For example, this issue [2] talks about the level of work involved with understanding why newly inserted data isn't showing up in selects.

I hope they succeed and deliver the concept, because it's one of the holy grails of databases.

[0]: https://github.com/readysettech/readyset/issues [1]: https://github.com/readysettech/readyset/pulls [2]: https://github.com/readysettech/readyset/issues/39

BrentOzar··on Adaptive Cards: Platform-agnostic snippets of UI, authored in JSON
> No macOS or Linux support...

Nothing in the Github feature roadmap for either one, either.

BrentOzar··on The web will be Vision Pro's killer app
Just like it was for the first iPhone.
BrentOzar··on Who makes the most reliable new cars?
> it was a pretty unanimous "Toyota wins."

Part of the reason is that Toyota uses really conservative, classic engineering. They sell things that have worked well for decades, and they're hesitant to introduce new features.

That's also why their infotainment systems are notoriously terrible and they lagged years behind everyone else on selling electric cars. Gotta take the good with the bad.

BrentOzar··on BMW, Subaru and Porsche drivers 'more likely to cause a crash', study finds
> However I got pulled over by the police for speeding about quarterly in the BMW, and have not been pulled over a single time in more than five years in my new car.

In car fan circles, this is called a “sleeper” - a car whose boring design and boring color doesn’t draw attention from police. That’s not a negative at all - it’s great! Car fans often buy sleepers on purpose.

Historical sleeper examples include the Ford Taurus SHO, Chevy SS sedan, and Audi S6. I had a 2003 Audi RS6, a notorious sleeper. Looked totally plain, but could absolutely fly, and I never got a ticket in it despite some truly hair raising speeds.

BrentOzar··on DoorDash manages high-availability CockroachDB clusters at scale
I’m not excusing the wild number, but just tossing out some additional load: * Drivers checking in for work, especially if the apps poll automatically * Drivers phoning home with live location updates * Restaurants sending automated updates on order status * Push notifications to users with status changes on their orders * Users with multiple devices (like I have at least 5 devices with the UberEats app)
BrentOzar··on Sam Bankman-Fried Set to Testify at His Fraud Trial
> I don't think this will go well for him.

It can’t go a whole lot worse than how the current trial is going, and that’s his gamble.

BrentOzar··on iPhone 15’s shift to USB-C
If Apple wanted to make the iPhone a computer replacement, and all that was holding them back was USB-C, they would have added it in a long time ago.

They didn’t. They waited until the EU made them switch to USB-C.

BrentOzar··on Common Pitfalls in Database Performance Testing (2018) [pdf]
> I also realized that storage's performance had very little to do with the benchmark's scores as in order to game the benchmark one would simply add more memory.

Reminds me of the time [1] Fusion-IO showed how good their drives were for SQL Server by running benchmarks with just 16GB of RAM enabled, even though the servers had 384GB RAM.

Under direct questioning, they admitted that if you just used the rest of the RAM in the server, their drives didn't have any effect, and that's why they limited the server so badly for the presentation. (sigh)

[1] https://ozar.me/2014/06/fact-checking-24-hours-of-pass/

BrentOzar··on Dara Khosrowshahi had a stint driving for Uber and delivering for Uber Eats
> If driving for Uber instead caused you to have 500,000 miles on it

Try to find a 2010 Prius with over 300,000 miles. There are only a handful in the US because they fall apart long before 500,000 miles.

Depreciation isn't just about the car's value - it's also about the amount of mechanical work you have to put in for the suspension, tires, brakes, etc during the time that it goes from 150,000 miles to 500,000 miles.

My mom's 2010-era Prius is a good example. The dash displays failed at around 100,000 miles, and she bought a new car rather than pay $2,500 to have the dash pulled out and display replaced.

BrentOzar··on Grindr Loses Almost Half Its Staff on 2-Day RTO Requirement
> And why did they resign and not wait to get fired? Is that a us thing?

Got jobs elsewhere, started consulting, etc.

BrentOzar··on File Attachments: Databases can now store files and images
> Just with SQL Server alone, for decades now you can store BLOB data.

Yes, and for decades, it's been a bad idea for SQL Servers that grow over time.

When you store files in the database, you massively inflate the size of the data file and the transaction log. It makes all your maintenance tasks take longer: backups, restores, high availability, disaster recovery, corruption checking.

To make matters worse, when a new version of the file arrives, people never overwrite the existing file - they store the new version as a new row or object, and keep the old version around too. Space requirements explode exponentially.

If you're dealing with a 10-100GB database, sure, it seems fine at first. But after you start storing files in there, you won't have a 10-100GB database - you'll have a terabyte-sized one, and that's when your maintenance task heartaches begin.

BrentOzar··on The WordPress 100 Year Plan
> So you believe that your website made today will still be a good marketing tool 100 years from now?

No, the business will be closed. It would just serve as an archive of history.

BrentOzar··on The WordPress 100 Year Plan
There's a perfect use case for this: if you think your company stands a chance of running out of money in the future, but you just got an infusion of VC funding now... $38K isn't a large amount.

$38K is an insurance policy that will keep the marketing front end of your company's site online "forever", long after you run out of VC money and shutter the company. Keeps your vanity up and running, your fond memories.

It turns your hosting costs from a monthly expense to a "permanent" capital expense that's already paid for.

BrentOzar··on The WordPress 100 Year Plan
> $31.66 a month for a wordpress hosting plan is an absolute rip-off.

Today, maybe. For the human costs of hosting support in 2123, given the cost of inflation, it might not be, and these plans include technical support.

(Although you could also that the technical support work on most of these 100-year plans should be dropping over time too - especially if the human being involved passes away. You could even argue that AI might be doing the technical support in 2123.)

BrentOzar··on The Never Ending Now
> From the back row, I watched my friends scroll their social media feeds with ferocious intensity.

Meh, groups taking short rides in long SUVs like he talks about here, that's a good time to catch up on social media before everyone's face to face again.

Sustaining group conversations in a long multi-row SUV is painful. Get your social media stuff done briefly, then when you get out of the car, go back to interacting in person. This is fine.

BrentOzar··on The 2002 Überlingen midair collision
> the calm demeanor shown by both ATC and pilots

My ex-wife was a US air traffic controller, and the training they go through is stunning. They're tested continuously for years, with something like an 80% wash-out rate.

During testing, they get 1-2 tests per week, working a shift just like a controller would, with fake pilots on the radio, and real computer systems. If they let airplanes get even remotely close to each other, they fail. If it happens twice, they're out of the FAA, immediately, permanently. One of the instructors told me, "It's my job to make sure your wife has the worst week of her career, every week, during training - so that when she's actually on the job, every week will seem easy no matter what she's facing."

Even just in training, you could see the stress take its toll on the candidates over the years.

BrentOzar··on Aurora I/O optimized config saved 90% DB cost
Cut ours by over 40% too: https://www.brentozar.com/archive/2023/06/aws-aurora-cut-our...
BrentOzar··on Aeroflot deactivates brakes on nine aircraft, relies solely on reverse thrust
> Technician busts out the ODB code-reader

I assume you mean OBD (on board diagnostics), not Ol Dirty B*stard, who has a very different set of codes.

← PreviousPage 2 of 16Next →