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.

SQL Server Security – Database Roles

Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any aspect of system administration, database roles are similar to groups in the world of Windows system administration. Just like a Windows group, when a user is [...]

Links for the week of 2008-12-26

SQL Server
Best practices for taking on the DBA role as a developer – Armando Prato covers the basics of what it takes to go from developer to DBA. This is a good article and one that’s very near and dear to my heart since I’m pulling myself away from the development world and into the [...]

Links for the Week 2008-12-19

SQL Server
Cloud Computing and me – TJay Belt delivers the best look at cloud computing that I’ve read yet.
Some interesting affects of Table Partitioning – Kent Tegels discusses some interest side effects of partitioning tables and indexes.
The N pillars of a well built database? – Louis Davidson is in the process of re-working his book [...]

My Firsts

I stole this from TJay Belt. It seemed like a nice change of pace from the SQL shenanigans to
1. Who was your FIRST prom date?
Didn’t go to prom (they don’t have them in Scotland), but I went to my high school dance with a girl named Ashley.
2. Do you still talk to your FIRST [...]

PASS Chapter SIG

A few weeks after the PASS conference finished up, Blythe Morrow (the community coordinator for PASS) contacted me and asked if I would like to help form a chapter special interest group (SIG). I didn’t even need to think about it for a minute, I immediately agreed and am itching to get started.
The focus of [...]