Category Archives: Uncategorized

Synthetic table\keys in QlikView – and how to avoid it

I know this is a very basic thing in QlikView, and people who do work on Qlikview must have already experienced synthetic keys. But, since this is my first article on QV & this is something I came across with … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

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

Replicate/Migrate data from one database/table to another – part 1

This is about a very simple though very useful and frequently used requirement to replicate/merge data from one database/table to another. There can be various scenarios wherein we do get data from multiple sources into one database/table and then we … Continue reading

Posted in SQL Server, SQL Server 2008, Uncategorized | 2 Comments

Welcome back !

Hi All, After being active on my blog for 2 years and then being away from it for good 3.5 years for certain reasons, I am back here ! Over these last 3.5 years, many of my colleagues & visitors … Continue reading

Posted in Uncategorized | Leave a comment

How to read a Flat File with data delimited by any wild card character like ‘#’, ‘$’ (SSIS)

Requirement: Generally we deal with Flat Files which are comma (,) separated i.e. CSV files. And in SSIS by making use of ‘Flat File Source’ component we can read them very easily. These files can contain results/data from various sources … Continue reading

Posted in SQL Server, SSIS, Uncategorized | 7 Comments