Today we will delve on how to disable triggers before a synchronization and how to renable them after the manual synchronization is complete. Manual Synchronization takes place for online/offline applications wherein an offline/mobile version...

This is a pretty common situation that comes up when performing database operations.  A stored procedure is called and the data needs to be updated if it already exists and inserted if it does...

"Out of the box" is a term applied to SharePoint (both WSS and MOSS) quite a lot…with good reason, there is a lot of functionality which is available without having to write a single...

Aryan Kamboj As you know we was blessed with baby boy on 15-Mar-2010. We have selected the name Aryan for him. The process of selecting name was very interesting. We had short-listed nearly 100...

When trying to attach a database file created in Vista, my WinXP gave the following error: "…is compressed but does not reside in a read-only database or filegroup" This means that the file is...

March 15, 2010 07:52:00 AM was one of the most beautiful moment of my life! God has graced us with baby boy. My wife (Simmi), my daughter (Diya)  and I am very happy today....

A Data Architect is an increasingly important role. It is a natural evolution from Data Analyst and Database Designer, and reflects the emergence of Internet Web Sites which need to integrate data from different...

Now let’s look at the examples 1)Rewriting product.php?id=12 to product-12.html It is a simple redirection in which .php extension is hidden from the browser’s address bar and dynamic url (containing “?” character) is converted...

What is a Solution Architect? The essence of the Solution Architect (SA) role is the conversion of the requirements into an architecture and design that will become the blueprint for the solution being created....