SQL Server - The One Stop Shop

Accessing REST based Web services using SQL CLR

In one of scenario I came across with requirements to consume REST based web services in SQL Server,...

Author: mrkuldeep Date: 06/18/2008

Deprecated types are not supported as OUTPUT parameters

During working on one simple stored procedure I came to one interesting scenario. If we are...

Author: mrkuldeep Date: 03/25/2008

Play with SSIS Flat File Source Error Flow Output

In general as we know that SSIS tasks error flow redirection of data through error pipe sends...

Author: mrkuldeep Date: 12/31/2007

Now import and export your audio/video data in SQL Server 2005

As we all know that we can store different format files in SQL Server in the form of data rows but...

Author: mrkuldeep Date: 10/14/2007

Upcoming SQL Server 2005 webcasts

Upcoming webcasts on SQL Server 2005. Don't forget to attend them....! Webcast Schedule - October...

Author: mrkuldeep Date: 10/12/2007

SQL Server 2008 (Formerly code name Katmai) June CTP available now

The most awaited CTP of SQL Server 2008 (Formerly code name Katmai) has been released on 06/04/2007....

Author: mrkuldeep Date: 06/05/2007

SQL Server Integration Services (SSIS) 10 Quick Best Practices

Here are the 10 SSIS best practices that would be good to follow during any SSIS package development...

Author: mrkuldeep Date: 05/21/2007