How to Migrate SSISDB to Another SQL Server
Learn how to migrate SSISDB to another SQL Server using native backup and restore or the SSIS Catalog Migration Wizard, including master keys, catalog objects, environment values, validation, and repeatable migrations.
How to Test RLS in Power BI Service: Test as Role and User Context
Learn how to test Power BI row-level security in the Power BI Service using Test as role, Now viewing as, and practical checks for dynamic RLS.
ClickOnce does not support the request execution level ‘requireAdministrator’
ClickOnce does not support the request execution level requireAdministrator. However, we have a workaround to fix this problem. This article describes how to achieve it.
Connect Azure SQL from Data Factory using Managed Identity
Learn how to connect Azure Data Factory to Azure SQL Database using managed identity and Microsoft Entra authentication, with step-by-step permissions and linked service configuration.
Databricks Certified Data Engineer Associate
In this post, We have documented how to conquer the Databricks Certified Data Engineer Associate certification in this article. Databricks has introduced the Data Engineering Associate exam which consists of 45 multiple-choice questions. The time slot allocated is 1.30 hr. The passing score is 32 which is 70%. High-level topics with their weightage in the exam are:
Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection
Quick answer: The AADSTS900021 error with an empty tenant GUID can occur when Microsoft Entra authentication is used against an Azure SQL logical server without
Print Kafka Topic Messages Using ksqlDB
Learn how to inspect Kafka topic messages with the ksqlDB PRINT statement, including reading from the beginning, limiting output, and sampling messages.
SSAS Tabular vs Multidimensional: Key Differences and When to Use Each
There are 2 types of Analysis Services models available; the Multidimensional model and the Tabular model. While both these models have their own significance, here is a quick comparison between SSAS Tabular vs Multidimensional model
Export SSIS project from SQL Server
In this article, I will describe how to export SSIS projects from SQL Server in bulk using SSIS Catalog Migration Wizard in just a few clicks.
Recover Deleted Key Vault in Azure
Have you accidentally deleted Key Vault from the resource group? In this article, we will see how to recover deleted key vault in Azure using the Azure Az PowerShell cmdlet.
Filter a Kafka Stream by Date Using ksqlDB
Learn how to filter Kafka stream records by date in ksqlDB using ROWTIME, TIMESTAMPTOSTRING, and the auto.offset.reset setting.
Top 5 Azure Data Studio Extensions in 2025: What to Use After Retirement
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.