DBA for the last 10+ years. Enjoys automation, scripting and new technology toys to play with.
Victoria, British Columbia
Joined September 2017
- Tweets420
- Following67
- Followers180
- Likes356
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/pu…
When you hide your #powershell code behind a docker container so that other people on the team can also use it
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/PowerS…
Kirill Kravtsov retweeted
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-DbaS…
Kirill Kravtsov retweeted
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!
Kirill Kravtsov retweeted
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…
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…
Kirill Kravtsov retweeted
Agreed! The dbatools community on Slack is absolutely invaluable to our project. Huge thanks to everyone who spends their time helping out 🙇 aka.ms/sqlslack
This Post is from an account that no longer exists. Learn more
Kirill Kravtsov retweeted
Now I'm curious... if you've used @psdbatools for migrations - do you usually go for the big bang approach with Start-DbaMigration, or a more piecemeal approach using the Copy-Dba commands?
35%Start-DbaMigration
65%Piecemeal - Copy-Dba*
69 votes • Final results Kirill Kravtsov retweeted
dbatools 1.1.0 has dropped 🥳 We've made a ton of changes, like adding more support for Azure and Linux. We did up our requirements to .NET 4.6.2 (released in 2018) but dbatools now works even better on all platforms. More details here 👇🏽 github.com/sqlcollaborative/…
This is very cool! Kudos to Microsoft FOSS Fund for recognizing dbatools!
We are incredibly honored to be the May 2021 recipient of Microsoft's FOSS Fund! Thanks to all Microsoft employees who helped make this happen. And thank you Microsoft for your support of open source software 🥰 github.com/microsoft/foss-fu…
Kirill Kravtsov retweeted
We are incredibly honored to be the May 2021 recipient of Microsoft's FOSS Fund! Thanks to all Microsoft employees who helped make this happen. And thank you Microsoft for your support of open source software 🥰 github.com/microsoft/foss-fu…
Finally finished my blogpost on Python module documentation: nvarscar.wordpress.com/2021/…
Let me know what you think!
After a long hiatus, today a new version of #DBOps Powershell module has been released: 0.7.0. In a new version, baseline DbUp journalling was improved to include a few extra columns, including appliedBy, checksum and executionTime.
I needed to name a column that contains info on whether a table is referenced by a foreign key. My brain thought .5 seconds before going with "is_fked"
Congrats @jpomfret! Honored to have you in the team!
We are super honored and excited that @jpomfret has accepted our invitation to be a maintainer of dbatools 🥳! Since 2017, Jess has contributed high-quality code, created tons of tests and has helped create a welcoming community for our toolset 💌 github.com/jpomfret
Kirill Kravtsov retweeted
We are super honored and excited that @jpomfret has accepted our invitation to be a maintainer of dbatools 🥳! Since 2017, Jess has contributed high-quality code, created tons of tests and has helped create a welcoming community for our toolset 💌 github.com/jpomfret