SQLServerPSModule
SQLServerPSModule copied to clipboard
This repo is the home of SQL Server PowerShell Module development.
With something like this: ```sql CREATE TABLE [dbo].[TestTable1]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](64) NOT NULL, [ChangeDateTime] [datetime] NOT NULL, [Category] [nvarchar](64) NOT NULL CONSTRAINT [PK_TestTable1] PRIMARY KEY CLUSTERED...
I have a release pipeline in Azure DevOps that includes tasks of the built-in type _"Azure SQL Database deployment"_. These steps run SQL script files with a few parameters against...
The documentation says ```-NewPassword``` can be used to change the password of a SQL Server Authentication login ID. When I run this Cmdlet it shows an error and it also...
Currently, to enable or disable Always Encrypted (AE) functionality when using Invoke-Sqlcmd, we must pass Column Encryption Setting=Enabled (or Disabled) via the connection string. It would be more user-friendly and...
The progress of the Write-SQLTableData function floods interactive consoles and memory. On PS5 it’s not possible to suppress the progress. Or may be a way we don’t know?