In this blog post, we’ll delve into the step-by-step guide of how to implement Azure SQL database Deployment CI CD pipeline using Azure DevOps.
Implement Azure SQL Database Deployment CI CD pipeline Read More »
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 »
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 »
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 »
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 »
The server principal is not able to access the database “master” under the current security context.
This article describes how to Grant Access to Azure SQL Database for SQL Server users, Azure AD user, and managed identity.
Grant Access to Azure SQL Database Read More »
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is because Azure SQL database does not support regular SQL Server backups (.bak) files for restorations and requires a separate type of backup file called BAKPAC – Data-Tier Application Export (.bacpac file). Moreover, to create a BACPAC file, you must first create a DACPAC file to ensure that your database is ready for a BACPAC export. This article will show how to take a DACPAC extract of an on-premise SQL Server database.
Create DACPAC from SQL Server Database Read More »
Azure Data Factory is a Microsoft cloud ETL service for serverless data integrations and orchestrations. It supports a lot of source and target connectors including Azure SQL database. I will describe how to connect to Azure SQL from data factory using Managed Identity.
Connect Azure SQL from Data Factory using Managed Identity Read More »
Error AADSTS900021: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection. Cause SQL Server Management Studio can establish the connection to the SQL Server database using Azure Active Directory – Universal with MFA. This is because the Azure Active Directory user trying to log in to
