SQL Server 2019

Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error

prashantj42000

Jun 111 min read

Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error

68 views1 comment

How to Repair MS SQL Database from Suspect Mode

rajendra gupta

Mar 183 min read

How to Repair MS SQL Database from Suspect Mode

417 views2 comments

Jan 18, 20221 min read

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

1,383 views0 comments

Jan 13, 20221 min read

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

442 views0 comments

Jan 13, 20221 min read

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

4,000 views2 comments

Jan 13, 20221 min read

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

60 views0 comments

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.

512 views0 comments

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,706 views0 comments

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.

1,001 views0 comments

Jan 11, 20221 min read

Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database

34 views0 comments

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,668 views0 comments

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

134 views0 comments

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

199 views0 comments

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.

451 views0 comments

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

48 views0 comments

Jan 7, 20221 min read

Script SQL Database Permissions for database refresh

1,637 views0 comments

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,418 views0 comments

Jan 7, 20221 min read

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

53 views0 comments

Jan 5, 20221 min read

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

1,520 views0 comments

Jan 5, 20221 min read

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.

215 views0 comments