Today we are going to a very simple example of the Input and Output Parameter for Dynamic SQL. I have been working on SQL Server for almost 20 years.
Remove Bookmark Lookup – SQL in Sixty Seconds #089
We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
SQL Server – T-SQL – Add and Remove IP Address to Azure Firewall
The question was is there any way to list all the IP addresses which have access to the Azure Firewall and remove them via T-SQL in SSMS.
SQL Azure – Add IP Address to Firewall
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.Â
Personal Technology – Solution – Bluetooth KeyBoard and Mouse Frequently Disconnecting
Today we are going to look at how we can fix the issue about frequently disconnecting with your Bluetooth devices like keyboard and mouse.