During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica
In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.
Database Diagram – Available Again in SQL Server Management Studio 18.1 Onwards
Database Diagram was one of the most popular features of SQL Server Management Studio (SSMS). This feature was available in SSMS till version 17.9.
SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip
Presenting on a small laptop screen? SSMS splits the query and execution plans 50-50 by default, so here is a quick tip to maximize the plan on screen.
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
How do you execute a query in SSMS without F5 or the Query Toolbar? An attendee in a private training asked for a unique way, and here is a less known method.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
A script I use in every Health Check: get the compiled plan with parameters from cache, so you can see what values the plan was built for.
SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio
A reader asked about the difference between Azure Data Studio and SQL Server Management Studio. Here is how the two compare, component by component.