Azure SQL Database

Identify When your SQL Database Was Last Used - SQL Server

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

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

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

134 views0 comments

T-SQL Script to find out Nth highest salary

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

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

341 views0 comments

T-SQL Script to generate Six Digit One Time Password (OTP)

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

160 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

What is the maintenance window for Azure SQL Database?

rajendra gupta

Dec 31, 20211 min read

What is the maintenance window for Azure SQL Database?

54 views0 comments

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

rajendra gupta

Dec 31, 20211 min read

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

92 views0 comments

Generate Blocking tree in SQL Server and Azure SQL Database

rajendra gupta

Dec 26, 20212 min read

Generate Blocking tree in SQL Server and Azure SQL Database

209 views0 comments

Query To Kill All Active Connections in Azure SQL Database

rajendra gupta

Dec 26, 20211 min read

Query To Kill All Active Connections in Azure SQL Database

254 views0 comments

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

rajendra gupta

Dec 17, 20211 min read

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

33 views0 comments

SQL Server - Find Business Days Between Dates

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

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

418 views0 comments

Monitor Azure SQL Database and Managed Instance using dynamic management views

rajendra gupta

Dec 6, 20213 min read

Monitor Azure SQL Database and Managed Instance using dynamic management views

128 views0 comments