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 Change Always On availability group mode
    rajendra gupta
    • Jan 17
    • 1 min

    How to Change Always On availability group mode

    This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
    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
    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
    rajendra gupta
    • Jan 12
    • 1 min

    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)

    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
    22 views0 comments
    Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
    rajendra gupta
    • Jan 12
    • 1 min

    Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

    Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
    14 views0 comments
    How to modify SQL Server Analysis Services Modes
    rajendra gupta
    • Jan 11
    • 1 min

    How to modify SQL Server Analysis Services Modes

    This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
    10 views0 comments
    PowerShell Script to restart SQL Services
    rajendra gupta
    • Jan 11
    • 1 min

    PowerShell Script to restart SQL Services

    Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
    70 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
    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 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
    SQL Server script to change SQL Server Authentication Mode
    rajendra gupta
    • Jan 7
    • 1 min

    SQL Server script to change SQL Server Authentication Mode

    A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication
    10 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
    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
    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
    1
    2

    © 2022 by dbblogger

    Privacy Policy
    CopyRight