Azure Synapse Analytics
-
How to correct Columnstore index in dedicated SQL pool?
Two major factors affect the quality of a CCI: Step 1: Analyze a summary of your CCI health From the…
-
Memory Usage in Azure synapse dedicated SQL pool
Query to check which User consuming more memory Usage Azure synapse dedicated SQL pool using SSMS If want to exclude…
-
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, explained with examples: 1. Encapsulation…
-
External tables supported in Azure Synapse Analytics
An overview of the external table types supported in Azure Synapse Analytics Hadoop-Based External Tables: Native External Tables (Preview): Key…
-
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. Create an External Data Source:…
-
Different ways to limit access for the users on different schemas in Azure synapse Analytics
1. User-Defined Schemas: 2. Row-Level Security (RLS): 3. Server-Level Roles: 4. Credentials and External Users: 5. Dynamic Data Masking (DDM):…
-
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 can create a new alert…
-
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 Log Analytics, Azure Sentinel, and…
-
Azure SQL Database audit log format
Azure SQL Database auditing tracks database events and writes them to an audit log in your Azure storage account, or…
-
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…
-
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…
-
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…
-
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…
-
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):…
-
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…
-
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…
-
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…
-
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,…
Follow Us
Recent Posts
- Primary key constraint with a Clustered index and a regular Clustered index in Azure SQL Database
- What is a Partitioned Table on Multiple Filegroups in Azure SQL Database?
- Modification of a partition function to add more partitions or change existing boundaries in Azure SQL Database
- How to Add Partitioning to an Existing Table in Azure SQL Database
- Explanation of “Unsupported Operations” in Azure SQL Database Partitioning
Categories
- Amperity 1
- Ansible 15
- Ataccama 1
- AWS 3
- Azure 122
- Azure Databricks 26
- Azure DevOps 7
- Azure Fundamental 13
- AZURE SQL SERVER 63
- Azure Synapse Analytics 18
- bash scripting 1
- CloudOps 9
- CrowdStrike 1
- DevOps 1
- DevSecOps 1
- Docker 3
- Git and GutHub 15
- Google BigQuery 1
- Linux 12
- Microsoft Fabric 20
- MLOps 1
- MotoShare 7
- Oracle GoldenGate 1
- php 4
- powershell 1
- Python 21
- SFTP Server 1
- SRE 2
- Teradata 1
- terraform 20
- ubuntu 2
- Uncategorized 50
- virtual machine 1
- WakilSahab 1
Tags
AZ Modules in Power shell Azure Bastian Azure Databricks Azure SQL Database Azure SQL Database Partitioning Azure SQL Error Code: 10928 – Resource Limit Exceeded Common errors encounter for applications in Linux Common Integration Runtime (IR) registration errors Customer fastload jobs are failing with error 2825 at Teradata Different levels or types of branches in Azure DevOps Different ways to load data into Microsoft Fabric Lakehouse Error Code 49918 Error Code: 258 Error Code: 40197 Error Code: 45168 – Geo-Replication Error Git Checkout Git Log Explanation How Default Ansible Variables Work How do you ensure high availability and disaster recovery in cloud environments? How to correct Columnstore index in dedicated SQL pool? How to push/pull and clone files between Local machine and GitHub How to set an environment variable for installing PHP via XAMPP on Ubuntu How to upload sql file to database using PhpMyAdmin in Xampp Linux Interview questions that are commonly asked in interviews Memory Usage in Azure synapse dedicated SQL pool Microsoft Fabric MotoShare Terraform Workspace Types of errors encounter in virtual machine (VM) in Linux Workflow – How Git work