Technology

MS Project Server and Backup Best Practices

by Jonathan January 15, 2010

Microsoft’s Project is a very standard project management tool that most Project Managers are all to familiar with. While Project is a great application it was limited to local information. Microsoft’s Project Server extends Project’s capabilities and allows the sharing of resources and information across an Enterprise. Project Server 2007 is built around the SharePoint [...]

View Comments Read More…

Separated Environments and Security

by Jonathan November 11, 2009

Managing a corporate environment can be a challenge in its own right but when you throw developers into the mix you have to be careful about their access to the production environment.  A developer should never have access to the production environment.  Colin over at Benchmark IT Consulting has written a great article on this [...]

View Comments Read More…

User and Schema Association after Restore on DR Computer

by Jonathan October 27, 2009

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.

View Comments Read More…

Preparing for a Vacation – Unplugging Part 1

by Jonathan September 8, 2009

Recently my wife and I took a much needed respite from our jobs for a vacation to Cabo San Lucas, Mexico.  As we were packing for our trip I looked at all of the things I was taking.  One of the main things I was not planning on taking was my laptop.  I was going [...]

View Comments Read More…