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 Kendal Van Dyke shows how it’s possible to script out all permissions and roles assigned to the users of a specific database. Good things in case you’re regularly in the habit of nuking your database and rebuilding it.
Amazon Web Services Explained Brent Ozar manages to explain Amazon Web Services in a way that makes sense to me. After reading this post I finally understand why I would use AWS apart from storing massive quantities of data that I never need to view again. iBusiness Intelligence – Business Intelligence 2.0 with an i for Design Rob Paller talks about the Mint.com iPhone application and how their UI ideas should be applied to other forms of BI. Apocalyptic Machine Scultpures are Wonderful in a Morbid, Sinister Sort of Way Like the people at gizmodo said, “Kris Kuksi probably had a disturbing childhood (or dropped acid in graveyards). But it doesn’t make his pieces any less awesome.” I am fascinated by art that’s built up from a combination of different imagery, there’s something compelling about Kris’s work. Enjoy.