In one of scenario I came across with requirements to consume REST based web services in SQL Server, I have done research and found that this can be very well done using SQL CLR features, before I start with how to use SQL CLR to consume REST web services...

During working on one simple stored procedure I came to one interesting scenario. If we are developing a stored procedure in SQL Server 2005 that take some input or output parameters and if those parameters are of deprecated data types like Text, NText...

In general as we know that SSIS tasks error flow redirection of data through error pipe sends erroneous data in form of rows with multiple columns. For an example, if we use a lookup task in our data flow, any failing lookups can be redirected to a table...

As we all know that we can store different format files in SQL Server in the form of data rows but most of the time it is hard for us to find a working demo on how to store audio/video file in SQL Server 2005 database. I have created a demo .NET app...

Upcoming webcasts on SQL Server 2005. Don't forget to attend them....! Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by Microsoft experts on Infrastructure...

The most awaited CTP of SQL Server 2008 (Formerly code name Katmai ) has been released on 06/04/2007. You can download it from http://connect.microsoft.com/sqlserver . You can also watch Ted Kummert talking about SQL Server 2008 here Some of the...

Here are the 10 SSIS best practices that would be good to follow during any SSIS package development § The most desired feature in SSIS packages development is re-usability. In other ways, we can call them as standard packages that can be re-used during...