SQL 7/7

Dec 26, 20211 min read

SQL Script to check database connections and their status

224 views0 comments

Dec 24, 20211 min read

SQL Server 2017 Cumulative Updates (CU)s

Get a list of Cumulative Updates(CU) for SQL Server 2017 with downloadable links

213 views0 comments

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

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 ?

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

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,355 views0 comments

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,628 views0 comments

Dec 8, 20212 min read

DATETIMEOFFSET SQL Server

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

132 views0 comments

Dec 8, 20211 min read

Difference between #table and ##table in SQL Server

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

235 views0 comments

Dec 6, 20211 min read

Fix error "Agent XPs disabled" in SQL Server

This article explains the steps to fix the SQL Server agent error "Agent XPs disabled" using T-SQL scripts. Error details You might see...

1,040 views0 comments

Dec 6, 20212 min read

Extract SQL Server Instance details using SERVERPROPERTY() function

340 views0 comments

Dec 6, 20212 min read

Restore database in SQL Server Always On Availability Group

In this blog, we will look at how to restore a database participating in SQL Server Always On Availability Group using the T-SQL scripts....

3,666 views0 comments

Dec 4, 20214 min read

Learn SQL Server Select statement

The SQL SELECT statement is the workhorse of data access. It is the standard way to retrieve data from a SQL database. In this tutorial,...

35 views0 comments

SQL Server 2019: "String or binary data would be truncated"

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

Find databases list where user has access in SQL Server

Rajendra Gupta

Nov 25, 20211 min read

Find databases list where user has access in SQL Server

Recently our client wanted to know if there's a way for him to figure out which additional databases his user has access to. When we...

91 views0 comments

How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group

Rajendra Gupta

Nov 25, 20213 min read

How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group

One of the fantastic features of Always On Availability Groups is that you can take one of the replicas for a database offline for...

4,834 views0 comments