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.
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.
How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285
Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
SQL SERVER – Computed Column and Compute Scalar Operators
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.
SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –
Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.
Database Monitoring in 2020 Results From the Latest State of Monitoring Report
Redgate Software recently released the 3rd annual State of Database Monitoring report. This year the report was extended to cover all database platforms.