HackerTrans
トップ新着トレンドコメント過去質問紹介求人

BrentOzar

no profile record

コメント

BrentOzar
·2 か月前·議論
The cup holder situation, on the other hand… (992.1 owner)
BrentOzar
·3 か月前·議論
> What if an executive makes a wrong business decision

I jokingly tell students, "We all know executives are gonna make bad decisions no matter what the data says. Might as well give them the random numbers more quickly."
BrentOzar
·3 か月前·議論
> This is basically the same as saying “databases weren’t designed for interns to run live inline migrations in prod”. Yeah of course they aren’t.

And the same as saying "databases weren't designed for non-technical people to connect with report-building tools like Power BI and Excel and run reports in the middle of peak customer checkouts."

As a DBA, I'm constantly surprised by what people think will be completely harmless to hook up to the database server - and then how much havoc it causes. Gonna be a rough decade.
BrentOzar
·5 か月前·議論
> Back in the 1970's we'd pull a spark plug and screw in a hose to use the compression phase to inflate tyres.

You'd inflate your tires with a gasoline and air mix?
BrentOzar
·7 か月前·議論
And why?

Sometimes it's just amazing to look at how much dedication someone put into a list like this, and wonder what they do with this information. It's inspiring (to me at least.)

In a park near my hotel, there's an elderly gentleman who uses a giant brush to paint calligraphy on concrete walkways every morning. He paints it with water - so it gradually evaporates over the course of the next hour or so. I admire his work in the same way I admire this web page.
BrentOzar
·7 か月前·議論
There are rumors that there were 2 pilots aboard, and that one of them accidentally triggered autoland, and they couldn't figure out how to turn it off:

https://vansairforce.net/threads/garmin-emergency-autoland-i...
BrentOzar
·7 か月前·議論
> I have also seen this used in other formats quite successfully - Fandom/Wikia (used to?) use a MySQL database for each sub-site.

Stack Overflow used it as well, with a database per site (DBA.StackExchange.com, ServerFault, SuperUser, Ask Ubuntu, etc.)

I have a bunch of clients using it. Another drawback with this design is high availability and disaster recovery can become more complex if you have to account for an ever-growing number of databases.
BrentOzar
·9 か月前·議論
> If you are on AWS and AWS goes down, that's covered in the news as a bunch of billion dollar companies were also down. Customer probably gives you a pass.

Exactly - I've had clients say, "We'll pay for hot standbys in the same region, but not in another region. If an entire AWS region goes down, it'll be in the news, and our customers will understand, because we won't be their only service provider that goes down, and our clients might even be down themselves."
BrentOzar
·9 か月前·議論
Because I'm sure other people will ask - no, it does not support SQL.
BrentOzar
·3 年前·議論
This feels way less intuitive than SQL:

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