How to check the index is disabled or enabled
In this article, we will show you two ways to check whether an index is disabled or enabled. The first method to...
Category: Database
How to check backup size in SQL Server
It is quite easy to check backup size in SQL Server. You can locate the backup location and check the size of...
How to check table index in SQL Server
There are many ways to check if the indexes exist in the table. The Below mentioned steps are based on SSMS GUI...
How to Install SQL Server Management Studio in SQL Server 2016
The installation of SQL Server management studio 2016 (SSMS) has been changed with the introduction of the SQL Server 2016 release. In...
How to shrink log file in SQL Server
SQL Server DBAs sometimes require to shrink the Transaction log file. Although, if the full and log backup is configured correctly at...
SAP SE38 Transaction Code: ABAP Editor
ABAP Editor is a tool used for the development and debugging of programs written in ABAP language. To access the ABAP Editor,...
How to find database file location in SQL Server
It is pretty much straightforward to find database file location in SQL Server. When a database is created in SQL Server, two...
How to check database encryption in SQL Server
Many organizations around the world store and manage sensitive data in their databases. To protect sensitive data from falling into unauthorized hands,...
How to Upgrade SQL Server 2016 to 2019
Database upgrades from lower versions to higher versions are often required in an organization and are performed by SQL DBA. Today we...