WhatsApp Image 2021-11-26 at 4.32_edited.png
WhatsApp Image 2021-12-01 at 1.18_edited.png
  • Home

  • About Me

  • SQL Server

  • Cloud

    • Azure
    • AWS
  • All Blogs

  • Courses

  • More

    Use tab to navigate through the menu items.
    Mail
    • LinkedIn
    • Facebook
    • Twitter
    • Twitter
    Configure SQL Server Reporting Services with AWS RDS SQL Server
    rajendra gupta
    • Feb 17
    • 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.
    176 views0 comments
    Azure Cosmos DB introduction
    rajendra gupta
    • Jan 27
    • 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
    32 views0 comments
    Display dates between two input dates using SQL DATEDIFF function in SQL Server
    rajendra gupta
    • Jan 27
    • 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
    55 views0 comments
    Identify When your SQL Database Was Last Used - SQL Server
    rajendra gupta
    • Jan 24
    • 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.
    327 views4 comments
    SQL Server Missing Index Script
    rajendra gupta
    • Jan 9
    • 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
    36 views0 comments
    T-SQL script to get user session count with client IP address
    rajendra gupta
    • Jan 9
    • 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
    30 views0 comments
    How to take SQL SERVER backup to Azure Blob Storage
    rajendra gupta
    • Jan 7
    • 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.
    87 views0 comments
    T-SQL Script to generate Six Digit One Time Password (OTP)
    rajendra gupta
    • Jan 4
    • 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
    19 views0 comments
    Disable and Enable SQL Server Indexes
    rajendra gupta
    • Jan 4
    • 2 min

    Disable and Enable SQL Server Indexes

    This article explains how to disable an Index in SQL Server.
    28 views0 comments
    Learn SQL SELECT TOP statement
    rajendra gupta
    • Jan 4
    • 2 min

    Learn SQL SELECT TOP statement

    This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
    11 views0 comments
    "Invalid Object Name" Error in SSMS for recently created objects
    rajendra gupta
    • Jan 3
    • 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"
    17 views0 comments
    Remote Desktop Control (RDP) for AWS RDS SQL Server
    rajendra gupta
    • 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...
    21 views0 comments
    What is the maintenance window for Azure SQL Database?
    rajendra gupta
    • Dec 31, 2021
    • 1 min

    What is the maintenance window for Azure SQL Database?

    What is the maintenance window for Azure SQL Database?
    13 views0 comments
    How to get Email Alerts on planned Maintenance events for Azure Services?
    rajendra gupta
    • Dec 30, 2021
    • 1 min

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

    How to get Email Alerts on planned Maintenance events for Azure Services?
    11 views0 comments
    Query To Kill All Active Connections in Azure SQL Database
    rajendra gupta
    • Dec 25, 2021
    • 1 min

    Query To Kill All Active Connections in Azure SQL Database

    Query To Kill All Active Connections in Azure SQL Database
    26 views0 comments
    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
    rajendra gupta
    • Dec 16, 2021
    • 1 min

    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
    9 views0 comments
    Get a list of supported Time Zones in SQL Server and Azure SQL Database
    rajendra gupta
    • Dec 9, 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...
    4 views0 comments
    Monitor Azure SQL Database and Managed Instance using dynamic management views
    rajendra gupta
    • Dec 5, 2021
    • 3 min

    Monitor Azure SQL Database and Managed Instance using dynamic management views

    Monitor Azure SQL Database and Managed Instance using dynamic management views
    21 views0 comments

    © 2022 by dbblogger

    Privacy Policy
    CopyRight