Category: Azure

Best Practice of Stored procedures using Synapse SQL in Azure Synapse Analytics?

Here are best practices for using stored procedures with Synapse SQL in Azure Synapse Analytics,…

External tables supported in Azure Synapse Analytics

An overview of the external table types supported in Azure Synapse Analytics Hadoop-Based External Tables:…

External tables using SQL pools in Azure Synapse Analytics

Here's a guide on using external tables with SQL pools in Azure Synapse Analytics 1.…

Different ways to limit access for the users on different schemas in Azure synapse Analytics

1. User-Defined Schemas: Create Schemas: Organize tables and objects into distinct schemas to logically separate data.…

How to Create or edit a log alert rule from Azure Monitor

Accessing the alert rule wizard in the Azure portal There are several ways that you…

What is Kusto Query Language (KQL) and How to Use KQL to Query Audit Log

Kusto Query Language (KQL) is used to write queries in Azure Data Explorer, Azure Monitor…

Azure SQL Database audit log format

Azure SQL Database auditing tracks database events and writes them to an audit log in…

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…

What is Diagnostic settings in Azure Monitor?

¬†This Blog will give information about creating and configuring diagnostic settings to send Azure platform…

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…

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…

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…

Table Constraints in Dedicated SQL pool in Azure Synapse Analytics

Table constraints Dedicated SQL pool supports these table constraints: PRIMARY KEY is only supported when…

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…

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…

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…

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…

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…

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…

Basic Concept to Start with Azure Databricks

In this lesson will give go step by step concept building for Azure Databricks and…