Category: AZURE SQL SERVER

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…

Query to get list of Schema and table name in Azure SQL database

The query below lists all tables in an Azure SQL Database. select schema_name(t.schema_id) as schema_name,…

Direct access and access through Azure Active Directory (AD) groups – Azure SQL Database

Direct Access to User Direct User Mapping: Granting direct access involves assigning specific permissions directly…

How to Get SQL Server database transaction log usage?

What is transaction log in SQL Server? In SQL Server, the transaction log is a…

What is SQL Server Statistics and how to Collect/Update Statistics in SQL Server Database.

In Azure SQL Server, statistics are database objects that contain information about the distribution of…

Query session status runnable, sleeping, suspended, running and background meanings in SQL server Database

In SQL Server, when you query the session status, you can encounter various states that…

Troubleshooting Connectivity issues & Timeout error [258]. Unable to complete login process due to delay in prelogin response/ Pre-Login Handshake Failed

If trying to connect Azure SQL Server database and getting below Error: Error Error: Microsoft…

What is fragmentation in Azure SQL Server? How to check fragmentation for table? How to rebuilt table to reduce fragmentation?

What is fragmentation in Azure SQL server? Fragmentation in Azure SQL Server, or any SQL…