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

Archive for the ‘Code’ Category

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

Rounding to the Nearest X Minutes, the Lazy Way

A lot of people use calendar tables. I’ve blogged about it before. They’re incredibly helpful. Now, have you ever needed a table of minutes?
You’re probably asking, “Jeremiah, why the heck would I ever need a table of minutes?” Well, dear reader, I’m going to tell you that. Please stop interrupting.
Let’s say you have a report. [...]

February 24th, 2010 | Tags: , , , | Category: Code, SQL, SQL Server, syndication | 6 comments

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

The PowerShell of the Future

PowerShell Today
Allen White recently presented for CBusPASS about PowerShell. First off, I’d like to say thanks to Allen for driving down from Canton, OH to speak in person. He took the time to stick around afterwards and chat about a bunch of things that were on user group members’ minds.
Allen’s presentation covered the basics of [...]

December 15th, 2009 | Tags: , , , , | Category: Code, SQL Server, syndication | One comment
 
  Older Entries »