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.
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
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
Print Kafka Topic Messages using KSQL
Confluent Platform is a full-scale data streaming managed cloud service that enables us to access, store, and manage data as a continuous, real-time stream. This quick article describes how to Print Kafka topic messages in Confluent.
SSAS Tabular vs Multidimensional model
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 KSQL
Confluent Platform is a full-scale data streaming managed cloud service that enables us to access, store, and manage data as a continuous, real-time stream. Confluent Cloud provides ksqlDB, a streaming SQL engine for Kafka. It is an easy-to-use yet powerful interactive SQL interface for stream processing on Kafka, In this article, we will see how to filter a Kafka stream based on the date using ksql,
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.
Databricks Secret Scopes – How to Create, Manage, and Use Securely
Databricks platform is used to connect to multiple applications. Databricks requires credentials or secrets to connect to these applications. Databricks or Azure Key Vault can store these secrets securely. Secret scopes are used to manage the secrets which are stored in Azure Key Vault or Databricks.
The Certificate Chain was Issued by an Authority that is not Trusted
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server). The certificate chain was issued by an authority that is not trusted
Copy SSIS Environment variables to another server
Launch SSIS Catalog Migration Wizard from your installed location and follow the below simple steps to migrate SSIS environment variables from one SQL server to another.