I’ll be in France and largely AFK for a few weeks this summer, so I’m posting some golden oldies. You can find the original article and comments here. As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to new filepaths. The answer, in short, is: RESTORE […]
Category: sql server
The Week in Awesome – Plugins, Cars, Food, and France
This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool. Google has created a prototype of a totally self-driving car. It looks like a toy, but feels like the future. As long as we’re talking about cars, go look at The Oatmeal’s great […]
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when you take a database backup, and restore it to a different server. Microsoft provides us with the ever helpful sp_change_users_login to find and repair orphaned users, but even so, it’s kind of a PITA* manual operation. […]