However, recently my client was working from home and he was not able to access the SQL Azure database. Let us learn how we can and IP Address to Access.
How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285
Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?
Answer: Actually, I got this question from my client.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Today we are going to discuss how we can change the configuration value of the Boost SQL Server Priority with SSMS version 18 onwards.Â
Identify Index Used for Query – SQL in Sixty Seconds #088
Let us see in today’s SQL in Sixty Seconds video how one can identify the index used for the query a popular question asked in Health Check.
SQL SERVER – 3 Ways to Know Count of TempDB Data Files
Comprehensive Database Performance Health Check, and it was about the tempDB. Let us learn today 3 Ways to Know Count of TempDB Data Files.
SQL SERVER – List All Active Background Jobs
During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.Â
SQL SERVER – View Percentage Completed for A Long Executing Query
During the consultation, we needed to check the status (View Percentage) of the few queries and for that, I quickly wrote a query which we will see today.