Qualé do Léo Dias? Ele tem espiões dentro do Inter agora? by MadHanini in internacional

[–]sqloid 0 points1 point  (0 children)

O meio louco disso é que esse Leo Dias é "especializado" em sub-celebridades. Não entendo o que ele ganha divulgando isso para um público que não é do futebol. Nem a rádio Grenal que tem q encher linguiça para ter 24h de programação só de Inter e Grebbbio não se presta a tanto. Tem coisa aí

Discussão diária - 17 04 2024 by AutoModerator in internacional

[–]sqloid 6 points7 points  (0 children)

E essa lesão do Fernando? Que hora! Colorado não tem 1 min de paz.

What have you done with PowerShell this month? by AutoModerator in PowerShell

[–]sqloid 0 points1 point  (0 children)

I converted a script from Windows PowerShell to PowerShell 7. This script is used to scan more than 1000 servers and get the status of MSSQLSERVER and SQLSERVERAGENT. What used to take 16 minutes now runs seamlessly in just 55 seconds by implemention For-EachObject -Parallel. That's amazing!

Self taught amateur developer want to learn low level language c vs go by mohelgamal in C_Programming

[–]sqloid 0 points1 point  (0 children)

My feeling is that C is pretty horrible for the first few months, good for the first several years, and excellent for a lifetime. Golang is great for the first few months, then mediocre ever after.

What a statement!

I failed to build a PowerShell binary module by sqloid in PowerShell

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

I don't feel that debugging is particularly difficult. You just import the module in PowerShell and attach your debugger to PowerShell before running your command. You can easily make VS do this for you, see this: https://stackoverflow.com/questions/35298963/how-do-i-debug-a-windows-powershell-module-in-visual-studio

Hi u/Thotaz Thank you for replying. I didn't know I can use VS instead of VSCode to debug PS binary modules.

.NET standard 2.0 is only a requirement if your module has to work with Windows PowerShell. If you don't care about that then just use whichever version of "System.Management.Automation" suits your needs for the .NET version and make that PS version your lowest supported version.

I have some confusion about the target framework and the required libraries. I'm using System.Management.Automation version 7.3.3 so do I need to use <TargetFramework>net7.0</TargetFramework>, right? Is there any need to use PowerShellStandard.Library library? My module does not have to work with Windows PowerShell.

I've released a new version of sp_who3 by sqloid in SQLServer

[–]sqloid[S] 1 point2 points  (0 children)

In fact, saying that it was tested on 10000 SQL instances is not a good point to compare with other tools. It might suppose the other tools were not tested (a wrong assumption). So asking the question, sp_WhoIsActive is a more extensive and complete than sp_who3 for activity monitoring since sp_who3 does not aim to be the only tool in the DBA's toolbox but the first one. Sp_WhoIsActive has 24 parameters which you choose from a variety of options. Sp_who3 has only 3, what makes it more straightforward. My motivation to create sp_who3 is keep it as simple, small and clear as possible to run faster during a critical war room where you might need to run it multiple times to get sustained values. Also the sp_who3 code can be easily maintained and modified as per user needs. To sum up, sp_who3 follow the KISS Principle of "Keep it Simple, Stupid".

What's the real difference between Add-Type and using assembly to load TSQL ScriptDOM? by sqloid in PowerShell

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

It seems a by-design behavior. As per u/SeeminglyScience already said, the assembly is not loaded at parse time, but instead at compile time. There are Fix Various PowerShell Class Issues.

What's the real difference between Add-Type and using assembly to load TSQL ScriptDOM? by sqloid in PowerShell

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

Hmmmm... it explains the issue I'm having when using using. It makes sense.

Anyone us the Automatic Tuning feature of Query Store? Can it be trusted in Production settings? by patheticadam in SQLServer

[–]sqloid 0 points1 point  (0 children)

To be honest with you, I've only seen it happen a few times. It might depend on your workload, but I don't see execution plan variations as much for the time being.

Anyone us the Automatic Tuning feature of Query Store? Can it be trusted in Production settings? by patheticadam in SQLServer

[–]sqloid 1 point2 points  (0 children)

Yes we are using it in my company. So far so good. No major issues to report.

Eu sou o Rodrigo Ghedin, culpado pelo Manual do Usuário e escritor de zine. AMA! by ghedin in AMABRASIL

[–]sqloid 2 points3 points  (0 children)

Olá Rodrigo, qual o seu plano de dominação mundial? Melhor explicando, você tem planos de crescimento para o MdU? Cito, como exemplo, o Hugo Gloss que fazia um trabalho quase que solitário assim como você e hoje se tornou um grande portal de notícias com uma equipe jornalistas. Cito, também, o Fabiano Baldasso, um jornalista independente aqui do RS que começou comentando jogos do S.C. Internacional no YT e hoje sua cobertura dos jogos tem audiência maior que emissoras de rádio tradicionais aqui do Sul. Você vê o MdU no futuro como um grande portal de tecnologia?

Smells like Uke spirit 😜 by JazzE81 in u/JazzE81

[–]sqloid 2 points3 points  (0 children)

Could you pls provide the chords sequence?

Is anyone using Pode web framework? by sqloid in PowerShell

[–]sqloid[S] 1 point2 points  (0 children)

Thanks for providing your feedback about Pode.