Azure Archives - Page 3 of 5

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 »

Kafka Streaming vs Spark Streaming

Confluent, Databricks

Kafka Streams and Spark Streams are potent tools for real-time processing, Here are the key differences Kafka Streaming vs Spark Streaming.

Kafka Streaming vs Spark Streaming Read More »

Connect Azure SQL from Data Factory using Managed Identity

Azure, Data Factory, SQL Database

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 »

Databricks Certified Data Engineer Associate

Certification, Databricks

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:

Databricks Certified Data Engineer Associate Read More »

Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection

Azure, SQL Database

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

Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection Read More »

SSAS Tabular vs Multidimensional model

Analysis Services, SSAS

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

SSAS Tabular vs Multidimensional model Read More »

Recover Deleted Key Vault in Azure

Azure, Key Vault

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.

Recover Deleted Key Vault in Azure Read More »

Top 5 Azure Data Studio Extensions in 2023

Azure, SQL Database, SQL Server

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 2023 Read More »

Manage Secret Scopes in Databricks

Azure, Databricks, Key Vault

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.

Manage Secret Scopes in Databricks Read More »

Mount and Unmount Data Lake in Databricks

Azure, Data Lake, Databricks

Mounting object storage to Databricks fie system allows easy access to object storage as if they were on the local file system. In this article, we will see how to mount and unmount data lake in Databricks.

Mount and Unmount Data Lake in Databricks Read More »

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.