This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...

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 helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...

This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...

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

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

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

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

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

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