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.


Google Reader
Google Profile
delicious

O/R-Ms: Panacea or Polio Braces?

In case you haven’t heard, there is a huge difference between the way that software developers and database professionals operate – there are accepted use paradigms and development methodologies for both worlds. Unfortunately for everyone, they don’t match up. Object-oriented programming languages operate on single entities: objects. Databases work with sets. Objects sometimes have relationships [...]

January 5th, 2010 | Tags: , , , , | Category: Code, syndication | 18 comments

Getting the ISO Week and Year

Long story short: I need the ISO Week. We need to be able to make sure that when we’re reporting, we’re pulling data for the full week (which happens to coincide with ISO Week at my employer).
The problem with using an existing function is that the existing functions just return the week and not the [...]

December 29th, 2009 | Tags: , , , , | Category: Code, SQL Server, syndication | Leave a comment

text TEXT teXt?

The Problem
A reader ran into a problem on an old post about Automating T-SQL Testing. Thankfully, rather than decide that I’m some useless crank on the internet, this reader took the time to write in to me and tell me about the problem. But, he went one step further: he documented step by step his [...]

August 28th, 2009 | Tags: , , , | Category: Code, SQL, SQL Server, syndication | Leave a comment

So Much Slacking, So Little Time

I’ve been slacking on the blogging front. Which is a shame, because I’ve been busy doing some really fun things recently. Want to know about one of them? I hope you do, because I’m going to talk about it regardless.
I spent last weekend at the Columbus Give Camp. What was the point of this? Well, [...]

July 22nd, 2009 | Tags: , , , , | Category: Code, syndication | 2 comments

Columbus Give Camp is Just Two Weeks Away

The Columbus Give Camp is only two weeks away but it’s still not too late for both charities and volunteers to sign up.

GiveCamp is a weekend-long event where software developers, designers, and database administrators donate their time to create custom software for non-profit organizations. This custom software could be a new website for the [...]

July 2nd, 2009 | Tags: , , , , , , | Category: Code, SQL, Visual Studio, sqlpass, syndication | Leave a comment