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 [email protected]
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)