Tag Archives: SQL server

Autonomous Error/Event Logging into SQL Server

Error logging or custom logging is a very common requirement while working with any database & its operations; irrespective of the database server type i.e. be it Oracle or SQL Server database. And, when we talk about SQL Server, it … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Replicate/Migrate data from one database/table to another – Part 3

As we discussed in Part 1/Part 2 about the very simple approaches of migrating the changes from one data table to another, but depending upon the situations, data volume etc., there are a few improvements needed in those approaches. In … Continue reading

Posted in SQL Server, SQL Server 2008 | Tagged , | Leave a comment

Replicate/Migrate data from one database/table to another – Part 2

To serve the purpose of data synchronisation between two data table; as discussed in Part1, SQL Server 2008 was provided with a new feature of MERGE statement. In this article we gonna go through the usage of MERGE statement/functionality and … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment