SQL Server Archives

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 »

Migrate SSRS Reports to a New Server in just a few clicks

Microsoft BI, SQL Server, SSRS

In this guide, we’ll walk through the ssrs report migration process and share best practices to avoid common pitfalls.

Migrate SSRS Reports to a New Server in just a few clicks Read More »

Cross Database Query in Azure SQL Database

Azure, SQL Database, SQL Server

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 »

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server

Microsoft BI, SQL Server, SSIS

How to resolve error : CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server.

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server Read More »

Deploy DACPAC to Azure SQL Database

Azure, DevOps, SQL Database, SQL Server

This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.

Deploy DACPAC to Azure SQL Database Read More »

SQL Server 2025 Preview Announced

SQL Server

Microsoft has announced SQL Server 2025 preview, marking a significant advancement in database technology by integrating AI capabilities

SQL Server 2025 Preview Announced Read More »

Parse JSON in SQL Server

Azure, SQL Database, SQL Server

JSON (JavaScript Object Notation) is a lightweight data-interchange format that has become a standard for data exchange in web and database applications. With the rise of JSON’s popularity, SQL Server introduced built-in support for JSON starting with SQL Server 2016. In this article, we will explore how to parse JSON in SQL Server and extract

Parse JSON in SQL Server 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.

Azure, DevOps, SQL Database, SQL Server

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 »

Transaction Batching in SQL Server

Azure, SQL Database, SQL Server

This post explores the concept of transaction batching in SQL Server as a solution to efficiently manage resources and avoid unnecessary rollbacks.

Transaction Batching in SQL Server Read More »

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

Microsoft BI, SQL Server, 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 »

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.