Error Code: 40544 – Database Size Limit Exceeded
Background Error code 40544 occurs when an Azure SQL Database exceeds its allocated data space limit. Each service tier and pricing model in Azure SQL Database comes with a specific…
Error Code: 18456 – Login Failed for User
Background Error 18456 is a common error encountered in SQL Server, including Azure SQL Database, which indicates that a login attempt has failed due to invalid authentication credentials or insufficient…
Error Code: 40532 – Azure SQL Database Max Session Limit Reached
Background Error code 40532 occurs when the maximum session limit for your Azure SQL Database or elastic pool is reached. Azure SQL enforces a limit on the number of concurrent…
Azure SQL Error Code: 10928 – Resource Limit Exceeded
Error Code: 10928 – Resource Limit Exceeded Summary Table Aspect Details Error Code 10928 Message “The request limit for the elastic pool or database has been reached.” Common Causes Too…
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, High Load, Provisioning…
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, naming, and log…
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 50 aborted queries…
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 access from an…
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 named replica separate…
Azure SQL Database idle sessions are terminated after 30 minutes with the ‘Proxy’ connection policy
When we connect to Azure SQL Databases or Managed Instances using the “Proxy” connection policy, idle sessions are closed after 30 minutes of inactivity. However, with the “Redirect” policy, idle…
Datastage ODBC connector stage throws error, SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Socket closed.
Problem Datastage jobs are failing when running a query against the Azure SQL Server database with the error: SQLSTATE = 08S01, Native Error Code = 0, Message = [IBM(DataDirect OEM)][ODBC…
Customer fastload jobs are failing with error 2825 at Teradata
Below Issue occurring when User running fastload jobs from DataStage end against Teradata What is cause for this Issue? Network glitch happened while fastload operation was underway. Solution for this error Resubmit the failed fastload job. If the issue…
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, then create an…
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 write into the…
Azure Data Lake Storage Gen2 (ADLS Gen2), with a specific message stating that the lease is not present
The error you’re encountering is on the Sink side when trying to perform an operation on Azure Data Lake Storage Gen2 (ADLS Gen2), with a specific message stating that the…
Login Timeout issue when trying to connect Azure SQL database from on-premises Microservice GG system
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…
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 on-premises SQL Server…
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 returns connection failures…
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 types and potential…