What is Difference between Azure activity ,Azure diagnostics and Azure metrics logs
Here’s a comprehensive explanation of the differences between Azure Activity Log, Azure Diagnostics Logs, and Azure Metrics for Azure SQL Database auditing, with examples and insights: Azure…
What is Diagnostic settings in Azure Monitor?
This Blog will give information about creating and configuring diagnostic settings to send Azure platform metrics and logs to different destinations. Platform logs provide detailed diagnostic and…
How to Use Auditing to analyze audit logs and reports
Analyzing audit logs using Auditing for Azure SQL Database and Azure Synapse Analytics. You can use Auditing to analyze audit logs stored in: How to Analyze logs using…
Different ways to Auditing Azure SQL Database and Azure Synapse Analytics
The default auditing policy includes the following set of action groups, which audits all the queries and stored procedures executed against the database, as well as successful…
Type of Indexes on dedicated SQL pool tables in Azure Synapse Analytics
Below are the types of Indexes on dedicated SQL pool tables in Azure Synapse Analytics 1. Clustered Columnstore Indexes (CCI): There are a few scenarios where clustered…
Table Constraints in Dedicated SQL pool in Azure Synapse Analytics
Table constraints Dedicated SQL pool supports these table constraints: Note : FOREIGN KEY constraint is not supported in dedicated SQL pool. Having primary key and/or unique key…
Distributed tables using dedicated SQL pool in Azure Synapse Analytics
A distributed table appears as a single table, but the rows are actually stored across 60 distributions. The rows are distributed with a hash or round-robin algorithm….
Dedicated SQL pool (formerly SQL DW) architecture in Azure Synapse Analytics
Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your…
What is dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics?
Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and Big Data analytics. In simple words, Imagine you’re running a store. You’ve got…
How to Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks
Azure Data Lake Storage Gen2 (ADLS Gen2) is a highly scalable and secure storage solution for big data in Azure. Integrating it with Azure Databricks unlocks powerful…
How to Use Azure Databricks to Query Azure SQL Database
Azure Databricks provides a powerful platform for data analysis and processing, and connecting it to Azure SQL Database unlocks valuable insights from your relational data. Here’s a…
How to Manage Secrets in Azure Databricks Using Azure Key Vault
Securing sensitive data like passwords and API keys is crucial in Azure Databricks. Azure Key Vault offers a centralized and secure solution for managing such secrets. Here’s…
Basic Concept to Start with Azure Databricks
In this lesson will give go step by step concept building for Azure Databricks and spark. Prerequisite for Azure Databricks Technical Skills: Access and Permissions: Software and…
Query to get list of Schema and table name in Azure SQL database
The query below lists all tables in an Azure SQL Database. Columns Rows Sample results Mohammad Gufran Jahangir
What is Azure SSIS and its Use cases?
What is Azure SSIS? Azure SQL Server Integration Services (SSIS) is a cloud-based data integration service that enables you to move data between Azure and on-premises data…
ADF pipeline Failed with error 2407 code for ADLS file copy.
If Azure data factory (ADF) pipeline failed with error 2407 for Azure data lake storage (ADLS) Data file Error code 2407 – https://go.microsoft.com/fwlink/?linkid=2112593 Error Details Input Payload…
Azure Databricks Tutorial: How to create notebook and Query the Data in different way Part 5
Creating a notebook in Azure Databricks and querying data in multiple ways using SQL and Python. Creating a Notebook: Step-by-Step Guide: Querying Data in Different Ways: 1….
Different levels or types of branches in Azure DevOps in Simple words
In this context, these branches likely represent different levels or types of branches within a branching strategy: The branch hierarchy in Azure DevOps with examples Main/Branch: Collaboration…