Grant Access to Azure SQL Database
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 »
SQL Database
Create DACPAC from SQL Server Database
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 »
Connect Azure SQL from Data Factory using Managed Identity
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 »
Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection
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
Top 5 Azure Data Studio Extensions in 2025 [Updated]
Azure Data Studio is an open-source data management tool that enables working with SQL Server, Azure SQL DB, and Azure Synapse from Windows, macOS, and Linux. It is a one-stop shop to query, design, and manage your databases and data warehouses, on-premise or in the cloud. In this article, we will see 5 most interesting features of Azure Data Studio for SQL developers.
Top 5 Azure Data Studio Extensions in 2025 [Updated] Read More »
Get local date in Azure SQL database
This article describes how to get local time zone date in Azure SQL database using an user defined scaler function and AT TiME ZONE.
Get local date in Azure SQL database Read More »
Automating Azure SQL Database Maintenance Tasks
Automate Azure SQL Database index and statistics maintenance tasks using the Azure Elastic Job agent.
Automating Azure SQL Database Maintenance Tasks Read More »