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 Twitter Blue breaks EU consumer law by showing prices without tax
> can sell with fixed pricing for whole EU and cut my profit dynamically depending on user's country VAT

Technically, yes - some selling platforms like Teachable give you that option. You (they) still have to break out the correct VAT on the inside and receipt to the customer, but this approach just lets you delay calculating VAT until after they've put in their country during the checkout process, while still keeping the same apparent price to the end user.

BrentOzar··on A short history of the VW Mark 1 Rabbit/Golf (2021)
Mom had one while I was growing up, and even then, I was horrified at the noise, vibration, and harshness compared to the gas equivalent model. The Rabbit Diesel is very loud, and in an unpleasant, clattering way.

It's amazing how far diesels have come. I have a Range Rover diesel, and even most car fans don't realize it's a diesel until I mention it.

BrentOzar··on Ask HN: What has your personal website/blog done for you?
Mine started as a personal blog, and now generates $2M USD/year revenue of training, consulting, and online services.

I regularly preach the gospel of, "Find the most expensive thing in your business, stand next to that, offer to help fix it when it breaks, and blog about what you've learned."

For me, that was Microsoft SQL Server, but the specific tech doesn't matter. Follow the money.

BrentOzar··on New AI Music Generator Made for Creators
"What happens to my track licenses if I downgrade? ... the Premium Plan monetization license will expire upon next pay period and the tracks will no longer be covered by this license. Should you wish to continue monetizing without having an active Premium Plan you will need to purchase the copyright for that track."

Oof. So if you use this stuff on your YouTube/Twitch stream, you're locking yourself into a membership with them forever, or else you have to delete your old recordings.

BrentOzar··on New AI Music Generator Made for Creators
Given the response time on their server right now, I'm humming "Enjoy the Silence" by Depeche Mode.
BrentOzar··on Solar panels reduced my electric bill in 2022
> Can somebody explain where the return on investment comes from in residential solar?

During the run-up on housing prices over the last couple of years, there was a belief that an owned solar system would raise your house's sale price in much the same way that a kitchen or bathroom renovation would.

Couple that with the supply and labor constraints, which made it hard to get the panels, battery, and installers you wanted in a timely basis - that raised the perceived home value yet again, because if you wanted to add your own solar later, it wasn't seen as easily doable.

I don't know that the ROI was ever great, but with both of those factors gone today, it's worse than it ever was. (Source: shopped for homes in 2020-2021, bought in 2022, tried to get solar installed, ROI made no sense.)

BrentOzar··on Why do new cars look like wet putty?
> Neutral colors have the added benefit of being more easily resell-able (at a higher price), especially to private parties.

Only for neutral cars. Flashy cars (like the Audis and Porsches described in the article) carry a premium when they're flashy colors. There are even whole events dedicated to unusually-colored Porsches (paint to sample).

BrentOzar··on Trump Will Be Reinstated
I don’t like it, but I’m guessing it serves two purposes for Elon: it gives Twitter more press, and it gives the public a new villain to take the heat off Elon for a while.
BrentOzar··on FTX’s balance sheet was bad
> The result of adding or subtracting those numbers with ordinary numbers is not a number; it is prison.

Haven't laughed that hard in a while.

BrentOzar··on Twitter Now Asks Some Fired Workers to Please Come Back
> Being asked to go back just means it's cheaper to get you to return than it is to recruit someone to do your old job.

Only at your old rate.

BrentOzar··on Twitter Now Asks Some Fired Workers to Please Come Back
I would love to listen in on those negotiations.

If you’re reading this, and Twitter wants you back, I hope you ask for a contract with a year’s pay in advance, due before returning to work, at 10x your prior rate.

After all, you must be one of those 10x developers if Elon is willing to eat crow and ask you to come back.

BrentOzar··on Ask HN: Comment here about whatever you're passionate about at the moment
I’m sure you’ve come across her by now, but just in case you haven’t, check out Cecilia Blomdahl’s YouTube channel. The videos are way too long because she’s aiming for something ethereal and padding for YouTube ad revenue, but it’s very charming.
BrentOzar··on Could This U.S. Housing Market Crash Be Worse Than 2008?
> Are these houses mostly built to be sold on completion, or occupied by their current owners?

In the US, only a minority of houses are build from the ground up by a specific person (custom houses).

Most houses are built like this: property developers buy a large plot of land, divide it into plots, and build a group of houses. From the moment they divide the land into plots, they pre-sell the houses. The earlier you buy in, the lower your price is.

Because of that, it's tricky to answer your question:

