Lesson Learned #199:Collect data for performance comparison Azure SQL Managed Instance vs SQL Server

Today, I worked on a customer service request that they are comparing workload between Azure SQL Managed Instance and SQL Server. Our customer identified some performances issues and we provided this PowerShell Script. to collect some basic information… Continue reading Lesson Learned #199:Collect data for performance comparison Azure SQL Managed Instance vs SQL Server

Enabling Full-stack Observability with Azure Monitor and Grafana

Along with the announcement of Azure Managed Grafana, we are excited to introduce new Grafana integrations with Azure Monitor including the ability to pin Azure Monitor visualizations from Azure Portal to Grafana dashboards and new out-of-the-box Azure… Continue reading Enabling Full-stack Observability with Azure Monitor and Grafana

Lesson Learned #198: Getting the error “has an unresolved reference to object ” exporting to bacpac

When you are exporting a bacpac you could face the following error message: “Error SQL71562: Error validating element [dbo].[StoredProcedureNameExample]: Procedure: [dbo].[StoredProcedureNameExample] has an unresolved reference to object [DbNameExample… Continue reading Lesson Learned #198: Getting the error “has an unresolved reference to object ” exporting to bacpac