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, 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
131 views0 comments
rajendra gupta
Jan 7, 20221 min read
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
50 views0 comments
rajendra gupta
Jan 5, 20222 min read
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
337 views0 comments
rajendra gupta
Jan 5, 20221 min read
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
143 views1 comment
rajendra gupta
Jan 4, 20222 min read
Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
34 views0 comments
rajendra gupta
Dec 31, 20211 min read
What is the maintenance window for Azure SQL Database?
What is the maintenance window for Azure SQL Database?
53 views0 comments
rajendra gupta
Dec 31, 20211 min read
How to get Email Alerts on planned Maintenance events for Azure Services?
How to get Email Alerts on planned Maintenance events for Azure Services?
92 views0 comments
rajendra gupta
Dec 26, 20212 min read
Generate Blocking tree in SQL Server and Azure SQL Database
Generate Blocking tree in SQL Server and Azure SQL Database
206 views0 comments
rajendra gupta
Dec 26, 20211 min read
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
242 views0 comments
rajendra gupta
Dec 17, 20211 min read
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
33 views0 comments
rajendra gupta
Dec 10, 20211 min read
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?...
196 views0 comments
rajendra gupta
Dec 10, 20211 min read
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...
413 views0 comments
rajendra gupta
Dec 6, 20213 min read
Monitor Azure SQL Database and Managed Instance using dynamic management views
Monitor Azure SQL Database and Managed Instance using dynamic management views
124 views0 comments
bottom of page