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.
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.
Open Source Cloud – Final Post
Today we are going to see the final post on the open-source cloud series which I have been writing for over the last 10 days. Here is the list.