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
    T-SQL Query to find SQL database age and number of tables in SQL Server
    rajendra gupta
    • Jan 18
    • 1 min

    T-SQL Query to find SQL database age and number of tables in SQL Server

    SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
    22 views0 comments
    SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
    rajendra gupta
    • Jan 12
    • 1 min

    SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

    SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
    5 views0 comments
    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
    rajendra gupta
    • Jan 10
    • 1 min

    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database

    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
    4 views0 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
    SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
    rajendra gupta
    • Jan 6
    • 1 min

    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...
    28 views0 comments
    T-SQL Script to find out Nth highest salary
    rajendra gupta
    • Jan 6
    • 1 min

    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
    19 views0 comments
    Script SQL Database Permissions for database refresh
    rajendra gupta
    • Jan 6
    • 1 min

    Script SQL Database Permissions for database refresh

    Script SQL Database Permissions for database refresh
    44 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
    Drop Database in SQL Server
    rajendra gupta
    • Jan 4
    • 1 min

    Drop Database in SQL Server

    Drop Database in SQL Server
    7 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
    How to stop logging successful backup messages in SQL Server error logs
    rajendra gupta
    • Jan 3
    • 2 min

    How to stop logging successful backup messages in SQL Server error logs

    This article guides you to stop logging successful backup messages in SQL Server Error Logs.
    12 views0 comments
    Generate Blocking tree in SQL Server and Azure SQL Database
    rajendra gupta
    • Dec 25, 2021
    • 2 min

    Generate Blocking tree in SQL Server and Azure SQL Database

    Generate Blocking tree in SQL Server and Azure SQL Database
    18 views0 comments
    SQL Script to check database connections and their status
    rajendra gupta
    • Dec 25, 2021
    • 1 min

    SQL Script to check database connections and their status

    SQL Script to check database connections and their status
    29 views0 comments
    SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'
    rajendra gupta
    • Dec 25, 2021
    • 2 min

    SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'

    SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'
    31 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
    SQL Server table Columns with NULL and NOT NULL values
    rajendra gupta
    • Dec 12, 2021
    • 2 min

    SQL Server table Columns with NULL and NOT NULL values

    This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
    14 views0 comments
    1
    2

    © 2022 by dbblogger

    Privacy Policy
    CopyRight