HNHacker News
TopNewBestAskShowJobs

BrentOzar

3,773 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 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.

BrentOzar··on Stack Overflow's CEO Doesn't Understand Stack Overflow
> What will improve SO is if you had an AI that could downvote bad answers and questions and especially find duplicates

Yes, because if there's one thing Stack Overflow needed, it was more negativity. /s

BrentOzar··on Stable Diffusion XL 1.0
With an RTX 4090, you can crank out several images per minute, even at high resolutions.
BrentOzar··on PRQL: Pipelined Relational Query Language
This feels way less intuitive than SQL:

UPDATE counters SET value = value + 1 WHERE name LIKE 'prefix.%'

BrentOzar··on Human-powered air-compressor and energy storage system
Racing code - America's Cup races prohibit stored energy aboard the boat, for example. Exceptions are made for certain springs, valves, and batteries for electronics.
BrentOzar··on The away team model at Amazon (2022)
> I heard Microsoft has a similar team to go out and fix a customer's software.

About 20 years ago, they were called Rangers, modeled after the Army Rangers, soldiers who could venture out into enemy territory with no support and accomplish missions out there.

About 15 years ago, the program evolved into Microsoft Certified Masters, and it included both internal staff and specialized outside consultants. (I was one of about 200 MCMs worldwide for SQL Server.)

BrentOzar··on Submarine missing near Titanic used a $30 Logitech gamepad for steering
> don't they do this with crab pots? i'm not sure how far those go down though.

Looks like at most, about half a mile: https://en.wikipedia.org/wiki/Alaskan_king_crab_fishing#Equi...

BrentOzar··on Database Gyms [pdf]
> so I wanted to send a friendly thank you.

Awww, thanks! That's awesome to hear! My big goal is to make other peoples' journeys through data easier.

BrentOzar··on Database Gyms [pdf]
tl;dr - paper by Andy Pavlo's team. Conclusion:

> Most of the previous work in using ML for DBMS automation has focused on designing better ML models of DBMS behavior, but recent advances in ML have largely automated model design. The challenge now is to obtain good training data for building these models. This paper outlined the architecture of the database gym, an integrated environment that generates training data by using the DBMS to simulate itself at the highest possible fidelity.

BrentOzar··on Stack Overflow Is Down
> you can download StackOverflow for offline use

Probably not for long. They've already discontinued the public data dump: https://meta.stackexchange.com/questions/389922/june-2023-da...

BrentOzar··on Why PostgreSQL High Availability Matters and How to Achieve It
Or, uh, just use AWS RDS Aurora.
BrentOzar··on All About Skimmers
Needs "2016" in the title.

Past discussion: https://news.ycombinator.com/item?id=8327676

BrentOzar··on Juice’s RIME antenna successfully unjammed
The title sounds bad, like the antenna broke off, but the article explains that the antenna was stuck in its folded position, and they got it to break free and deploy into the correct position.
BrentOzar··on I Built Bang with Friends, “The Evilest App Ever”
I laughed more at this piece than I've laughed at some comedians, which makes me think that some of his success is due to sheer charisma and chutzpah. Still... I'd have invested.
BrentOzar··on Lyft CEO David Risher reportedly says company is 'open' to acquisition offers
> Not in Las Vegas, cabs still reign. Sure you can call an uber/lift and wait ten to 15 minutes or hop in a cab that's already there and be on your way.

Only at strip casinos and the airport. If you're the slightest bit off-strip, Uber/Lyft is dominant. (Source: I live in Henderson, and use Uber constantly.)

BrentOzar··on Memoirs from the old web: IE's crazy content rating system
Well, compared to the killing of the dog...
BrentOzar··on AWA's Acoustic Hood – Effective Silencing for Office Printers
> to mute the noise of the blenders.

They also contain the mess when an employee doesn’t get the juicer lid on quite right.

BrentOzar··on Ask HN: How do I make Apple pay up?
You're assuming your peers will agree with you. I'm gently suggesting that they may not, and you need that check.

You might be right. It might be the next Meltdown vulnerability. But it might not, and Apple already told you it isn't, and that's why you need to talk to your peers.

