top of page
-
Dec 26, 20211 min read
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
254 views0 comments
-
Dec 26, 20212 min read
SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'
SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'
178 views0 comments
-
Dec 26, 20211 min read
SQL Script to check database connections and their status
SQL Script to check database connections and their status
224 views0 comments
-
Dec 17, 20211 min read
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
33 views0 comments
-
Dec 14, 20211 min read
List of SQL Server 2019 Cumulative Packs (CU)
List of SQL Server 2019 Cumulative Packs (CU)s
330 views0 comments
-
Dec 10, 20211 min read
SQL Server - Find Business Days Between Dates
Recently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...
197 views0 comments
-
Dec 10, 20211 min read
Find SQL Server Statistics Updated Date
This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...
418 views0 comments
-
Dec 10, 20211 min read
When my SQL Server database was restored ?
When my SQL Server database was restored ?
41 views0 comments
-
Dec 10, 20211 min read
Get a list of supported Time Zones in SQL Server and Azure SQL Database
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...
31 views0 comments
Rajendra Gupta
Dec 1, 20212 min read
SQL Server 2019: "String or binary data would be truncated"
This article explains in-depth what the error message "String or binary data would be truncated" means and how you can identify which...
133 views0 comments
bottom of page