Install-SqlServer VS dbatools

We have tones of PowerShell and it works like a charm, although we have some experienced posh devs

We also test REST backend in PowerShell using Pester.

PowerShell is preferred in this house because

a) you can run it on any Windows OS on the spot and modify it in ad hoc manner, you can even debug it with breakpoints etc easily Also our Linux machines have it.

b) its powerful, you can do anything in it with few lines of code (one case: we did 10 million SOAP requests per day for entire country)

c) many Windows toolsets use it like SqlServer, IIS etc. which makes management way easier (for example we use [1] to install sql server on all dev/prod machines)

d) we find it way easier to keep CI/CD vars in PowerShell hashtables then in yaml, so our yaml fiels are one liners and everything works locally.

---

[1] https://github.com/majkinetor/Install-SqlServer

dbatools (for deploying database changes)

It's very rare I open files that big, but just for fun I took the 1k lines here: https://github.com/sqlcollaborative/dbatools/blob/development/dbatools.psm1 copied and pasted the code 37 times into a .ps1 file and opened it in ISE. ISE opened and highlighted it in like 1-2 seconds so the PS parser is clearly able to parse things quick enough for it to not matter.