Invoke-SqlCmd2
Invoke-SqlCmd2 copied to clipboard
dataplat
PowerShell module containing Invoke-SqlCmd2
This allows stored procedures to be called easier since parameters only need to be put in the hashtable and not in the query.
I've been using a modified version of Invoke-SqlCmd2 with an added switch -TrustServerCertificate for cases where the cert returned is not in the local trusted store. Generally I've used this...
Core has different assemblies for scrubbing DBNull. Here is a fix by another person prior to invoking any Invoke-SqlCmd2 will cause the block in Invoke-SqlCmd2 to silently fail. [Src](https://github.com/RamblingCookieMonster/PSSQLite/issues/28#issuecomment-663364740) ```posh...
When using a AZ Function MI, you need to use a connection string like: `Server=a.database.windows.net; Authentication=Active Directory Managed Identity; Database=a` but I get the error from AZ: `Keyword not supported:...
Right now, it requires a trusted authority sign it. I'd like to get an option for it. For what I'm doing it's easy: if ($Encrypt) { $CSBuilder["Encrypt"] = $true **$CSBuilder["trustServerCertificate"]...
Hi, there is an option `-ParseGO` which splits a file or query into multiple pieces of code and runs each splitted code once at a time. The problem is that...
The last release on PS Gallery is from 2016 and it seems like there have been a few improvements since then.
Some questions! * Do you still want to maintain this externally to dbatools? Personally I would suggest keeping it, even if it gets less attention, as it is a far...
