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.
top of page
rajendra gupta
- 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
208 views0 comments
rajendra gupta
- 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
2,591 views0 comments
rajendra gupta
- 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.
16,705 views4 comments
rajendra gupta
- 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
127 views0 comments
rajendra gupta
- 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
188 views0 comments
rajendra gupta
- 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.
429 views0 comments
rajendra gupta
- Dec 31, 2021
- 1 min
What is the maintenance window for Azure SQL Database?
What is the maintenance window for Azure SQL Database?
50 views0 comments
rajendra gupta
- Dec 31, 2021
- 1 min
How to get Email Alerts on planned Maintenance events for Azure Services?
How to get Email Alerts on planned Maintenance events for Azure Services?
89 views0 comments
rajendra gupta
- Dec 30, 2021
- 1 min
Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database
Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database
431 views0 comments
rajendra gupta
- Dec 26, 2021
- 2 min
Generate Blocking tree in SQL Server and Azure SQL Database
Generate Blocking tree in SQL Server and Azure SQL Database
179 views0 comments
rajendra gupta
- Dec 26, 2021
- 1 min
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
228 views0 comments
rajendra gupta
- Dec 17, 2021
- 1 min
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
32 views0 comments
rajendra gupta
- 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...
236 views0 comments
rajendra gupta
- 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?...
193 views0 comments
rajendra gupta
- 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...
29 views0 comments
rajendra gupta
- 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...
114 views0 comments
rajendra gupta
- 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...
207 views0 comments
rajendra gupta
- Dec 6, 2021
- 3 min
Monitor Azure SQL Database and Managed Instance using dynamic management views
Monitor Azure SQL Database and Managed Instance using dynamic management views
116 views0 comments
bottom of page