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
134 views0 comments
rajendra gupta
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
rajendra gupta
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
rajendra gupta
Jan 8, 20221 min read
SQL Server script to change SQL Server Authentication Mode
A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication
48 views0 comments
rajendra gupta
Jan 7, 20221 min read
Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
1,637 views0 comments
rajendra gupta
Jan 7, 20221 min read
Why do we use WHERE 1=1 in the SQL Script?
Have you seen any SQL code that uses WHERE 1=1? Why do we use that statement? Let's understand In this article.
47 views0 comments
rajendra gupta
Jan 7, 20221 min read
SQL Server Management Studio Query Commands completed successfully without any Results
I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?
128 views0 comments
rajendra gupta
Jan 7, 20221 min read
SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
8,404 views0 comments
rajendra gupta
Jan 7, 20221 min read
What is SET NOEXEC ON in the T-SQL statement?
Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.
72 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
53 views0 comments
bottom of page