One of the first things to do for securing your SQL Server is to change its default TCP port. Read more to configure it.

In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...

Script SQL Database Permissions for database refresh

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

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 explains how to disable an Index in SQL Server.

Drop Database in SQL Server

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

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

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

This article guides you to stop logging successful backup messages in SQL Server Error Logs.

T-SQL script to find out SQL Server Logs directory

T-SQL script to Recycle SQL Server error logs manually

Configure the Minimum and Maximum memory for SQL Server Database instance

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

Query To Kill All Active Connections in Azure SQL Database

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database