rajendra guptaJan 171 minHow 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
rajendra guptaJan 121 minSQL Database Error - BACKUP LOG cannot be performed because there is no current database backupSQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
rajendra guptaJan 121 minT-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)
rajendra guptaJan 121 minTroubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL ServerTroubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
rajendra guptaJan 111 minHow to modify SQL Server Analysis Services ModesThis article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
rajendra guptaJan 111 minPowerShell Script to restart SQL ServicesLearn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
rajendra guptaJan 101 minEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server databaseEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
rajendra guptaJan 101 minHow 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.
rajendra guptaJan 91 minSQL Server Missing Index ScriptIf 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
rajendra guptaJan 91 minT-SQL script to get user session count with client IP addressDownload 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
rajendra guptaJan 71 minHow to take SQL SERVER backup to Azure Blob StorageHow to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.
rajendra guptaJan 71 minSQL 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
rajendra guptaJan 61 minSQL 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...
rajendra guptaJan 61 minT-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
rajendra guptaJan 61 minScript SQL Database Permissions for database refreshScript SQL Database Permissions for database refresh
rajendra guptaJan 51 minGet a list of installed SQL Server Components with SQL Server Discovery ToolGet a list of installed SQL Server Components with SQL Server Discovery Tool
rajendra guptaJan 51 minT-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL ServerThis article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
rajendra guptaJan 52 minDynamic SQL to move SQL Server TempDB Data and Log Files to different directoriesDynamic SQL to move SQL Server TempDB Data and Log Files to different directories
rajendra guptaJan 41 minT-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
rajendra guptaJan 42 minDisable and Enable SQL Server IndexesThis article explains how to disable an Index in SQL Server.