SQLServerPSModule
SQLServerPSModule copied to clipboard
microsoft
This repo is the home of SQL Server PowerShell Module development.
Since [.Net compiles to WebAssembly](https://blog.jetbrains.com/dotnet/2022/12/15/the-future-of-net-with-wasm/) now, it should be feasible to create a [WebAssembly package](https://wapm.io/search) for 'Read-SQLTableData' so one could import and run it directly in the browser so someday...
The SQL Powershell path provider times out when attempting to remotely access instances running on ports other than 1433. ```ps1 Measure-Command { Get-Item 'SQLSERVER:\SQL\PrimaryServer\DEFAULT' } | Select-Object -ExpandProperty TotalSeconds #...
Run this: ```powershell invoke-sqlcmd -ServerInstance SOMESERVER -query 'select cast(null as rowversion) rv' ``` Result: v21 - System.Data.SqlClient ```console rv -- {} ``` v22 - Microsoft.Data.SqlClient ```console rv -- ``` Both...
Cannot insert new data onto table when a computed column exists, returned below error: The column "A" cannot be modified because it is either a computed column or is the...
It would be beneficial to allow passing an entire and not just the Token. Not that the Invoke-Sqlcmd uses the metadata that comes with the whole AccessToken (like ExpireOn, UserID,...
Current version of the module has a rather fragile logic around "isolation" and "binding redirection". A cmmon problem I faced in v22 is the interaction of the SqlServer module with...
Please consider open sourcing SqlServer module. It would be a great way to build a strong community around it and accelerate its growth and development. Benefits (but not limited to):...
We could consider improving the area that's covered with SQL Server Configuration Manager, (as in https://github.com/microsoft/SQLServerPSModule/issues/4), e.g., add/remove startup parameters (like trace flags etc) and so on. Alternatively, it could...
I see that this repo declares: "This project has adopted the [Microsoft Open Source Code of Conduct](https://opensource.microsoft.com/codeofconduct/)." So, where is the source? There is nothing here that will build anything.
We always deploy a tabular model with module SqlServer using Invoke-ASCmd We have been having troubles deploying with this task Invoke-ASCmd 6 days ago. The pipeline throws an exception that...
