SQL Server

Transferring Sensitive Data During SSIS Catalog Migrations to Another Server

Migrating your SQL Server Integration Services (SSIS) Catalog to a new server or instance is a common administrative task, but it often brings with it a significant challenge: the secure handling of sensitive data. Packages within the SSIS Catalog frequently contain connection managers with sensitive information like database credentials, API keys, or other confidential parameters. […]

Transferring Sensitive Data During SSIS Catalog Migrations to Another Server Read More »

Cross Database Query in Azure SQL Database

In modern cloud architectures, it’s common to distribute data across multiple Azure SQL Databases. While this promotes modularity and scalability, it can pose challenges when you need to access data across these databases. Fortunately, Azure SQL’s external tables feature allows for seamless cross-database querying without data duplication. This feature is also known as Elastic Query

Cross Database Query in Azure SQL Database Read More »

A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12.

While deploying a DACPAC project to Azure SQL Database using Azure DevOps, you may encounter an error due to specifying SQL Server 2022 as the target platform. The article provides steps to fix this issue by changing the target platform to ‘Microsoft Azure SQL Database’ in Visual Studio and rebuilding the project.

A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12. Read More »

An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS

Error An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:System.IO.FileLoadException: Could not

An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS Read More »

Shopping Cart
Scroll to Top