Tuesday, June 29, 2010

SSIS Multicast Transformation vs Conditional Split Transformation

In a data warehousing scenario, it's not rare to replicate data of a source table to multiple destination tables, sometimes it's even required to distribute data of a source table to two or more tables depending on some condition. For example splitting data based on location etc. So how we can achieve this with SSIS? SSIS provides several built-in transformation tasks to achieve these kinds of , for details click here.

Tuesday, June 8, 2010

Writing a Data Access Layer (DAL) in ADO.NET

Almost every application being developed stores data in some or other form to make it persistent, this could be either storing it in file system, Excel sheet, XML format or in relational database. So each time, when you develop an application, you are required to write code for storing and retrieving data from these data sources.
In this article, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes overtime and also you can reuse it in other applications that you develop. For details, click here.

Friday, June 4, 2010

SQL Server 2008 System Functions to Research Tables, Views, Indexes, Columns, Stored Procedures, etc.

SQL Server provides several system meta data functions to get property values for different object types. Each system meta data function has a set of properties you can query using the system meta data function. In this article, I am going to outline examples on the following functions, for details click here.

  • OBJECTPROPERTY and OBJECTPROPERTYEX
  • INDEXPROPERTY
  • COLUMNPROPERTY

SQL Server Service Broker Components - Initiator, Target, Message Types, Contracts and Queue

In my last article, I talked about SQL Server Service Broker at introductory level. In this article I am going to cover some of the components of Service Broker viz. Initiator, Target, Message Types, Contract and Queue, for more details click here.