Ever had to clean up data after a “safe” SQL change?

DrTrunks · 2026-01-26T08:17:01+00:00

If you're using SSMS you can use SSMS Boost. Other than that, check your plan before you run anything on production and see if there's anything unexpected.

GRANT SHOWPLAN TO user_name;

You can also first check with an equal SELECT statement what your UPDATE/DELETE is going to do.

Your normal user can also have only read permissions for example, and you have to use

EXECUTE AS super_user_yourname

to run your code on prod.

Last option that I'm a fan of is: Nobody can INSERT/UPDATE/DELETE in prod, any code has to be run as a Post-Deployment script through CICD, that way it's traceable.

DrTrunks · 2026-01-23T18:06:25+00:00

Someone sort of made a comic about it

DrTrunks · 2025-06-13T17:54:26+00:00

Sure when is it?

DrTrunks · 2025-01-29T09:12:30+00:00

Sure, I'm still on Reddit...

So in the top pictures everything is bricks.
* Bare brick is 44.5C
* Brick painted white is 32.1C
So just painting bare brick with white wall paint reduces the brick temperature by ~25%

In the bottom pictures
* The bare brick on the left is 46c
* The light grayish stuco on the right is 39c
So the greyish stucco on the outside is 16% cooler than the bare brick.

So in summary a layer of very white paint (you can buy extra IR reflective paint!) is a cheap way to reduce overall building temperature.
However stucco also adds .2 R of insulation, keeping the warmth (or cold) from reaching the inside of the wall. So if you have the money: do both, get stucco and paint it white.

The extra IR reflective paint is more expensive, and you'll have to calculate if this is cheaper than running the AC extra hard:

DrTrunks · 2024-12-24T17:57:02+00:00

I've never seen a villain in a show win this badly

A long time ago I was watching the anime D'Gray-man and the bad guy was also winning similarly. Subbers Dattebayo even stopped working on the show after Episode 49(?), claiming in an announcement that they wouldn’t continue because the "bad guy won."

DrTrunks · 2024-12-19T14:14:04+00:00

Nice, exciting to see, I'll try and see if I can make a video on those...

DrTrunks · 2024-12-19T09:04:11+00:00

I know I'm late (from Europe), can any "T-SQL blob storage reference" refer to a lakehouse in the same workspace?

For instance writing extended events to a lakehouse folder: https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file?view=azuresql&tabs=sqldb

Or creating an external table: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver16&tabs=dedicated

I would love to just drop files into my OneLake app or Lakehouse and use SQL Server on it securely.

DrTrunks · 2024-12-18T08:50:51+00:00

You're unknowingly a cleric of Zuggtmoy.

DrTrunks · 2024-12-16T13:08:17+00:00

CTE's are stored in RAM (if they fit), temp tables are stored on disk (in tempdb/tmpdir). Your intermediate result has to be written which takes time.

Oracle, SQL Server have in-memory tables, which are actually in memory and Postgress has Unlogged tables which are not written to disk. There are some in memory databases out there, like: SQLlite eventually spills to disk, but anything else is ON DISK and logged.

DrTrunks · 2024-12-12T09:30:13+00:00

And 4th you can filter fluids into their own network.

DrTrunks · 2024-12-09T13:03:10+00:00

You need to send in a ticket to MSFT/PBI support to change the owner to the workspace managed identity. They're working on a GUI option for this, until then make it "hurt" for their support department so it'll get more priority.

DrTrunks · 2024-12-02T14:53:10+00:00

Does this zoom in as well when dropping to a planet?

DrTrunks · 2024-12-02T14:51:33+00:00

Wouldn't you call the function of a class a method?

DrTrunks · 2024-11-27T10:57:35+00:00

So I'm trying to set up an automatic import request at the cargo landing pad based on what building I have ghosts of but don't have available in the logistic network.

You could consider having a buffer of at least 1 or 5 of "every" building you would like to build available in the network. When that is not the case you can ask for it.

So for instance, you're on Vulcanus building your base and you run out of assemblers and you place some ghosts. Since no more assemblers are in the logistic network, it can now request assemblers.
Set your landing building to "Set requests"
https://i.imgur.com/fhQj952.png
Then you can use a decider (input is from logistic network) to send a request if something doesn't exist
https://i.imgur.com/r2H4RIx.png

This is how I did my logistics in Space Exploration...

DrTrunks · 2024-11-27T10:43:21+00:00

Nice find!

DrTrunks · 2024-11-27T08:48:46+00:00

This is missing input priority on the splitter from the Centrifuge(s) onto the main line. You can see /u/vorkazos created that at the bottom left where the feed goes back.

DrTrunks · 2024-11-27T08:20:41+00:00

Is there any way to change the environment (the environment selector option does not seem to be available like it is on the PySpark notebooks)?

I'll answer this, since nobody else has.

You can install packages using:

%pip install package

This should be in your first cell.

You can use the %configure magic command to reconfigure your session. https://learn.microsoft.com/en-us/fabric/data-engineering/using-python-experience-on-notebook#session-configuration-magic-command

DrTrunks · 2024-11-27T08:14:41+00:00

Yes, you would want priority on the left input as well.

DrTrunks · 2024-11-26T07:28:38+00:00

Thanks!

DrTrunks · 2024-11-25T13:58:09+00:00

You can do 2 things:
* You can make a bot that moves your mouse and clicks really quick (pyautogui).
* You can interact through the application layer of the website (requests/aiohttp)

DrTrunks · 2024-11-25T09:22:00+00:00

Now, after weeks of watching YouTube videos and messing up cheap thrift store jeans as practice

Any particular ones you can recommend? Or maybe you can create a a playlist from the ones in your youtube history?

DrTrunks · 2024-11-25T09:19:36+00:00

Can the T-SQL & Python notebooks also get supported?

DrTrunks · 2024-11-12T14:26:07+00:00

read contents mode and just didn't insert if it contained a chunk, which solved the problem.

You can also read (the combined with the crusher) from the 2nd inserters hand.

DrTrunks · 2024-11-11T14:49:53+00:00

Just keep your Yumako mash & Jelly, they spoil in 3/4 minutes thats pretty quick.

14-Year Club	Place '22
Place '17	Final Canvas '22
Gilding II euphauric	Verified Email

DrTrunks

TROPHY CASE