Do you want to modify the default Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio? Read more

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 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.