Azure SQL Error Code: 40613 – Azure SQL Database Unavailable
Error Code: 40613 – Azure SQL Database Unavailable Summary Table Aspect Details Error Code 40613 Message “Database is currently unavailable. Please retry later.” Common Causes Maintenance, Failover,…
How to Analyze logs using logs in an Azure storage account
If you choose to write audit logs to an Azure storage account, you can view them in a few ways: For more details on storage folder structure,…
How to Check Aborted Query Details in Azure SQL Database
Below is the Query use to to check aborted query details in Azure SQL Database Query Explanation of Each Part This query retrieves details of the top…
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…
Databricks write back to azure synapse error
Error Code Solution select Storage Blob Data Contributor role select name of manage identity name. Mohammad Gufran Jahangir
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,…
Synapse Analytics Copy Activity Sink dedicated SQL Pool – Failing with SqlClient Data Provider,SqlErrorNumber=105215
Scenario Want to write data into a SQL dedicated pool using a pipeline in Synapse Workspace. In a copy activity I read data from ADLS V2 and…
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…
How to check Azure SQL failed connections?
Query Audit Logs for Failed Logins Using T-SQL Connect to the master database to run below queries: Query the sys.event_log view Query login failures for users The following query…
Common Integration Runtime (IR) registration errors
Here are some common Integration Runtime (IR) registration errors you might encounter when setting up a Self-hosted Integration Runtime (SHIR) in Azure Data Factory, along with their…
How to Set up a Self-hosted Integration Runtime (IR) in Azure
Setting up a Self-hosted Integration Runtime (IR) in Azure is crucial when you need to securely transfer data between on-premises and Azure services or even between different…
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…
Syllabus for learning Databricks Unity Catalog from beginner to advanced levels
Syllabus for Databricks Unity Catalog, organized from beginner to advanced levels: Module Topics Covered Level Introduction to Databricks and Unity Catalog Overview of Databricks PlatformIntroduction to Unity…
How to check root cause analysis of unexpected Azure virtual machine stop
When an Azure Virtual Machine (VM) unexpectedly stops, conducting a root cause analysis (RCA) involves several steps to identify the underlying issue. Here’s a step-by-step guide on…
Azure DevOps – Different Use Case (Part-6)
Artifacts in Azure DevOps can be used in various scenarios to facilitate different aspects of the CI/CD pipeline. Here are some additional use cases that demonstrate the…