Jeremiah Peschka

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

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