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

T-SQL Tuesday 4: Io, Io, it's off to disk we go

Io was a nymph. True story. Apparently, her father was some kind of river god. In modern times that means you’re likely to catch fire. Back in the days when the Greeks were in charge of things being a river god meant that you were somebody (the Greeks thought the earth was a giant brass [...]

March 9th, 2010 | Tags: , , , , , | Category: nonsense, syndication | 6 comments

My MacGyver Moment

David Stein started this current blog meme. He passed the buck on to Brent Ozar, who shared a horrifying tale of his time in the trenches as a developer. Brent then thoughtfully pointed at me and demanded that I carry on the blog meme torch.
Blog memes are great. They give me an opportunity to pretend [...]

March 2nd, 2010 | Tags: , , | Category: Code, syndication | 5 comments

How the Hell Did I Get Here?

Paul Randal started this chain post. He tagged Steve Jones who, in turn, tagged Jack Corbett who finally tagged me. I’m pretty sure everyone who nominally makes sense has already been tagged at this point thus leaving Jack to scrape the bottom of the barrel.
Like Jack, I think I could approach this in a number [...]

January 19th, 2010 | Tags: , , , , , , | Category: nonsense, syndication | 16 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
 
  Older Entries »