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

Cloud Computing

Launch SQL Server instances on AMAZON EC2 (8/17/2016)

Database Mail

SQL Server Database Mail Attachment Error (1/3/2017)

Linked Servers

Create a linked server to MySQL from SQL Server (12/9/2016)
Performance Issues when Updating Data with a SQL Server Linked Server (8/26/2016)
Pointing a SQL Server Linked Server to Different Data Sources (12/20/2016)
SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error (12/29/2016)

Performance Tuning

SQL Server performance issues when using mismatched data types (7/25/2016)
SQL Server stored procedure runs fast in SSMS and slow in application (6/13/2016)

Replication

Change Not For Replication for All Triggers in a SQL Server Database (4/17/2017)
Configure One Way Merge Replication for SQL Server (12/1/2016)
Configure SQL Server Merge Replication with Web Syncronization (8/31/2016)
Move SQL Server Merge Replication Subscriber to new Server without Reconfiguring Replication (5/10/2016)
Simple script to check SQL Server Replication Jobs (1/20/2017)
Steps to apply SQL Server snapshot locally at the Subscriber via Command Line (6/16/2016)

T-SQL

New SQL Server sp_helptext to avoid line splits of code (6/22/2016)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Ranga Babu

More SQL Server Solutions