Issues with Triggers for SQL Server Tables using Merge Replication
Learn how to troubleshoot and fix potential trigger problems when using SQL Server merge replication.
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.
Dynamic Snapshots in SQL Server Merge Replication
In this tip we look at how to partition SQL Server replication snapshots and apply them to subscribers using an alternative location for the snapshot.
Change Not For Replication for All Triggers in a SQL Server Database
Read this tip and download the application that allows you to change the Not For Replication setting for all SQL Server triggers.
Simple script to check SQL Server Replication Jobs
We have SQL Server replication configured on our servers and every once in a while we find the SQL Agent replication jobs are stopped and data is not being replicated. We can find the status of the replication agents either using replication monitor or t
SQL Server Database Mail Attachment Error
I received this error when using SQL Server Database Mail - File attachment or query results size exceeds allowable value of 1000000 bytes. Read this tip to learn how to fix this error.
SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error
I was trying to use OPENROWSET to query a remote database and I got the following error Ad hoc access to OLE DB provider has been denied error. You must access this provider through a linked server.
Pointing a SQL Server Linked Server to Different Data Sources
In this tip we will cover how to create a linked server with a constant name that points to different servers depending on what servers we are working with.
Create a linked server to MySQL from SQL Server
Linked servers are used to query remote databases and in this tip we will learn how to configure a linked server for a MySQL server from SQL Server.
Configure One Way Merge Replication for SQL Server
We are using SQL Server Merge replication and we had a need to setup a one way publication. We needed DML changes on the publisher to get replicated to one of the subscribers, but not from that subscriber to the publisher. In this tip we look at how this
Configure SQL Server Merge Replication with Web Syncronization
One of the things that needs to occur for replication is the synchronization of data between the publisher and subscribers. In some cases machines may not be on the same network, so there is a need for other methods of data synchronization. In this tip we
Performance Issues when Updating Data with a SQL Server Linked Server
Linked servers are great to query remote databases, but when running update queries they don't always behave like they should. In this tip I will show you a situation where several queries worked fine, but a few did not behave as planned. I will also sh
Launch SQL Server instances on AMAZON EC2
Amazon EC2 offers another option for putting SQL Server in the cloud. It is easy to setup, upgrade and you are only charged when the box is in use. Let's take a look at how to use Amazon EC2 for SQL Server.
SQL Server performance issues when using mismatched data types
For one our applications we encountered deadlock issues when deleting rows for a high concurrency application. The application queries were deleting only one row at a time, but we were still having deadlock issues.
New SQL Server sp_helptext to avoid line splits of code
Using sp_helptext to script out or see the definition of a SQL Server stored procedure, trigger or function is very helpful, but there are issues when the code has a line with a length more than 256 characters.
Apply SQL Server snapshot locally at the Subscriber via Command Line
Learn how to apply a SQL Server snapshot locally at the Subscriber via Command Line in order to minimize the time needed to synchronize SQL Server Replication.
Move SQL Server Merge Replication Subscriber to new Server without Reconfiguring Replication
We had a requirement to move the Subscriber for a Merge publication to a new SQL Server. Check out this tip to learn how without having to reconfigure replication.