Jeremiah Peschka

Let’s say that we have an application that tracks and reports customer bills. Customers are able to view reports based on their bill. As time goes on, the customers have a need to create adjustments to their bill. It should be simple enough to add some identifying data to the bill to determine which [...]

A co-worker approached me with the problem of sorting an ArrayList of ArrayLists. Normally you might handle this in a DataTable or entity collection in your particular ORM. In this case, this was the data structure that was available to sort:
[[sortorder][type][message]
[sortorder][type][message]
[sortorder][type][message]]
Knowing a little bit about how ORM tools work, I made [...]

Normally, I hate meetings. Meetings are poison, for the most part. They kill productivity. Over the course of my career, I have been in very few meetings that couldn’t have been accomplished via a phone call or a 5 minute discussion in someone’s office.
Today I spent two and a half hours in [...]

Sometimes you just have to be able to dynamic search criteria in a stored procedure. What’s going to be the best way to accomplish this?
You could use dynamic SQL and run the risk that you won’t have compiled execution plans, syntax highlighting, or readable SQL code. That’s not really an elegant solution.
Let’s get [...]