Cloud | dbblogger

Feb 17, 2022
2 min

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.

508 views0 comments

Jan 27, 2022
1 min

Azure Cosmos DB introduction

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed

82 views0 comments

Jan 27, 2022
1 min

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

233 views0 comments

Jan 25, 2022
2 min

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.

2,932 views4 comments

Jan 10, 2022
1 min

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

83 views0 comments

Jan 10, 2022
1 min

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

66 views0 comments

Jan 8, 2022
1 min

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.

219 views0 comments

Jan 5, 2022
1 min

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

35 views0 comments

Jan 5, 2022
2 min

Disable and Enable SQL Server Indexes

This article explains how to disable an Index in SQL Server.

105 views0 comments

Jan 4, 2022
2 min

Learn SQL SELECT TOP statement

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

24 views0 comments

Jan 4, 2022
1 min

"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"

65 views0 comments

Dec 31, 2021
1 min

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

72 views0 comments

Dec 31, 2021
1 min

What is the maintenance window for Azure SQL Database?

26 views0 comments

Dec 31, 2021
1 min

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

34 views0 comments

Dec 26, 2021
1 min

Query To Kill All Active Connections in Azure SQL Database

85 views0 comments

Dec 17, 2021
1 min

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

17 views0 comments

Dec 10, 2021
1 min

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

12 views0 comments

Dec 6, 2021
3 min

Monitor Azure SQL Database and Managed Instance using dynamic management views

66 views0 comments