Azure

Feb 1, 2022
2 min

SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests

Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.

390 views0 comments

Jan 27, 2022
1 min

Azure Cosmos DB introduction

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed

106 views0 comments

Jan 27, 2022
1 min

Display dates between two input dates using SQL DATEDIFF function in SQL Server

SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he

1,039 views0 comments

Jan 25, 2022
2 min

Identify When your SQL Database Was Last Used - SQL Server

I've seen several questions on the forums asking how to find out whether the SQL database is in use or not? Let's answer in this article.

6,263 views4 comments

Jan 10, 2022
1 min

T-SQL script to get user session count with client IP address

Download a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete

87 views0 comments

Jan 10, 2022
1 min

SQL Server Missing Index Script

If you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at

121 views0 comments

Jan 8, 2022
1 min

How to take SQL SERVER backup to Azure Blob Storage

How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.

269 views0 comments

Dec 31, 2021
1 min

What is the maintenance window for Azure SQL Database?

35 views0 comments

Dec 31, 2021
1 min

How to get Email Alerts on planned Maintenance events for Azure Services?

48 views0 comments

Dec 30, 2021
1 min

Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database

147 views0 comments

Dec 26, 2021
2 min

Generate Blocking tree in SQL Server and Azure SQL Database

109 views0 comments

Dec 26, 2021
1 min

Query To Kill All Active Connections in Azure SQL Database

107 views0 comments

Dec 17, 2021
1 min

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

20 views0 comments

Dec 13, 2021
2 min

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

203 views0 comments

Dec 10, 2021
1 min

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

112 views0 comments

Dec 10, 2021
1 min

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

16 views0 comments

Dec 8, 2021
2 min

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

52 views0 comments

Dec 8, 2021
1 min

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

69 views0 comments

Dec 6, 2021
3 min

Monitor Azure SQL Database and Managed Instance using dynamic management views

78 views0 comments