October 2009

User and Schema Association after Restore on DR Computer

I was faced with a situation I have yet to encounter as a DBA. I don’t know why I have yet to find this but I will write about it anyway. I have been working on a side by side upgrade/migration project going from SQL Server 2000 to SQL Server 2005. I have the two boxes configured but in the upgrade we are also going to have to correct some ‘error’ in security. It is because of this fact that I just can’t migrate the master database and get all of my user associations back working together.

0 comments More…

Embracing and Enjoying the Freedom – Unplugging Part 2

Embracing and Enjoying the Freedom is part two of our Unplugging series of posts.  When being freshly unplugged it is natural to feel like something is always wrong.  The iPhone or Blackberry you keep in a death grip can be replaced by a frosty beverage of choice.  Americans are struggling with an addiction to technology.  [...]

0 comments More…