SQLServerPSModule
SQLServerPSModule copied to clipboard
This repo is the home of SQL Server PowerShell Module development.
Hi, version of module is : ModuleType Version Name ExportedCommands ---------- ------- ---- ---------------- Script 22.3.0 SqlServer {Add-RoleMember, Add-SqlAvailabilityDatabase, Add-SqlAvailabilityGroupListenerStaticIp, A... and where i'm use parameter -ProgressAction of Restore-SqlDatabase cmdlet...
Hello, like mentioned in the headline, the Write-SQLTableData command has in Powershell 5.1 no progressaction parameter. This is no issue when we know it, but in documentaion for this module...
Write-SqlTableData with ProgressAction set to Continue appears to be consuming considerably more memory than with SilentlyContinue. When ProgressAction is set to continue we observed the memory usage to be growing...
Security vulnerability introduced by System.Text.Encodings.Web version 4.0.5.1 included  See below the detail in CVE https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-26701
The following is the setup script for this scenario. After running the following TSQL script, encrypt column [T].[AB].[B] /****** Object: Schema [T] Script Date: 8/1/2024 6:47:58 PM ******/ CREATE SCHEMA...
SQL Server PowerShell Provider (SQLSERVER:\SQLRegistration): Group name should not be case-sensitive
The SQL Server PowerShell Provider fails to locate a group of registered servers when the group's name is typed with the wrong capitalization. Steps to Reproduce the Problem: 1. Launch...
I am using the SQL Server PS module in an [Azure Deployment Script](https://learn.microsoft.com/en-us/azure/templates/microsoft.resources/deploymentscripts?pivots=deployment-language-bicep). It imports the module with ``Install-Module`` and then invokes an SQL command with ``Invoke-SqlCmd``. This has previously...
# SqlServer Module Breaking Change - AzureAuthenticationInformation Constructor ## Summary The SqlServer PowerShell module versions 22.4.0+ contain a breaking change in the `AzureAuthenticationInformation` class constructor that causes Always Encrypted operations...
**environment** SqlServer PowerShell Module version: 22.4.5.1 OS: Microsoft Windows Server 2019 Standard OS Version: 10.0.17763 Build 17763 PS Version: 5.1.17763.7671 **problem** Read-SqlXEvent does not output [database_name] field from XEL files....
**Environment:** SqlServer PowerShell Module version: 22.4.5.1 OS: Microsoft Windows Server 2016 Standard OS: Version: 10.0.14393 Build 14393 PS Version: 5.1.14393.8330 **Problem:** Password with semicolon is treated as separator in connection...