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.

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 [...]

Links for the Week of 2009.12.04

SQL Server

Kendal Van Dyke: Delegation: What It Is And How To Set It Up – The title says it all, folks.
wmarow’s disk & disk array calculator – Storage calculator. This wouldn't be terribly fascinating, except I know the performance characteristics of our I/O subsystem and when I plug in the variables, this is pretty close [...]

The First Ever Log Reader Awards

Starting today, and ending on Friday, October 16th, you can submit a blog post, or series of blog posts, to the 2009 Log Reader Awards.
What is it?
You’re probably asking yourself “What’s a Log Reader Award?” Well, dear reader, a Log Reader Award is an award created by bloggers (myself, Andy Warren, and Brent Ozar) to [...]

Links for the week – 2009.10.02

SQL Server
Developers, use Profiler to profile yourself John Sterrett goes over how to use profiler to profile your own SSMS session.
Toys and Tools Mike Hillwig put together a list of great SQL Server tools.
The ABCs of Management Studio Shortcuts Glory be to keyboard shortcuts
Development
ASP.NET MVC 2 Preview 2 New MVC hotness has been released. Yes, [...]

Links for the Week of 2009.09.12

SQL Server
Optimizing Queries That Access Correlated datetime Columns DATE_CORRELATION_OPTIMIZATION is some good stuff. If you have an InvoiceDate column that happens to be close to the OrderDate column in a related table, and this setting is on, the compiler will generate what could be a much better optimization plan.
Difference between an index and a primary [...]