Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed

SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he

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

If you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at

How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.

What is the maintenance window for Azure SQL Database?

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

Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database

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

This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...

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

Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...

The DATETIMEOFFSET can manipulate a single point in time value (DateTime Value) with the offset value. The offset specifies the value of...

SQL Server uses #table for Temporary table and ##Table for the Global Temporary Table. Let's understand the difference between these...

Monitor Azure SQL Database and Managed Instance using dynamic management views