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 blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

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.

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"

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

Who, When, and Why restarted my SQL Server?

T-SQL script to find out SQL Server Logs directory

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

Configure the Minimum and Maximum memory for SQL Server Database instance

T-SQL script to Recycle SQL Server error logs manually

Generate Blocking tree in SQL Server and Azure SQL Database

Query To Kill All Active Connections in Azure SQL Database

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'

SQL Script to check database connections and their status

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

List of SQL Server 2019 Cumulative Packs (CU)s