How to revert database changes using SQL Server Database Snapshot
Did you accidentally delete, update or modify the incorrect data in the SQL database? Use SQL Server database snapshot for it. Read More.
top of page
-
- Jan 11, 2022
- 1 min
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
15 views0 comments
-
- Jan 11, 2022
- 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.
53 views0 comments
-
- Jan 11, 2022
- 1 min
PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
308 views0 comments
-
- Jan 8, 2022
- 1 min
How to take SQL SERVER backup to Azure Blob Storage
How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.
219 views0 comments
-
- Jan 7, 2022
- 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...
186 views0 comments
-
- Jan 7, 2022
- 1 min
T-SQL Script to find out Nth highest salary
It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H
37 views0 comments
-
- Jan 7, 2022
- 1 min
Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
248 views0 comments
-
- Jan 5, 2022
- 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
46 views0 comments
-
- Jan 5, 2022
- 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.
40 views0 comments
-
- Jan 5, 2022
- 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
35 views0 comments
-
- Jan 5, 2022
- 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.
78 views0 comments
-
- Jan 5, 2022
- 1 min
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
35 views0 comments
-
- Jan 5, 2022
- 2 min
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
105 views0 comments
-
- Jan 4, 2022
- 1 min
Steps to change the default SQL Server backup directory
This article provides steps to change the default SQL Server backup directory.
119 views0 comments
-
- Jan 4, 2022
- 2 min
Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
24 views0 comments
-
- Jan 4, 2022
- 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.
58 views0 comments
-
- 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
24 views0 comments
-
- 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
22 views0 comments
bottom of page