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 access from an…
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 named replica separate…
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, then create an…
The error message you are encountering is a login timeout issue when trying to connect to the EDH_DEV database using the ODBC Driver 18 for SQL Server from your on-premises…
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 on-premises SQL Server…
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 1 : Scenario-based…
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 are designed to…
o provide permission for SHOWPLAN access in an Azure SQL Database, you’ll need to follow these steps. SHOWPLAN allows users to view the execution plans of queries, which is useful…
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 the query provide…
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: 4. Transactions: 5.…
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: Hadoop Native …
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. Create an External…
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
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:…