Query to Retrieve User Access Details from Azure SQL Database Using Log Analytics
To Retrieve User Access Details from Azure SQL Database Using Log Analytics for last one Month. Pre requisites the prerequisites for running a query to retrieve user…
How to allow Access Hyperscale named replicas Database and Restrict on Primary Hyperscale Database
How to give access to an Azure SQL Database Hyperscale named replica without giving access to the main replica or any other replicas. This setup keeps the…
External table in Azure SQL Database that accesses data across different databases
To create an external table in Azure SQL Database that accesses data across different databases, you need to first establish a “database scoped credential” on the target database,…
How To check the time zone in Azure SQL Server
In Azure SQL Server, the time zone is generally set to UTC (Coordinated Universal Time), and it cannot be changed at the server or database level like…
Azure SQL Server Database Administration Role Interview Question and Answer
Here is a list of Azure SQL Server Database administration interview questions and answers, organized from basic to advanced levels: Basic Level Intermediate Level Advanced Level Part…
Azure SQL Server Database Interview Question and Answer
Here is a list of Azure SQL Server Database interview questions and answers, organized from basic to advanced levels: Basic Level Intermediate Level Advanced Level cenario-based questions…
Query to check Statistics of tables in an Azure SQL Server database
To include the schema in the query to check statistics on a table in Azure SQL Server, you can modify the query as follows: The columns in…
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 and Reusability: 2. Parameterization: 3. Error Handling:…
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 Differences: Choosing the Right Type: Additional Considerations:…
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: 2. Create an External File Format: 3….
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): Additional Considerations: Mohammad Gufran Jahangir
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 rule. Create or edit an alert rule…
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 more. Here’s a comprehensive guide on using…
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 sends them to Event Hub or Log…
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…