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

Links for the Week of 2009-03-13

SQL Server
SQL Server and NULL Values, Revisited Aaron Alton takes a good look at NULL values and makes reference to post on the same topic. They both provide good information and well-founded opinions on NULLs and their place in the database.
Does a GUID make a good clustered key? This is a subject that is [...]

March 13th, 2009 | Tags: , , , , , | Category: SQL, SQL Server, nonsense, sqlpass | Leave a comment

Links for the Week of 2009-01-16

SQL Server
Re-associate SQL Users with Logins Scott Koon put up this script a while ago (back in ‘07), but I had cause to use it this week. When you restore a database from a backup taken on a different machine you’ll need to re-associate users with their logins. Easy. Done.
Scripting Server Permissions And Role Assignments [...]

January 16th, 2009 | Tags: , , , | Category: Code, SQL, SQL Server, nonsense | Leave a comment