1. User-Defined Schemas: 2. Row-Level Security (RLS): 3. Server-Level Roles: 4. Credentials and External Users: 5. Dynamic Data Masking (DDM): Additional Considerations:
Accessing the alert rule wizard in the Azure portal There are several ways that you can create a new alert rule. Create or edit an alert rule from the portal…
Kusto Query Language (KQL) is used to write queries in Azure Data Explorer, Azure Monitor Log Analytics, Azure Sentinel, and more. Here’s a comprehensive guide on using KQL (Kusto Query…
Azure SQL Database auditing tracks database events and writes them to an audit log in your Azure storage account, or sends them to Event Hub or Log Analytics for downstream…
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 Activity Log Azure…
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 auditing information for…
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 Log Analytics If…
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 and failed logins:…
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 columnstore may not…
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 allows dedicated SQL…
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. When Synapse SQL…
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 terms. Dedicated SQL…
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 a huge storage…
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 data processing capabilities.…
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 step-by-step guide to…
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 a step-by-step guide…
Spark SQL is a powerful tool within Azure Databricks for querying and analyzing large-scale datasets using SQL-like syntax. It integrates seamlessly with the Spark ecosystem, enabling efficient data processing and…
Using DataFrame columns in Azure Databricks offers various operations for data manipulation. How to use DataFrame column in different way in Azure Databrick Using DataFrame columns in Azure Databricks offers…
In this tutorial we will learn in depth about DataFrame API in databrick What is schema of DataFrame? In Databricks, a DataFrame is a distributed collection of data organized into…
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 Tools: Example: Imagine…