SQLServerPSModule
SQLServerPSModule copied to clipboard
microsoft
This repo is the home of SQL Server PowerShell Module development.
Dear colleagues, seems that I have an issue, similar to [this](https://github.com/microsoft/SQLServerPSModule/issues/41). The difference is in a setup (possibly) and an error message. I have an Azure PS1 function with Managed...
I upgraded from 21.1.18256 to 22.1.1, and now I get errors running Invoke-Sqlcmd. I have verified that the newest version has the same behavior. ``` PS C:\WINDOWS\system32> invoke-sqlcmd -query 'SELECT...
This is a new parameter supported by Microsoft.Data.SqlClient 5.1+ See https://learn.microsoft.com/dotnet/api/microsoft.data.sqlclient.sqlconnectionstringbuilder.servercertificate?view=sqlclient-dotnet-standard-5.1 So, it may make sense to look into adding it (at least to Invoke-Sqlcmd).
In it's most basic form, if I try running the following in Windows Terminal (latest Powershell 7.3.5): ``` Invoke-SqlCmd -Query "select 1" -TrustServerCertificate ``` It can cause either of the...
Whenever trying to do any command besides select on a table that has Always encrypted enabled Invoke-SQLCMD throws an error. I'm able to do insert and deletion through SSMS and...
When creating a column master key you can specify if the key should be enclave enabled or not. $cmkSettings = New-SqlAzureKeyVaultColumnMasterKeySettings -KeyURL $akvKey.ID **-AllowEnclaveComputations** -KeyVaultAccessToken $keyVaultAccessToken ### $cmkName = "CMK1"...
The [`-InputFile` parameter information](https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?#-inputfile) in the `Invoke-Sqlcmd` documentation states _"Spaces are not allowed in the file path or file name"_. However, `Invoke-SqlCmd` executes successfully when the `-InputFile` parameter is used...
It would appear that PowerShell 7.3 is now on net7, so it seems logical to move forward.
It would appear that Test-SqlAvailabilityGroup, Test-SqlAvailabilityReplica, and Test-SqlDatabaseReplicaState all have a dependency on Microsoft.SqlServer.Management.HadrDmf.dll which is not available on net6.0... If we want those 3 cmdlets to light up, we...
To reproduce: Launch `Windows Powershell (x86)` on a windows 10 machine. Then execute ```ps Invoke-SqlCmd 'Hello, WOrld' ``` Yields ``` Invoke-SqlCmd : Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0,...
