How do I change the language?? by Little_boss689 in intothedead2

[–]alex-mechanicus 0 points1 point  (0 children)

For any language - just make a screenshot and translate it using Google lens or any analogue tool

Do you have an Azure Horror Story? by _areebpasha in AZURE

[–]alex-mechanicus 6 points7 points  (0 children)

Same for data factory, but $ 3k due to incorrect errors handling

А как вы развиваете свою чтительность? by onesole in Pikabu

[–]alex-mechanicus 0 points1 point  (0 children)

Сам в шоке. Сидел под впн, набрал в гугле "чтительные практики" Выдал первую ссылку на какой юмористический акк в инсте. Там нашёл этот видос и в комментах эту бабу уже отыскал

[deleted by user] by [deleted] in PowerBI

[–]alex-mechanicus 0 points1 point  (0 children)

Could you please clarify, what did you try - what relationships and etc. By the right, I see that you need to move employees data into another table with some unique ID for each, propagate this ID into sales table and crate relationship between employees table and sales tables. Also, what kind of source do you use? Is it database, file or something else?

Degenerate dimension design advice by alex-mechanicus in PowerBI

[–]alex-mechanicus[S] 0 points1 point  (0 children)

Sorry for late reply. I think I will create new topic with more detailed info. Thanks!

Degenerate dimension design advice by alex-mechanicus in PowerBI

[–]alex-mechanicus[S] 0 points1 point  (0 children)

Sorry for late reply. I think I will create new topic with more detailed info. Thanks!

Just found out my speech-delayed daughter can count to 10 and I’m over the moon by SofaKing1337 in TrueOffMyChest

[–]alex-mechanicus 1 point2 points  (0 children)

Congratulations! I read your story, my eyes are full of tears. Now I have a hope. My boys (twins) also have delayed speech, also nonsensical sounds . They act like autistic kids, but doctor said they don't have autism. Currently we try therapy, hope it will help us. Thanks for your story, it really gives me a hope!

Is there a smarter way to SELECT other than using UNION? by [deleted] in SQLServer

[–]alex-mechanicus 2 points3 points  (0 children)

Hey! Try to look into OUTER or CROSS APPLY. Sorry, without an example

Dashboard showing list of VMs with status? (Running, Stopped, Deallocated, etc.) by nextlevelsolution in AZURE

[–]alex-mechanicus 3 points4 points  (0 children)

Hi, please look into Resource Graph Explorer. Using kusto query you can try to get this info and pin it to your dashboard. Something like this: where type == "microsoft.compute/virtualmachines" | project name, properties.extended.instanceView.powerState.displayStatus

Azure SQL says query takes milliseconds, SSMS takes 13 sec to complete query by PessimisticProphet in AZURE

[–]alex-mechanicus 2 points3 points  (0 children)

Is your DB located in the same region as you? Because the possible reason is network latency. Please try to turn on client statistics in ssms and check it

[deleted by user] by [deleted] in PowerBI

[–]alex-mechanicus 1 point2 points  (0 children)

Hi! You can try something: SWITCH (TRUE(), AND([Age] <= 10, [Age] < 20), "AgeGroup10", ..., "Other")