top of page


Configure SQL Server Reporting Services with AWS RDS SQL Server
How do you set up SQL Server Reporting Services in AWS RDS? We will show you how to configure SQL Server Reporting Services in AWS and RDS.
rajendra gupta
Feb 17, 20222 min read
1,272 views
0 comments

Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
rajendra gupta
Jan 27, 20221 min read
264 views
0 comments

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
rajendra gupta
Jan 27, 20221 min read
2,648 views
0 comments


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.
rajendra gupta
Jan 25, 20222 min read
17,576 views
4 comments


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
rajendra gupta
Jan 10, 20221 min read
145 views
0 comments


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
rajendra gupta
Jan 10, 20221 min read
213 views
0 comments

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.
rajendra gupta
Jan 8, 20221 min read
469 views
0 comments


Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
rajendra gupta
Jan 5, 20222 min read
358 views
0 comments


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
rajendra gupta
Jan 5, 20221 min read
173 views
1 comment


Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
rajendra gupta
Jan 4, 20222 min read
38 views
0 comments


"Invalid Object Name" Error in SSMS for recently created objects
Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"
rajendra gupta
Jan 4, 20221 min read
235 views
0 comments

Remote Desktop Control (RDP) for AWS RDS SQL Server
Amazon RDS Custom for SQL Server was launched on October 26th, 2021. This service allows you to customize your database host (the...
rajendra gupta
Dec 31, 20211 min read
182 views
0 comments


What is the maintenance window for Azure SQL Database?
What is the maintenance window for Azure SQL Database?
rajendra gupta
Dec 31, 20211 min read
57 views
0 comments


How to get Email Alerts on planned Maintenance events for Azure Services?
How to get Email Alerts on planned Maintenance events for Azure Services?
rajendra gupta
Dec 31, 20211 min read
101 views
0 comments


Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
rajendra gupta
Dec 26, 20211 min read
279 views
0 comments

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
rajendra gupta
Dec 17, 20211 min read
33 views
0 comments

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...
rajendra gupta
Dec 10, 20211 min read
32 views
0 comments


Monitor Azure SQL Database and Managed Instance using dynamic management views
Monitor Azure SQL Database and Managed Instance using dynamic management views
rajendra gupta
Dec 6, 20213 min read
131 views
0 comments
bottom of page