Kirill Kravtsov

@huwjohnroberts @2meterDBA In this case you just provide an empty password. Here’s a similar question if you want to use a non-interactive way of submitting it stackoverflow.com/questions/7426…

@kevchant An interesting use-case! And a great presentation. Was really glad to see the module in action from within Azure pipelines.

Several days and 70 commits later I'm finally done with a Pester 5 migration. I did a full redesign of test cases, which now use updated syntax to execute same tests against various RDBMS. Really happy with how it looks now! One step closer to 1.0! github.com/dataplat/dbops…

dbatools 2.0 will be one "meta module" that contains multiple underlying modules. Functionally, end-users will not notice much outside of commands loading faster and we'll all still: Install-Module dbatools

@nohwnd Congrats! Best wishes and happiness to your family!

Today at 2022/11/11 22:44 our family became complete. Our son Vojtěch joined me, Iva and Matěj in the world. Thank to my wife for doing all the hard work. 😘

When you hide your #powershell code behind a docker container so that other people on the team can also use it

@kevchant Thank you kind Sir! This means a lot.

I was trying to create an arm64 Docker container on my Mac to ship some #pwsh code and it was complaining about the mcr.microsoft.com/powershell native image. Found a solution in a GitHub issue, in comments, and commenter's avatar looked familiar. Thanks @cl :D github.com/PowerShell/Pow…

@adamdriscoll oh damn. The speediest of recoveries to you.

It's tempting to just use the Services MMC to change the SQL service account, but try to resist. Instead, use Update-DbaServiceAccount by @nvarscar which also updates permissions, including read access to any certs being used for encrypted connections 🤩 docs.dbatools.io/Update-DbaServ…

@JordanOrdix @erikdarlingdata @psdbatools Nope, we should open an issue for 2022 support and a new component(s) if needed

@erikdarlingdata @psdbatools @nvarscar Do you have a 2022 version and already planned to update the command? Ping me if you need help.

One more reason to use Install-DbaInstance from @psdbatools

Looking for a place in Berlin for 3 Ukranian folks to stay at for 2-4 weeks. They have family in the US and are trying to move on, and they just made it to Berlin. If anyone has connections or recommendations to make this happen, DMs are open. Thanks!

@gerbyj That's awful. Feel better soon.

I've had covid for a week and still every day is a new adventure. Today I'm really woozy. I can't read computer screens and I feel like I'm going to fall when I stand or walk.

I like so much new automated way to upgrade CU for #SQLServer with @psdbatools ... I just have to run one command and to wait (with a coffee) and monitor everything come back to normal 😎

My team is looking for an SRE with good k8s knowledge and automation/scripting skills. Remote position in Canada. 100% cloud-based fast-paced infra-as-code environment. Apply here: jobs.lever.co/everbridge/c43…

@cl @shueybubbles What a time to be alive!

@cl @m82labs Unfortunately no, the command doesn't know anything about whether the host is a part of a cluster. I've seen some folks using a script that would patch a passive node, invoke a failover, and then patch a former primary. Ask in the #dbatools channel in SQL Slack if interested.

How are folks handling OS patching on larger (100+) SQL Server estates in production? Mostly manual? Relying on auto-failover? Something else? #sqlhelp

@ALevyInROC @psdbatools Good times man!

@awickham As someone who worked on that position for the past 2.5 years, I completely agree. Looking back I kinda wish I could keep some kind of TIL diary, I bet there would've been almost no days without a post.

Folks... This sounds like a fun one!

Hey everyone, we're looking for an Automation DBA in the Operations team. PostgreSQL + Ansible + Python is the sweet spot, but don't hesitate to apply if you're great at one and willing to grow into the other. PDT, remote or not, great team and benefits. jobs.lever.co/everbridge/992…