SQLServerPSModule

SQLServerPSModule copied to clipboard

Using Invoke-SqlCmd in ForEach-Object -Parallel loop - not threadsafe?

3

It appears that Invoke-SqlCmd is not threadsafe - is this correct? Can it be made to be so? Got this error while executing in a ForEach-Object -Parallel type loop Operations...

jplee75

SQLRegistration does not work with SSMS 20.0 and SqlServer module 22.2.0

1

I can add a new item to the "PS SQLSERVER:\SQLRegistration\Database Engine Server Group" but the new item does not show up in SSMS 20.0 "Registerd Servers" example: New-Item -Name $(encode-sqlname...

PeterPorsche

Version 22 on Powershell Gallery but no details here

4

https://www.powershellgallery.com/packages/SqlServer/22.0.59 has a changelog that links here but there's no recent commits. Can anyone provide more detail? We had some issues using it and wanted to check we were holding...

cailyoung

Hello, Regarding the release, v22.2.0: - https://www.powershellgallery.com/packages/SqlServer/22.2.0 - At the moment, nearly 64 million downloads When I check the wiki for the release notes, they are empty. Do you plan...

Delamater

Restore-SqlDatabase times out with "The wait operation timed out"

6

When restoring a large database using `Restore-SqlDatabase` the command times out after 600 seconds. This is regardless of the `ConnectionTimeout` parameter setting. Tried setting it to 0 and setting it...

tn-5

Adding module to azure automation runtime 7.2 fails with This module requires PowerShell 7.2.1+. Please, upgrade your PowerShell version by checking https://aka.ms/pscore6.

6

Does this mean it wont run until azure automation is also updated and if so can we install prior versions of the module, otherwise i am going to have to...

craftzneko

Did support for SSIS disappear?

9

The latest version of the SqlServer Powershell module seems to be missing support for SSIS. The documentation here: https://learn.microsoft.com/en-us/sql/powershell/sql-server-powershell-provider?view=sql-server-ver16 Still lists SQLSERVER:\SSIS as one of the ways to navigate SSISDB...

micbarrett

Write-SqlTableData : A parameter cannot be found that matches parameter name 'TrustServerCertificate'

1

Import-module sqlserver -MinimumVersion 22.2.0 $ConfigInfo = Import-CSV 'C:\ConfigStuffToImportOnSQLServer.txt' Write-SqlTableData -ServerInstance myinstance -DatabaseName 'master' -SchemaName 'dbo' -TableName 'GoodStuff' -Force -ConnectionTimeout 0 -Timeout 0 -InputData $ConfigInfo -TrustServerCertificate This command mostly works but...

GregLeeUpSearch

Write-SqlTableData doesn't clear Write-Progress bar

1

Writing data to a table with Write-SqlTableData creates permanent Write-Progress bars that never clear. There is likely a missing call to Write-Progress with the -Complete flag in order to close...

samplesty

Method not found: 'Void Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider.SqlColumnEncryptionAzureKeyVaultProvider

7

I am trying to encrypt Azure SQL Database Columns Using Azure Automation Run Book. Code is written in power shell and is failing when trying to execute this command $serverName...

Tbablani72