SQLServerPSModule
SQLServerPSModule copied to clipboard
microsoft
This repo is the home of SQL Server PowerShell Module development.
Please provide a way to filter Read-SQLXEvent at the server level using the file_name, and file_offset parameters if possible. Or some other way to filter / limit the data coming...
I upgraded from 21.1.18256 to 22.1.1, and now Write-SqlTableData gets an error. ``` Write-SqlTableData : The type initializer for 'Microsoft.Data.SqlClient.InOutOfProcHelper' threw an exception. At line:1 char:1 + Write-SqlTableData @SQLServerArguments -TableName...
If I run the following to check my local pubs database for fragmentation (`config.json` lowers the threshold to 0) I get three rows per index as it is a partitioned...
Is it possible to do the below? $Database = Get-SqlDatabase -ServerInstance $Server -Name $Name $Database | Invoke-Sqlcmd -Query "Insert Into..."
Possible to include a maximum .bak file size and have it automatically split backup into multiple files? Example: Backup-SqlDatabase -MaxFileSize 150GB
this a feature request for Write-SqlTableData to add KeepIdentity and KeepNull options I assume this is using SqlBulkCopy which has SqlBulkCopyOptions already supporting these capabilities.
Fresh, default install of SQL server 2019 developer edition. Updated to latest release version of `SqlServer` . Executed ``` Invoke-SqlCmd -serverInstance localhost -query "SELECT 'Hello, world'" ``` fails with error...
In v22.0.57, I may have missed a few (e.g. Enable-SqlAlwaysOn and Disable-SqlAlwaysOn). It would be nice to complete the list in some v22 update.
A reminder for myself to look into this cmdlet. It does not seem to do anything (when I use it with -Path it works). Also, I need to add tests...