This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin

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

Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.

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

Read the article to use a PowerShell Script for configuring SQL Server static Port

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

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

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.

A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication

Script SQL Database Permissions for database refresh

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

This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.

Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories

This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.

Drop Database in SQL Server

This article explains how to disable an Index in SQL Server.

This article provides steps to change the default SQL Server backup directory.

Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database

T-SQL script to find out SQL Server Logs directory

Increase the number of error log files and their size in SQL Server