Blogs

Notify Me When Something Doesn’t Happen

I have 10 clients that each have a process that posts a value to my web service every hour at three...

Having the Result Set of a Stored Proc Sent to You by RSS Feed.

I wanted to monitor one of my system from my desk top and from my phone.  I found a simple...

Logging Exceptions and the Commands that Caused Them.

For a long time I’ve been logging all of my exceptions to a table that looks like: Now for...

Change Connection String Password Programmatically

On one of our projects we have a requirement that we have to change our passwords every 90...

Data Access Layer Architecture

I wanted to document how we do our DAL.  First, performance is important so we use ADO.NET...

Stripping Out Passwords

I have a page in my ASP.Net application where I show all of my AppSettings, connection strings...

Uploading XML Files to SQL Server

I had a large number of XML files that each contained hourly prices for a lot of different...

Grid within a GridView Cell

I needed to display some parent data with it’s child data on the same row like shown in the...

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...