I've seen several questions on the forums asking how to find out whether the SQL database is in use or not? Let's answer in this article.

Download a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete

It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H

This article explains how to disable an Index in SQL Server.

This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

What is the maintenance window for Azure SQL Database?

How to get Email Alerts on planned Maintenance events for Azure Services?

Generate Blocking tree in SQL Server and Azure SQL Database

Query To Kill All Active Connections in Azure SQL Database

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

Recently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...

This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...

Monitor Azure SQL Database and Managed Instance using dynamic management views