Tag: sql-server-rds

Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instance

By Kendra Little on October 8, 2025

Category: azure-sql , sql-server-rds , sql-server

While every managed database service has high points and low points, there are three things that make RDS for SQL Server shine in comparison to Azure SQL Managed Instance: options for a higher memory:vCPU ratio, a well documented API that works beautifully with python, and fast and effective customer support that isn’t painful to use.

It’s just three things, but they make a huge difference. And these are three things that Microsoft can, and SHOULD, really fix for their cloud database services.

Script to Automate Unforcing Failed Forced Plans in Query Store (SQL Server)

By Kendra Little on September 2, 2024

Category: query-performance , sql-server , azure-sql

Tags: query-store , plan-forcing , automatic-plan-correction , azure-sql-managed-instance , sql-server-rds , pass-summit

tldr; I’ve published a script to loop through all databases on an instance, identify if there are any query plans in a problematic ‘failed" forced state (which can hurt query performance), and un-force them if found. Get the dbo.dba_QueryStoreUnforceFailed stored procedure on GitHub.

This script is designed to work on SQL Server on-prem, in a VM, or in Azure SQL Managed Instance or SQL Server RDS. Since the script is instance-level and loops through all databases, this isn’t really designed for Azure SQL Database – and you don’t get a SQL Agent there anyway, so you probably want to change this around for that use case. The script is shared under the MIT license, feel free to contribute code and/or adapt away for your own uses.

Sql-Server-Rds

Tag: sql-server-rds

Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instance

Script to Automate Unforcing Failed Forced Plans in Query Store (SQL Server)