top of page

Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error
Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error
prashantj42000
Jun 11, 20241 min read
80 views
1 comment

How to Repair MS SQL Database from Suspect Mode
How to Repair MS SQL Database from Suspect Mode
rajendra gupta
Mar 18, 20243 min read
515 views
2 comments


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
-
Jan 18, 20221 min read
1,496 views
0 comments


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
-
Jan 13, 20221 min read
483 views
0 comments


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)
-
Jan 13, 20221 min read
4,203 views
2 comments


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
-
Jan 13, 20221 min read
70 views
0 comments


How to modify SQL Server Analysis Services Modes
This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
-
Jan 12, 20221 min read
597 views
0 comments


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.
-
Jan 11, 20221 min read
2,905 views
0 comments


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.
-
Jan 11, 20221 min read
1,060 views
0 comments


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
-
Jan 11, 20221 min read
37 views
0 comments


PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
-
Jan 11, 20221 min read
1,706 views
0 comments


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
-
Jan 10, 20221 min read
148 views
0 comments


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
-
Jan 10, 20221 min read
214 views
0 comments

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.
-
Jan 8, 20221 min read
469 views
0 comments


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
-
Jan 8, 20221 min read
54 views
0 comments


Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
-
Jan 7, 20221 min read
1,749 views
0 comments


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...
-
Jan 7, 20221 min read
9,206 views
0 comments


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
-
Jan 7, 20221 min read
53 views
0 comments


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
-
Jan 5, 20221 min read
1,673 views
0 comments


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.
-
Jan 5, 20221 min read
220 views
0 comments
bottom of page