SQLCanuck

Results 9 comments of SQLCanuck

Having the horrible performance issues now as well. Given this is backed by Microsoft, is this not using Azure auto scale features to avoid such problems???

Ideally it would be a resource. So could do something like the following in DSC to create an Integration Services Catalog. SqlIntegrationServicesCatalog 'SSISDB' { ServerName = 'localhost' InstanceName = 'MSSQLSERVER'...

For now I am utilizing the Microsoft documented commands in a Script Task. Though oddly fails for SQL 2022, but works for all other versions of SQL which I have...

Ran into the same issue as well. "Couldn't import /root/.local/share/powershell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.Data.SqlClient.dll | Assembly with same name is already loaded."

For now I was able to work around by using one of the following methods. https://learn.microsoft.com/en-us/powershell/scripting/dev-cross-plat/resolving-dependency-conflicts?view=powershell-7.4#use-the-dependency-out-of-process Though hopefully someone will be able to implement one of the more permanent and...

> Hi, I think you're supposed to use azure-cli 2.64.0 with collection currently > > [azure/requirements.txt](https://github.com/ansible-collections/azure/blob/4a656c6f8151fca3f6a914a25cbb6601c28eaea2/requirements.txt#L5) > > Line 5 in [4a656c6](/ansible-collections/azure/commit/4a656c6f8151fca3f6a914a25cbb6601c28eaea2) > azure-cli-core==2.64.0 Would be nice if this project...

The following message also may get returned. WARNING: [15:08:13][New-DbaSsisCatalog] Can't load server | Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version =16.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The...

Personally, I feel some sort of automation for the FunctionsToExport is necessary. Be it by the above proposed solution or some variant. As the purpose of having the Public directory,...

> * version locking to specific MS Azure CLI releases If the version locking to Azure CLI releases was done, it may make sense to follow the LTS releases. The...