Category "sql-server-data-tools"

T-SQL C# CLR Execute permissions being lost on assemblies when are redeployed

I have inherited a VS2015 .NET C# project that deploys C# assemblies as CLR stored procedures to SQL Server 2016. It has worked seamlessly for many years. Howev

SSIS packages not showing in Upgrade Wizard Visual Studio 2019

I am having an issue upgrading our existing 2017 SSIS packages to 2019 . I have updated the target server version in the package settings and we have installed

Execution Timeout Expired error during DACPAC (SSDT) publish using DacServices.Deploy

We're randomly getting the below error when publishing a dacpac using DacServices.Deploy in C#. Along with tables, the Dacpac also has a post-deployment script