DBblogger | Rajendra Gupta | Page 12 of 16

top of page

WhatsApp Image 2021-11-26 at 4.32_edited.png

WhatsApp Image 2021-12-01 at 1.18_edited.png

Steps to modify default SQL Server Management Studio - Select Top 1000 Rows and Edit Top 200 Rows

Jan 6, 20221 min read

Steps to modify default SQL Server Management Studio - Select Top 1000 Rows and Edit Top 200 Rows

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

68 views0 comments

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

Jan 5, 20221 min read

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

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

1,520 views0 comments

T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

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

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

Jan 5, 20222 min read

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

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

90 views0 comments

move SQL Server TempDB database files to a different directory using Dynamic SQL

Jan 5, 20223 min read

move SQL Server TempDB database files to a different directory using Dynamic SQL

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

241 views0 comments

Drop Database in SQL Server

Jan 5, 20221 min read

Drop Database in SQL Server

Drop Database in SQL Server

30 views0 comments

Disable and Enable SQL Server Indexes

Jan 5, 20222 min read

Disable and Enable SQL Server Indexes

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

341 views0 comments

T-SQL Script to generate Six Digit One Time Password (OTP)

Jan 5, 20221 min read

T-SQL Script to generate Six Digit One Time Password (OTP)

This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

160 views1 comment

Steps to change the default SQL Server backup directory

Jan 4, 20221 min read

Steps to change the default SQL Server backup directory

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

314 views0 comments

Learn SQL SELECT TOP statement

Jan 4, 20222 min read

Learn SQL SELECT TOP statement

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

34 views0 comments

12

bottom of page