Nitansh Agarwal

Technical lead with 4+ years of extensive experience in database administration. Nitansh has worked on SQL Server 2000,2005,2008,2008 R2. He holds the following Microsoft certificatoins; MCTS 2005, 2008 and MCITP 2008 and currently works with Cognizant Technology Solutions. In his current assignment he is handling large critical databases. His expertise is in database security, performance tuning and implementing high availability solutions. He can be contacted at nitanshagarwal@gmail.com.

Backup

How to monitor backup and restore progress in SQL Server (last update: 3/29/2011)

Database Administration

Clean unused space when a SQL Server table with a variable length column is dropped (last update: 4/4/2011)

Encryption

SQL Server Column Level Encryption Example using Symmetric Keys (last update: 11/22/2011)

Locking and Blocking

How to identify blocking in SQL Server (last update: 7/15/2011)

Professional Development Interview Questions DBA

SQL Server Replication Interview Questions (last update: 10/5/2011)

SQL Server Agent

Running SQL Server Agent with a least privilege service account (last update: 3/3/2011)