* Some of the houses may not be sold yet * Some of the houses may be under contract, but the buyer can back out by losing their down payment (especially in cases where they can't get financing - you can put a home under contract without the full financing secured) * Some of the houses may be fully sold, with the financing paperwork already secured

BrentOzar··on Ask HN: What are some great items you own or want?
Never buy a new Lexus. They’re incredibly reliable. Let someone else eat the depreciation, and buy a 2-3 year old one instead.

Get an account at PenFed, apply for a used car loan through them, and you can use it to pay for vehicles from dealers or independent third parties. PenFed is a credit union that anyone can join with a donation - you don’t have to be a former Pentagon employee.

Don’t use them for your primary banking needs though. Their tech is a dilapidated nightmare. Just use them for auto and home loans.

BrentOzar··on Ask HN: What are some great items you own or want?
Philips LatteGo 3200 series fully automatic coffeemaker including lattes. Pour beans and water in, makes all kinds of drinks automatically, and most of the parts are dishwasher safe. About $800 USD.

Not as good as my local barista, but damn close, and a hell of a lot cheaper in the long run. Great for dinner parties too where folks want a cappuccino or something after dinner.

BrentOzar··on Wine 101: The Beginners Guide to Wine
Dry = not sweet. Not bitter - bitter is bad - but just not sweet.

Body = thickness, aka mouthfeel, aka strength of flavor and texture. (I’m simplifying here.)

Mature = complex. Simple wines that can be opened while young are usually straightforward in the same way that soda is sweet.

BrentOzar··on Libre Office has 10k followers on Mastodon
Related: two turkeys do not make an eagle. https://www.engadget.com/2011-02-09-googles-vic-gundotra-on-...
BrentOzar··on Run Stable Diffusion on Your M1 Mac’s GPU
It's falling back to CPU. Follow the instructions to use a GPU version - sometimes it's even a completely different repo, depending on whose instructions you're following.
BrentOzar··on What Really Happened to Malaysia's Missing Airplane?
Needs 2019 in the title.
BrentOzar··on Habitual GPS use negatively impacts spatial memory during self-guided navigation
Habitual calculator usage negatively impacts basic mathematics skills, film at 11.
BrentOzar··on Show HN: If VS Code had a data-centric IDE sibling, what would that look like?
> Microsoft has a fork of VS Code called Azure Data Studio

It's pretty buggy, and they haven't made much progress on fixing the bugs. I've used it pretty much since it came out - I do Microsoft SQL Server & Postgres work on my Mac - and the thousands of open issues on a relatively new product say something:

https://github.com/microsoft/azuredatastudio/issues

BrentOzar··on [dead]
Title should be "San Francisco" not "Susan Francisco".
BrentOzar··on French fighter jet joy ride goes très, très wrong (2020)
The author, Ezra Dyer, does spectacular work. He’s written many, many other brilliant automotive pieces around the web.
BrentOzar··on U.S. Treasury Announces Unprecedented and Expansive Sanctions Against Russia
I don't think it's subconscious - I think it's an SEO technique. People are checking whether Russia has been removed from SWIFT yet or not, and if your title has that unusual word, bonus points for you.
BrentOzar··on Meta facing order from Irish regulator to suspend data transfers to US
In the case of a thick client app:

> if user A living in France makes a post

The post data would be stored on a server in France.

> a user B living in America comments on it

The user B's thick client app would have to query all servers all over the world that might hold data they're allowed to see, and then render it. It's up to the servers in each country to decide whether the post should be sent to the viewer in question.

When User B comments, their comment would be stored on a server in the US.

For User A to see the comment, like User B, they would need to connect to all servers in all countries to fetch what data they're allowed to see.

Is this cheap and practical? Of course not. But it's possible, just not in the sense we've come to know social media apps.

BrentOzar··on Deconstructing the Postgres planner to find indexing opportunities
> This is one of the feature that MS SQL Server has and it works very well. It can suggest indexes with a pretty good correctness.

Not really: it's just a comma-delimited list of columns to consider indexing, sorted by the column order in the table. It just looks scientific to folks because they don't realize that. https://dba.stackexchange.com/q/208947/426

BrentOzar··on Open-Source Babelfish for Postgres
> In any case, I expect servers to have replicas for high availability. So even an 8-core server would count for a total of 16 or 24 cores for a 2-3 node cluster, isn't it? And then this multiplied by the number of clusters that you have.

As long as you're protected by Software Assurance, you get one free replica for high availability, another free one for disaster recovery, and yet another in Azure.

BrentOzar··on A read query can write to disk: a Postgres story
> But I don't see this model much. Why?

It does exist (I'm one of them), and it's much more common on expensive databases like Microsoft SQL Server and Oracle. With free databases, it's relatively inexpensive to throw more hardware at the problem. When licensing costs $2,000 USD per CPU core or higher, there's much more incentive for companies to bring an expert in quickly to get hardware costs under control.

BrentOzar··on Open-Source Babelfish for Postgres
> At $14K/core [0] for the Enterprise edition

Licenses are sold in 2-core packs, so it's $7,000 per core. (The link you included is the 2-core pack pricing.)

> still translates to 6-7 figures for even small deployments

The majority of deployments are 8 cores or less [0], so even if they were Enterprise - which they're not - they're 5 figures. Not saying it's cheap, but it's an order of magnitude less expensive than what you're suggesting.

[0]: https://www.brentozar.com/archive/2020/03/sql-constantcare-p...

BrentOzar··on Plans to shift aviation from magnetic navigation to true navigation
A heads-up display: https://www.flyingmag.com/how-it-works-head-up-display/
← PreviousPage 4 of 16Next →