top of page
CLOUD
rajendra gupta
Feb 17, 20222 min read
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.
1,225 views0 comments
rajendra gupta
Jan 27, 20221 min read
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
242 views0 comments
rajendra gupta
Jan 27, 20221 min read
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
2,628 views0 comments
rajendra gupta
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,237 views4 comments
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 5, 20222 min read
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
341 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
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
bottom of page