Ranga Narasimhan

Ranga Narasimhan has been in IT for about 10 years. He started as a Visual Basic / Crystal Reports developer and then started coding in SQL Server. He has been a SQL Server developer and for the last few years doing SQL server production support operations. In his last job, Ranga was the primary DBA for the Siebel call center database and has learned a lot from the challenges that a very large database can bring and an application where queries are built dynamically. He enjoys spending time with his family. His interests are playing tennis and golf.

Database Administration

SQL Server Transaction Log Grows And Fills Up Drive (last update: 9/17/2010)

Database Mirroring

Evaluating SQL Server Database Mirroring as a Disaster Recovery Solution (last update: 12/16/2008)

Dynamic Management Views and Functions

Collecting Query Statistics for SQL Server 2005 (last update: 9/23/2009)

Microsoft Excel Integration

Using a SQL Server Linked Server to Query Excel Files (last update: 5/27/2010)

Performance Tuning

Automate Performance Monitor Statistics Collection for SQL Server and Windows (last update: 6/19/2009)

Scripts

Auto generate SQL Server UPDATE triggers for data auditing (last update: 6/11/2009)

Security

Security issues when using aliased users in SQL Server (last update: 1/28/2009)

Triggers

Grant Execute Permissions to SQL Server Stored Procedures using DDL Triggers (last update: 11/9/2009)