Ranga Babu

Ranga Babu is a SQL Server DBA with experience in handling large Development, QA and Production database environments. I have worked on SQL Server high availability solutions like log shipping, replication, mirroring and clustering. I always like to work on SQL Server performance tuning and automation projects.
2016 Awards
2016 Awards

Amazon AWS
- Launch SQL Server instances on AMAZON EC2 (last update: 8/17/2016)
Database Mail
- SQL Server Database Mail Attachment Error (last update: 1/3/2017)
Linked Servers
- Create a linked server to MySQL from SQL Server (last update: 12/9/2016)
- Performance Issues when Updating Data with a SQL Server Linked Server (last update: 8/26/2016)
- Pointing a SQL Server Linked Server to Different Data Sources (last update: 12/20/2016)
- SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error (last update: 12/29/2016)
Performance Tuning
- SQL Server performance issues when using mismatched data types (last update: 7/25/2016)
- SQL Server stored procedure runs fast in SSMS and slow in application (last update: 6/13/2016)
Replication
- Change Not For Replication for All Triggers in a SQL Server Database (last update: 4/17/2017)
- Configure One Way Merge Replication for SQL Server (last update: 12/1/2016)
- Configure SQL Server Merge Replication with Web Syncronization (last update: 8/31/2016)
- Dynamic Snapshots in SQL Server Merge Replication (last update: 10/19/2018)
- Issues with Triggers for SQL Server Tables using Merge Replication (last update: 11/22/2018)
- Move SQL Server Merge Replication Subscriber to new Server without Reconfiguring Replication (last update: 5/10/2016)
- Simple script to check SQL Server Replication Jobs (last update: 1/20/2017)
- Steps to apply SQL Server snapshot locally at the Subscriber via Command Line (last update: 6/16/2016)
T-SQL
- New SQL Server sp_helptext to avoid line splits of code (last update: 6/22/2016)