Deploy DACPAC to Azure SQL Database
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
SQL Server 2025 Preview Announced
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
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 »
CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server
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 »
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.
Transaction Batching in 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
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
Open DACPAC File in Visual Studio
DACPAC file can be used to deploy database code using CICD tools like Azure DevOps. Learn how to open DACPAC file in Visual Studio.
Open DACPAC File in Visual Studio Read More »
Find Stored Procedures related to Table in SQL Server
This guide will help you find SP related to table in the SQL Server database or Azure SQL database using client tools like SSMS.
Find Stored Procedures related to Table in SQL Server Read More »
Find deadlock in SQL Server
A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. This article describes how to find deadlock in SQL Server database.
Find deadlock in SQL Server Read More »