291 karma · joined November 2, 2022
There's a long way between hand-writing CPU instructions to make sure it does the same thing between runs, and the other extreme of writing a terraform yaml config and letting the engine decide how to get there.
Excel is so far from SQL/YAML that I can't lump them all together as "declarative". "Column from examples" comes to mind as a more declarative Excel feature than formulas in general.
It only shows the common options (i.e. the ones where you would use a keyboard shortcut rather than mouse), hiding anything you might actually have wanted.
Even for less skilled users, mixing horizontal/vertical icons got me a confused tech support call from my elderly father.
Not a problem for someone who understands the issue, but it is a slow/confusing way to open files.
The real problem is the default behaviour of double-clicking a CSV in Explorer and destroying the contents.
It's a common one, sadly. Anyone using the US date format for transfer or storage (debatably also display) should consider it a bug.
Lots of whiny Reddit threads, but only anecdata.
My own experience is that Dungeons & Dragons character art can be better (and more personally) created by writing your own stablediffusion prompts than by hiring an artist.
I've seen most local tables shift towards that.
E.g. Obscuring copyright breaches is the number one killer app for genAI so far. It's decimated the cottage industry of personal art commissions.
That's made them effectively immune to copyright enforcement so far; I'd go as far as saying the main function of llm/diffusion models is obfuscation of copyright breaches.
https://news.bitcoin.com/bitcoin-history-part-10-the-184-bil...
E.g. You can write a data pipeline in SSIS by just dragging boxes around and entering connection details.
Sometimes the abstraction doesn't expose something you'd like, so you add a bit of code (SQL/C# for SSIS), but that's the "escape hatch" rather than the default workflow.
You've also got the approaches like Power Query, where a frontend action is automatically recorded as code (M in that case) , but the code is largely hidden from the end user and only used for source control/escape hatch.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=020078...
E.g. French has Juin and Juillet, both "jui" start.
Better to just use yyyy-mm-dd everywhere. I see so many bugs from people still using US date format in 2023.
"Aquifer depletion" is worth searching if you want to read in detail.
Netflix playing at lower resolution for example.
Widespread TPM is actively harmful for most people, and the biggest blow to general purpose computing in recent years.
If Google ever makes a serious attempt at breaking compatibility like they're doing now (or we've seen from reddit/twitter), you'll see degraded ux.
It would make more sense to amortise over vehicle lifetime regardless of owner.
That said, electric cars are greenwashed beyond belief.
Being slightly better for the environment than combustion doesn't make them better than bike/train/bus.
In MtG or LoL, a worse player than the opponent might still win 40% of games (luck of the draw or teammates), even ignoring matchmaking systems.
Players can aim for losing less over time, while still having a chance to win any particular game.
In SC or chess any chance of success against a better player is effectively zero.
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpa...
The APIs were historically part of Visual Studio, and only split out into dacfx recently.
Someone braver than me could consider automated deployment from github actions etc.
The hard part is that a lot of database schema changes cause data truncation (e.g. reducing the size of a column or re-ordering columns).
You still need someone to review the generated code if it throws an error for potential data loss.
Windows Powershell gives you the detail of git push in scary red text.
https://stackoverflow.com/questions/12751261/powershell-disp...
The MSSQL equivalent would be DbaTools, in case anyone is looking.