We had a long conversation about the strategy and direction of the organization and how the organizations can go to the next level by leveraging the Cloud.
SQL SERVER – Adding Default Value to Existing Table
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.Â
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.Â
SQL SERVER – Network Protocol and IP Address
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.