rajendra gupta
- Aug 3
- 3 min
Install SQL Server 2022 on Ubuntu in 5 minutes
Having trouble installing SQL Server 2022 on Ubuntu? Follow our 5-minute guide and get SQL Server up and running on your Ubuntu machine.
259 views0 comments
rajendra gupta
- May 30
- 3 min
Contained Availability Group SQL Server 2022
SQL Server 2022 can be used to sync up agent jobs, logins, and permissions automatically between primary and secondary replicas. Read More
895 views0 comments
rajendra gupta
- May 26
- 3 min
Install SQL Server 2022 on Windows
This article guides you in installing SQL Server 2022 preview.
807 views0 comments
rajendra gupta
- Jan 11
- 1 min
How to configure a static port for SQL Server?
One of the first things to do for securing your SQL Server is to change its default TCP port. Read more to configure it.
32 views0 comments
rajendra gupta
- Jan 7
- 1 min
SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
54 views0 comments
rajendra gupta
- Jan 7
- 1 min
Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
92 views0 comments
rajendra gupta
- Jan 5
- 1 min
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
33 views0 comments
rajendra gupta
- Jan 5
- 1 min
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.
25 views0 comments
rajendra gupta
- Jan 5
- 2 min
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
28 views0 comments
rajendra gupta
- Jan 5
- 3 min
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.
59 views0 comments
rajendra gupta
- Jan 5
- 2 min
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
49 views0 comments
rajendra gupta
- Jan 4
- 1 min
Steps to change the default SQL Server backup directory
This article provides steps to change the default SQL Server backup directory.
61 views0 comments
rajendra gupta
- Jan 4
- 2 min
Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
14 views0 comments
rajendra gupta
- Jan 4
- 2 min
How to stop logging successful backup messages in SQL Server error logs
This article guides you to stop logging successful backup messages in SQL Server Error Logs.
38 views0 comments
rajendra gupta
- Dec 30, 2021
- 1 min
T-SQL script to find out SQL Server Logs directory
T-SQL script to find out SQL Server Logs directory
11 views0 comments
rajendra gupta
- Dec 30, 2021
- 1 min
T-SQL script to Recycle SQL Server error logs manually
T-SQL script to Recycle SQL Server error logs manually
15 views0 comments
rajendra gupta
- Dec 30, 2021
- 1 min
Configure the Minimum and Maximum memory for SQL Server Instance
Configure the Minimum and Maximum memory for SQL Server Database instance
7 views0 comments
rajendra gupta
- Dec 30, 2021
- 1 min
Increase or Decrease the number of error log files and their size in SQL Server
Increase the number of error log files and their size in SQL Server
12 views0 comments