Query To Kill All Active Connections in Azure SQL Database

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'

SQL Script to check database connections and their status

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

List of SQL Server 2019 Cumulative Packs (CU)s

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...

When my SQL Server database was restored ?

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...

This article explains in-depth what the error message "String or binary data would be truncated" means and how you can identify which...