SSIS Package opens with errors after installing Visual Studio 2010

Last week I installed Visual Studio Premium 2010, and today I had to open a SSIS 2008 package. To my dismay when I opened it I got the following error (Unable to instantiate XML DOM document, please verify that…

SQL SERVER — UDF — Function to Convert Text String to Title Case — Proper Case (via Journey to SQL Authority with Pinal Dave)

Really very useful! Copy, Paste, Execute and Use. Saved me a lot of time.

Procedure or function ‘GetOrder’ expects parameter ‘@ID’, which was not supplied.

Today I started a new method and and instead of doing the usual copy and paste code from one of my already working methods I just typed it as it is only 3 lines.

Generate SQL Update Statement And Stored Procedure From Table Name

Today I had to write a few simple update stored procedures and a couple of update statements. This got me thinking, seeing that I’m a SQL / .Net developer, I create loads of these every month.

Dynamic Nested ASP.Net GridView using AJAX, Webservices and jQuery

Introduction

I haven’t blogged for a while, I have been really swamped at work.

jQuery: “Could not get the display property. Invalid argument.” error in Internet Explorer 7

I’m really very new (using it for a week or two) to jQuery myself and this had me stumped for a few minutes. I got the error “Could not get the display property. Invalid…

Script All Indexes SQL Server 2005/2008

I needed a script to script out all the indexes with their included columns. All the scripts I could find on the inernet only scripted the normal columns, so I created my own script to script all columns and included columns.