Yesterday (Friday 22) I had major connectivity issues with SQL Managed Instances. I found nothing in forums, logs, or anywhere else, so I still don’t know what happened but it caused problems in our environment. Any tips for more precise troubleshooting would be welcome. It was really painful.
#azure #mssql #sqlazure #microsoft

#sqlAzure today I opened a ticket because the Azure DMVCollector app runs a query for memory-optimized tables, and it uses dynamic SQL but the query has an extra single-quote, so it breaks. Probably been there for years. If you run an Extended Event looking for error_reported, severity>10, you can see it.