Window SharePoint Service (WSS) 3.0 Vs Microsoft Office SharePoint Server (MOSS) 2007

Window SharePoint Service (WSS) 3.0 and Microsoft Office SharePoint Server (MOSS) 2007 both provide a platform for communication, collaborative development, content management, search capability etc. But how do they differ from each other, what benefits do each of them provide over other, in which scenario to use WSS and in which to use MOSS? To learn about these, click here.

Using a Data Access Application Block (DAAB)

Microsoft Enterprise Library provides several reusable software components (application blocks) which help developers simplify common development tasks, minimize development efforts and help address common problems related to performance/optimization/reusability release over release. These components are provided along with source code which developers can use "as-is" or customize per their projects need. Data Access Application Block (DAAB) is one of these components which simplifies the data access mechanism. Data Access Application Block provides a consistent data access mechanism to execute both Stored Procedures and inline SQL statements across projects/enterprises along with transaction support also. For more details, click here for Part1 article and click here for Part 2 article.

SQL Server Service Broker Components - Service, Conversation, Conversation Groups, Routes, SEND and RECEIVE Commands

In my last article SQL Server Service Broker Components - Message Types, Contracts and Queue, I discussed the Initiator, Target, Message Types, Contract and Queue components of SSBS. In this article I will be talking about the Service, Conversation, Conversation group, SEND and RECEIVE commands, Route and how these components are related to each other. For more details, click here.

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.

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.

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.