Data Engineering – Learn from the experts
-
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.
-
Mirrored Backups
Mirrored backup is a feature available in SQL Server 2005 Enterprise Edition and Development Edition. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations.
Got any recommendations?