DBblogger | Rajendra Gupta

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

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

1,899 views0 comments

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

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

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