Author Archives: Munish Bansal

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

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

Dynamic Named Sets in SQL Server 2008 Analysis Services (SSAS 2008)

Introduction: SSAS is having a nice & useful feature of defining the calculations (Calculated Members & Named Sets). These calculations can then be used in MDX or by any other client tools etc. These calculations come very handy to allow … Continue reading

Posted in SQL Server 2008, SSAS 2008 | 6 Comments

How to remove duplicate records from Flat File Source (SSIS)

Problem: Since populating the data warehouse or any other database may involve various disparate source-types like SQL Server, Excel spreadsheets, DB2 etc. It can also be a Flat File/CSV file source as well.  In case of data sources like SQL … Continue reading

Posted in SQL Server, SSIS | 10 Comments

How to draw a line based upon data values in Dundas Chart – Customizing Dundas Chart using Code Editor (SSRS)

Introduction: Dundas has come up with the adding new abilities to Reporting Services (SSRS) in terms of more featured & customizable controls. Not only they look better with lot of UI options to customize, but also have powerful features which … Continue reading

Posted in SQL Server, SSRS | 4 Comments