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
MSSQLTips award

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)
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)

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