Azure

Feb 1, 20222 min read

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.

729 views0 comments

Jan 27, 20221 min read

Azure Cosmos DB introduction

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

242 views0 comments

Jan 27, 20221 min read

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

2,628 views0 comments

Jan 25, 20222 min read

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.

17,239 views4 comments

Jan 10, 20221 min read

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

134 views0 comments

Jan 10, 20221 min read

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

199 views0 comments

Jan 8, 20221 min read

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.

451 views0 comments

Dec 31, 20211 min read

What is the maintenance window for Azure SQL Database?

54 views0 comments

Dec 31, 20211 min read

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

92 views0 comments

Dec 30, 20211 min read

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

456 views0 comments