I'm guessing you have the data source at each site so business can continue even if the connection goes down.

If you had the time and money, I would suggest rearchitecting...

Just a suggestion...

Use PolyServe to virtualize your database instances in production.

Use VMware to virtualize databases in Test and Development.

For pricing reasons... eventually start using Microsoft VMM in Test and Development...

Based on trends I see good things for Microsoft going forward.

http://www.indeed.com/jobtrends?q=oracle+10g%2C+sql+2005%2C+db2&l=

http://www.indeed.com/jobtrends?q=sharepoint%2C+cms&l=

http://www.indeed.com/jobtrends?q=j2ee%2C+asp.net&l=

http://www.google.com/trends?q=SQL+2005%2C+Oracle+10g

http://www.google.com/trends?q=SQL+2008%2C+Oracle+10g%2C+DB2&ctab=0&geo=all&date=all&sort=0

I think I figured it out.

In SQL Server 2005, there is a new option called Page_Verify. In earlier versions of SQL Server, it was known as TORN_PAGE_DETECTION.

Please verify.

Related URL:

Why do you set TORN_PAGE_DETECTION OFF for SQL 2005 servers?

Is this intentional?

SET @sqlstring = @sqlstring + ', TORN_PAGE_DETECTION OFF, PAGE_VERIFY CHECKSUM'

Related URL to the quesiton:

http://www.themssforum.com/SQLServer/Torn-Page-358147/

Scott

Based on the posts I believe the right answer is both. Virtual machines in development and for production databases that need to be on their own operating system. Otherwise use...

There is an inherent IO load on a virtual machine. This is perfectly OK for smaller databases to medium sized database & DBs most database in a development environment. For...

PolyServe

Just tell them to use LINQ.

There are a some GREAT episodes about hiring on the Managers-Tools Podcast that are worth listening to.

How to Handle Pre-employment Testing...

I've used version numbers on the stored procedures to help with the unit testing problem.

sp_getWidgetsByProductId1(int @productId)

sp_getWidgetsByProductId2(int @productId)

Scott

Off topic and honestly not an advertisement.

Mr. Excel has 2 minutes videos that show a new feature of Excel. He has a RSS feed to the videos so they can be...

Did you copy the installation files to the local file system?