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.
SQL SERVER – Restore Database With Just Log File
Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. It is not possible.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention Changing Primary Key to Non-Clustered
You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.