Author: Sugeshkumar Rajendran
-
Encryption & Decryption
These scripts can be used encrypt and decrypt data in a table. This can be used in columns with data integer and characters. This can be useful when you need to save your data in a format that no one can read. Only the DBA who knows the integer key value to return back can…
-
DBCC Commands
Introduction: Any SQL Server DBA does some maintenance or the other to the SQL Server instances and/or the databases. The maintenance tasks might include using some utility, scripts, third party software, TSQL, etc. The most used among them are the DBCC commands. This article brings in the list of commands available and those that are…
-
Memory Management in SQL Server
Introduction: I have heard people asking me how SQL Server manages memory. The answer to this was very difficult with SQL Server earlier versions. And with SQL Server 2005 it has been simpler to explain and understand. SQL Server by default installation manages memory dynamically and has settings that it can well negotiate with the…
-
Query Plans & Plan guides
Introduction: Most developer DBAs have tough time tuning TSQL part of the database and application. And most people leave in middle of it either frustrated or cant go beyond that. Here is a simple look on how to use the query hints and plan guides to tune the TSQL part of your database and application.
-
Estimated Time for Backup / Restore
This script can be used to find the estimated time of backup and restore that is on progress in your SQL server. This script is applicable for SQL server 2005 and above.