SQLServerPSModule
SQLServerPSModule copied to clipboard
microsoft
This repo is the home of SQL Server PowerShell Module development.
Haven't started on reproducing outside of Azure Pipelines yet, but: Copied from the issue in Description SqlServer 22.0.59 / Windows PowerShell 5.1 / windows-latest/ Azure DevOps This occurs on Microsoft-hosted...
**Issue Description** We are getting this kind of exceptions "`"Could not load file or assembly 'Azure.Security.KeyVault.Keys, Version=4.4.0.0, Culture=neutral, PublicKeyToken=927421***e12e44c8'. Could not find or load a specific file. (0x80131621)"` while executing...
Hey 😄 When running: ``` [xml] $results = Invoke-ASCmd ` -Credential $credential ` -ServicePrincipal ` -TenantId $azr_svc_tenant_id ` -InputFile Model_Tabular.xmla ` -Server $apiUrl ` 2>&1 ``` on version 22.3.0, we...
**Problem Statement** If we use connectionstring with Invoke-sqlcmd, we can specify "Column Encryption Setting = Enabled" to view plain text data if the column is encrypted. ``` $connStr = "Server=$serverInstance;Database=$tDBName;User...
See my comment in #82 This change is going to inteoduce breaking changes, so it'll be addressed in v23+.
Currently `-AccessToken` requires the token to be passed as string. `Get-AzAccessToken` (mentioned at https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps#-accesstoken) will return a `SecureString` in the future: ``` WARNING: Upcoming breaking changes in the cmdlet 'Get-AzAccessToken'...
Repro steps: Open PS5 and run the following snippet to get the error. The issue occurs with the specified version of the SqlServer PS module. Import-Module SqlServer -RequiredVersion 22.0.59 Import-Module...
To trigger an enclave-enabled (in-place) encryption operation using the `Set-SqlColumnEncryption` cmdlet, one needs to specify the enclave parameters - `EnclaveAttestationProtocol` and `EnclaveAttestationURL` (as per the enclave being used). But, if...
Using version 22.3.0 of the SqlServer module. I'm trying to restore from URL using the command: `Restore-SqlDatabase -ServerInstance localhost -Database MyDB -BackupFile 'https://storageaccount.blob.core.windows.net/container/filename' -RestoreAction Log -NoRecovery -TrustServerCertificate` This is to...
Hello Matteo, Details about the `-As` parameter are missing from the [Invoke-Sqlcmd](https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps) documentation page. #### -As Specifies the output type. | Type: | String | |:---|:---| |Accepted values:| DataSet, DataTables,...
