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
    How to configure a static port for SQL Server?
    rajendra gupta
    • Jan 10
    • 1 min

    How to configure a static port for SQL Server?

    One of the first things to do for securing your SQL Server is to change its default TCP port. Read more to configure it.
    21 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
    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
    Get a list of installed SQL Server Components with SQL Server Discovery Tool
    rajendra gupta
    • Jan 5
    • 1 min

    Get a list of installed SQL Server Components with SQL Server Discovery Tool

    Get a list of installed SQL Server Components with SQL Server Discovery Tool
    18 views0 comments
    T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
    rajendra gupta
    • Jan 5
    • 1 min

    T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

    This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
    17 views0 comments
    Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories
    rajendra gupta
    • Jan 5
    • 2 min

    Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories

    Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories
    21 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
    move SQL Server TempDB database files to a different directory using Dynamic SQL
    rajendra gupta
    • Jan 4
    • 3 min

    move SQL Server TempDB database files to a different directory using Dynamic SQL

    This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.
    33 views0 comments
    Steps to change the default SQL Server backup directory
    rajendra gupta
    • Jan 4
    • 1 min

    Steps to change the default SQL Server backup directory

    This article provides steps to change the default SQL Server backup directory.
    13 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
    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
    T-SQL script to find out SQL Server Logs directory
    rajendra gupta
    • Dec 30, 2021
    • 1 min

    T-SQL script to find out SQL Server Logs directory

    T-SQL script to find out SQL Server Logs directory
    6 views0 comments
    T-SQL script to Recycle SQL Server error logs manually
    rajendra gupta
    • Dec 29, 2021
    • 1 min

    T-SQL script to Recycle SQL Server error logs manually

    T-SQL script to Recycle SQL Server error logs manually
    12 views0 comments
    Configure the Minimum and Maximum memory for SQL Server Instance
    rajendra gupta
    • Dec 29, 2021
    • 1 min

    Configure the Minimum and Maximum memory for SQL Server Instance

    Configure the Minimum and Maximum memory for SQL Server Database instance
    6 views0 comments
    Increase or Decrease the number of error log files and their size in SQL Server
    rajendra gupta
    • Dec 29, 2021
    • 1 min

    Increase or Decrease the number of error log files and their size in SQL Server

    Increase the number of error log files and their size in SQL Server
    6 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

    © 2022 by dbblogger

    Privacy Policy
    CopyRight