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
top of page
rajendra gupta
Jan 18, 20221 min read
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
824 views0 comments
rajendra gupta
Jan 14, 20221 min read
How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:\Program Files\WindowsPowerShell\Modules.'
667 views0 comments
rajendra gupta
Jan 14, 20221 min read
Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
77 views0 comments
rajendra gupta
Jan 13, 20221 min read
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
431 views0 comments
rajendra gupta
Jan 13, 20221 min read
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)
3,918 views2 comments
rajendra gupta
Jan 13, 20221 min read
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
58 views0 comments
rajendra gupta
Jan 12, 20221 min read
How to modify SQL Server Analysis Services Modes
This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
477 views0 comments
rajendra gupta
Jan 11, 20221 min read
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.
2,645 views0 comments
rajendra gupta
Jan 11, 20221 min read
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.
992 views0 comments
rajendra gupta
Jan 11, 20221 min read
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
32 views0 comments
rajendra gupta
Jan 11, 20221 min read
PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
1,652 views0 comments
rajendra gupta
Jan 10, 20221 min read
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
131 views0 comments
rajendra gupta
Jan 10, 20221 min read
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
192 views0 comments
rajendra gupta
Jan 8, 20221 min read
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.
441 views0 comments
rajendra gupta
Jan 8, 20221 min read
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
47 views0 comments
rajendra gupta
Jan 7, 20221 min read
Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
1,613 views0 comments
rajendra gupta
Jan 7, 20221 min read
Why do we use WHERE 1=1 in the SQL Script?
Have you seen any SQL code that uses WHERE 1=1? Why do we use that statement? Let's understand In this article.
45 views0 comments
rajendra gupta
Jan 7, 20221 min read
SQL Server Management Studio Query Commands completed successfully without any Results
I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?
125 views0 comments
rajendra gupta
Jan 7, 20221 min read
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...
8,143 views0 comments
bottom of page