About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.

Archive for the ‘Design’ Category

Links for the Week - 2010.02.12

This is more of a “what I’ve been reading” rather than a link dump from previous week’s RSS feed.
A Plea for Plain English – Tony Davis’s “A Plea for Plain English” rings home with me. Far too much writing is full of heavy, pompous words used purely to make the author feel smarter. Joseph [...]

Links for the Week of 2009.10.30

These are a day late. Sorry about that. It’s been one helluva week.
Also, November 1st marks the beginning of National Novel Writing Month. So, if you’ve had a story inside you waiting to get out, wait no further!
SQL Server

Find the complete call tree for a stored procedure – Linchi Shea shares a perl script that [...]

Links for the Week – 2009.09.25

SQL Server
There’s a three part series (one two three) on migrating databases. I’m sure many people have been through this before. I know I have. About a week before these three posts were published.
Ever wonder when you should use a filtered index and when you should use an indexed view? Yeah, I have too. The [...]

Columbus Give Camp

The Columbus Give Camp site has gone live.
What’s a give camp? Basically, to paraphrase the about page, a give camp is an opportunity for developers to give back to the local community by contributing time and effort to create custom software for non-profits.
How can you help?

Volunteer your time
Let a charity know
Sponsor the event with food [...]

Links for the Week 2009.06.05

Important Note: These are yesterday’s links. Not today’s. That’s why the date is wrong.
SQL Server
Really Search Cache for Execution Plans Jason Strate revists his code that finds the last plan that was used for a procedure.
Reasons for NOT using Varchar(MAX) Pat Wright brings back the argument of why you should or shouldn’t use varchar(max). You [...]