Recent Blogs
This week we have been working on a support case where our customer had the following message 50006: Error the database type is not understood by the data reader when exporting using SQL Server Manag...
Oct 02, 202531Views
0likes
0Comments
Environment Overview
Recently, I worked on a case where our customer encountered an issue during the deployment of an Elastic Job Agent (EJA) and a Private Endpoint (PEP) using a Bicep deployment ...
Sep 30, 2025109Views
1like
0Comments
The Azure SQL Auditing feature is used to track database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs.
For those who are interest...
Sep 30, 202550Views
0likes
0Comments
This post explores a collation mismatch error during offline migration from SQL Server Express to Azure SQL. It identifies the root cause—AUTO_CLOSE being enabled—and offers a simple fix to ensure sm...
Sep 29, 202590Views
0likes
0Comments
2 MIN READ
We recently worked on a support case where a customer was trying to import a BACPAC file, generated on a different server and subscription, into their Azure SQL Database. The process kept failing wit...
Sep 19, 2025109Views
0likes
0Comments
Managed Instance diagnostic events do not support sending deadlock information to Log Analytics. However, through auditing, it's possible to query failed queries along with their reported error messa...
Sep 12, 2025296Views
0likes
1Comment
In this blog article, we will cover how we can use customer Azure policy to prevent users from changing the Azure SQL database connections policy.
Azure SQL database has three options for the c...
Sep 11, 2025207Views
2likes
0Comments
1-Requirements
2-Considerations
3-Update statistics
4-Rebuild indexes
5-Missing indexes
6-More information
Requirements
Azure SQL Database
SQL Server Management Studio (SSMS)
...
Aug 07, 2025321Views
1like
0Comments
1 MIN READ
We worked on a service request that our customer trying to enable their Python application, hosted on Azure App Service, to connect securely to Azure SQL Database using a user-assigned managed identi...
Aug 01, 2025158Views
0likes
0Comments
2 MIN READ
While working on a recent service request, we helped a customer troubleshoot intermittent connection and authentication failures when accessing Azure SQL Database using Active Directory (Entra ID) au...
Aug 01, 2025192Views
1like
1Comment
Resources
Tags
- azure sql database151 Topics
- azure sql55 Topics
- Azure SQL DB55 Topics
- performance54 Topics
- Connectivity46 Topics
- azure sql managed instance22 Topics
- azure20 Topics
- bacpac16 Topics
- powershell15 Topics
- sql14 Topics