Blogs

Passing IDs to Stored Procs Using XML

In the past we would use a Varchar to pass a comma delimited list of IDs to a stored proc. We would...

Changing HTML Attributes on ASP.NET Pages in the Code Behind

Not many developers realize that you can change a plain HTML object’s attributes in the code behind...

Delete Spam Users from YetAnotherForum

 I use YetAnotherForum (YAF) for my Forums here.   Like others, I get hundreds of spam users created...

Displaying a Long Description Column in a GridView

A lot of times, you have something like a description column and you want to display it in a...

Quickly Finding Missing Objects in Two SQL Server 2005 Databases

Real quick I wanted to know what tables and stored procs were in my ReleaseManagerTest database and...

Finding Objects in SQL Server During Development

I kept writing the same SQL over and over while developing to find the names of stored procs or to...

Forgotten Windows Password Recovery and the “no tables found” error.

A friend of mine brought over his laptop because he couldn’t remember his new Windows Vista...

Knowing What to Test When Changing a SQL Server Object

We were changing our linked server and needed to test every page in our website that used that...

Select One Row From a GridView

I have a page where the user can select which users are active (using check boxes), and also select...