top of page
rajendra gupta
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
rajendra gupta
Dec 15, 20211 min read
Microsoft SQL Server 2022 is here!!!
Microsoft SQL Server 2022 features and links
174 views0 comments
rajendra gupta
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
rajendra gupta
Dec 13, 20212 min read
SQL Server table Columns with NULL and NOT NULL values
This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
241 views0 comments
rajendra gupta
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
rajendra gupta
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
rajendra gupta
Dec 10, 20211 min read
When my SQL Server database was restored ?
When my SQL Server database was restored ?
41 views0 comments
rajendra gupta
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 10, 20211 min read
Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371
This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...
2,358 views0 comments
rajendra gupta
Dec 9, 20212 min read
SQL Script to fix Orphan users in SQL Server database
This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...
2,630 views0 comments
bottom of page