I did not know about the encryption algorithm changing.

This might mean the need to unencrypt the database before moving it and then re-encrypting it after the move.

You don't have to test. I trust that two people telling me this is possible means it's probably possible.

Thank you both for your answers.

Those databases actually live on one of our database servers. When we initially did the install (this was one of the first 2012 servers we stood up), we thought they...

Not sure how well I'd get along with home working, and not sure how well it would do with my whooping 10Mbps down and 1 Mbps up internet.

As a...

So this is a side-by-side upgrade instead of an in-place (direct upgrade of current instance)?

Just verifying before I try to answer the question.

Because we are always looking and Allstate does let tech employees work from home (subject to certain caveats, depending on the division)… Careers @ Allstate.

Thanks, Grant.

We don't ever allow our Devs access to Production. What we do for them, however, is create a "production copy" database on a daily basis down to a...

Developers could certainly have read access to production data. If a production change needs to occur to data for whatever reason, the production change should be done by an...

The Update Failed message reminds me of when I was a database developer some time ago working with Oracle, and the DBA's there programmed some automated job that...

We actually force our devs and even us DBAs to use a non-production copy of the database to test any data changes before moving them to production. In fact, most...

1976.

@=)

When Jacksonville hosted, the big news was that we didn't have a large enough prostitute industry to support the game. There were people literally bused in from Atlanta, Miami, etc....

Does the SSIS time go down if you...

The login he's using is his own Windows account. See the end of the second post where I maybe not clearly mentioned it and indicated he wasn't going to get...