Opinions, tips, and news orbiting Microsoft
Recently some customers faced the error below when trying to access SQL Managed Database properties (right-click on database and select properties), they got the following error:
TITLE: Microsoft SQL Server Management Studio
————… Continue reading Subquery returned more than 1 value when open Azure Managed Instance Database properties
In several situations we found that our customer reported that their query is taking too much time to execute, but, it is important to determine what is the phase of the TSQL query execution is taking time.
It is important to explain… Continue reading Lesson Learned #286: Compilation vs Execution time running a TSQL query
Some days ago, we received a question from a customer that has a firewall rule on from selected networks on the Azure SQL Server and they found when they use telnet to connect to servername.database.windows.net on port 1433 from other locations that ar… Continue reading Lesson Learned #285: Why can I still telnet to port 1433?
We got an issue that our customer is migrating a WIN32 C++ application from on-prem to Azure. When connecting to Azure they got the following error message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Error requesting access to… Continue reading Lesson Learned #284:Error requesting access token,HTTP status 400,expected 200.SQL State was: CE275
Our customer was unable to import a bacpac file from Azure blob storage via portal, failing with error: “Import operation interrupted because insufficient local disk is available for bacpac file. Please use SSMS or SqlPackage to complete the operation…. Continue reading Lesson Learned #283: Import operation interrupted because insufficient local disk
This time our customer was running into the following error message when attempting to perform an export to a bacpac file “One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: Error validat… Continue reading Lesson Learned #282: Troubleshooting the element cannot be deployed as the script body is encrypted
Today, I worked on a service request that is related with our previous article Lesson Learned #276: ALTER TABLE statement conflicted with the CHECK constraint importing a bacpac – Microsoft Community Hub
But, in this situation, is related a… Continue reading Lesson Learned #281: Troubleshooting CHECK constraint issue importing a bacpac due to business logic
On January 13th, Windows Security and Microsoft Defender for Endpoint customers may have experienced a series of false positive detections for the Attack Surface Reduction (ASR) rule “Block Win32 API calls from Office macro” after updating to security … Continue reading Recovering from Attack Surface Reduction rule shortcut deletions