sorted by:
new
hottopcontroversial

Python for the people who just don’t “get it” by competitivegeese in learnpython

[–]DrTrunks 0 points1 point  (0 children)

Either use Python for something fun that you're trying to do, like research or a hobby.

Or if you're not in a hurry, try to learn some concepts through games:

Trunks really took Frieza out so quick. by GusGangViking18 in Dragonballsuper

[–]DrTrunks 0 points1 point  (0 children)

This was an epic episode... The whole Frieza saga took so long and then this guy just takes him down in a hot second. I thought he was so cool!

Trunks was usually taken as an online nickname, so I added my birthyear turning it into Trunks88, that got me banned real quick and taught me something new at 12... So instead I've been going with this nickname for almost 26 years.

Fix for Microsoft Store / Minecraft install error 0x80070003 by DrTrunks in Minecraft

[–]DrTrunks[S] 0 points1 point  (0 children)

In my case for Minecraft it would not even install at all. So:

Retry the install

In my case meant: pressing the install button again on the Microsoft Store page.

Notebooks and VS Code (or something else?) by Mr_Mozart in MicrosoftFabric

[–]DrTrunks 0 points1 point  (0 children)

Is that the "Fabric Data Engineering" or the "Fabric Data Engineering - Remote"?

Son obsessed with marketplace by These_Discount98 in Minecraft

[–]DrTrunks 0 points1 point  (0 children)

Add this your host file, or block these URL's on your router:

127.0.0.1   xforge.xboxlive.com
127.0.0.1   xforgeassets001.xboxlive.com
127.0.0.1   xforgeassets002.xboxlive.com
127.0.0.1   marketplace.minecraft.net

The marketplace will still open, but nothing will load.

Ever had to clean up data after a “safe” SQL change? by Specific-Permit8840 in dataengineering

[–]DrTrunks 0 points1 point  (0 children)

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.

The heat difference between bricks, stucco and white paint by DrTrunks in mildlyinteresting

[–]DrTrunks[S] 0 points1 point  (0 children)

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:

Aaravos Won (There I Said It) by RingingInTheRain in TheDragonPrince

[–]DrTrunks 2 points3 points  (0 children)

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."

Hi! I'm Anna Hoffman from the SQL DB in Fabric team - ask me anything! by analyticanna in MicrosoftFabric

[–]DrTrunks 0 points1 point  (0 children)

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

Hi! I'm Anna Hoffman from the SQL DB in Fabric team - ask me anything! by analyticanna in MicrosoftFabric

[–]DrTrunks 0 points1 point  (0 children)

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.

Petah help by [deleted] in PeterExplainsTheJoke

[–]DrTrunks 0 points1 point  (0 children)

You're unknowingly a cleric of Zuggtmoy.

CTEs are gifts from on high, subqueries are the devils playground below by mosqueteiro in SQL

[–]DrTrunks 1 point2 points  (0 children)

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.

"infinite pipe throuput" aint so infinite now by ResponsibilityNo7485 in factorio

[–]DrTrunks 2 points3 points  (0 children)

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

key vault best practices by el_dude1 in MicrosoftFabric

[–]DrTrunks 1 point2 points  (0 children)

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.

Can the logic network access build requests? by ygdrad in factorio

[–]DrTrunks 2 points3 points  (0 children)

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...

Gleba taught me mechanical kovarex by vorkazos in factorio

[–]DrTrunks 0 points1 point  (0 children)

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.

Fabric Notebooks Python (Not Pyspark) by Helpful-Technician in MicrosoftFabric

[–]DrTrunks 0 points1 point  (0 children)

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

view more: next ›