The question was if there is a way to know how many sessions are connected to current SQL Server instance with their network protocol as well as IP address.
SQL SERVER – User Statistics Report for Database – SSMS
Once we isolate the user, it was easier for us to get the performance back to the original level. Learn about User Statistics Report for Database – SSMS.
SQL SERVER – Open SSMS from Command Prompt
Recently one of my clients asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.
Azure Data Studio – Explain SQL Server Execution Plan
The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio. Comprehensive Database Performance Health Check.
Azure Data Studio- Export Any SQL SERVER Query As JSON
Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.
Why SQL Server Doesn’t Give the Memory Back to OS?
Today’s post is written by SQL Server Expert Brian Gale. Why SQL Server Doesn’t Give the Memory Back to OS? Let us learn an amazing concept.
SQL SERVER – How to Order By a Parameter?
We figured out that there was a very poor code written in one of the Stored Procedure’s Order By clause. Let us learn today how to order by a parameter.