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.
top of page
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 7, 2022
- 1 min
T-SQL Script to find out Nth highest salary
It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H
49 views0 comments
rajendra gupta
- Jan 5, 2022
- 2 min
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
306 views0 comments
rajendra gupta
- Jan 5, 2022
- 1 min
T-SQL Script to generate Six Digit One Time Password (OTP)
This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function
126 views1 comment
rajendra gupta
- Jan 4, 2022
- 2 min
Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
33 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 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 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
Find SQL Server Statistics Updated Date
This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...
404 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