BrentOzar··on Ask HN: How do I make Apple pay up?
> How does Apple establish "prior art" if I go public with it?

You're not going public with the HOW, only the effects. Reread my comment about asking your trusted peers, please.

BrentOzar··on Ask HN: How do I make Apple pay up?
Talk to a few of your trusted peers about the effect (not the mechanics) of the vulnerability.

As in, "If you hand me your iPhone, I can unlock it without knowing your password." Don't tell them how, just describe in 1 sentence what access you need, and what you're able to do. If your trusted peers (not drinking buddies who do other jobs) are impressed, then widen the circle a little - tell strangers (like HN readers) that same thing, and ask if it's a vulnerability.

It'll just help you have a sanity check about whether or not it's actually a vulnerability that Apple needs to fix, or perhaps it's someone else's, or not really that big of a deal.

BrentOzar··on Offline is just online with extreme latency
> You cannot tell the customer "you might have (or might not have) bought the house, we will only know later".

Sure you can - in fact, that's what realtors call offers. You place an offer, and you only find out later if you bought the house, often days later.

BrentOzar··on The EV Transition Is Harder Than Anyone Thinks
We're not in Poland. Like I said in the post, I'm in the Nevada desert, in a 400 sq meter house, with a pool and a hot tub.

Here's a weather comparison to remind you that year-round, the highs in Krakow are lower than the LOWS in Vegas: https://weatherspark.com/compare/y/85104~2228/Comparison-of-...

BrentOzar··on The EV Transition Is Harder Than Anyone Thinks
That's the problem - the city's inspection assumes full load from each of the appliances, plus some.
BrentOzar··on The EV Transition Is Harder Than Anyone Thinks
I'm in the midst of trying to get an electric car charger installed in my garage. Don't shoot the messenger.

I live in Las Vegas, in a 25-year-old subdivision. The homes' 200-amp panels don't have enough spare capacity to add a charger. (3 old less-efficient HVAC units, pool pumps, hot tub, electric oven, clothes dryer, etc.)

So to add a charger, I have to get my home's service raised to 400 amps. That wouldn't be a big deal, except... the neighborhood's transformers are already over capacity, too. A few of the homes already added 400-amp service so they could add Tesla chargers, and there's no capacity left in the neighborhood.

Nevada Energy is willing to add a new transformer in the neighborhood - but they want to charge me $20,000, plus the costs of trenching the new 400-amp line from the transformer to my house, plus the new panel, plus the charger. It's looking like a $40,000 installation.

Or... I could just put solar on the roof, build a separate isolated 200-amp panel powered by solar, and charge the car from that. (Plus move over the pool pumps, hot tub, etc while I'm at it.) That isn't free, either, but at least it'd cut my electric bills long term instead of adding to 'em.

I don't know how many homes & neighborhoods are in this situation, but I was surprised that a 25-year old neighborhood is having this problem.

BrentOzar··on Iceland long term visa for remote workers
Late to the comments here, but I was literally the first guy to use this program when Iceland unveiled it in 2021. I moved there in January 2021, and lived there for 9 months. I was interviewed by the NY Times and NBC about it.

I wrote about my experiences here: https://ozar.me/tag/iceland/

I see a lot of people saying Iceland is expensive - well, if you're coming from California, it's not that bad. I'd say it's comparable, aside from the gas/diesel prices.

If you have any questions about the process or living in Iceland, I'd be glad to help. Email's on my profile.

BrentOzar··on Indeed cuts 15% of workforce, 2200 jobs
> I take sole accountability for where we are today. I am deeply and profoundly sorry. I will be taking a 25% cut in base pay. Additionally, more than 75% of my total compensation is directly tied to Indeed revenue growth, and is at risk given current trends.

That’s how you tell people you’re accountable.

BrentOzar··on Intel graphics chief Raja Koduri leaves after five years battling Nvidia and AMD
> Does it show strong potential after so little time?

(Checks watch) Uh... Intel has been working on graphics for over twenty-five years. https://en.wikipedia.org/wiki/List_of_Intel_graphics_process...

It seems like every 5 years, they say, "This is it, we're gonna be competitive this time," and ... they never are. Not even close.

← PreviousPage 3 of 16Next →