Well that's an interesting question. I would think you could, because the backup encrypt docs say use CREATE CERTIFICATE. That can be used to import a third party cert, so...

I agree with Grant, but one thing I'd suggest is take a backup of all databases on the previous instance and restore them on the new one (or use dbatools...

Not sure if this is correct, but I see this: "Any combination of valid query hints can be used in a plan guide. "

in https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms189854(v%3dsql.90)

No 2005 instance to test, but...

Odd - I always found my peers in the Oracle world quite helpful on various boards & forums, even back in the days of usenet groups. There's always a...

You are welcome and again, apologies for this. There were some configuration items that weren't set for all users, but were set for many, which threw off this as an...

Looks like all posts are in UTC. Checking to see if we can alter this.

Not sure, adding a post to check my time.

:P, you could always advocate for this.

Thanks for the note. Bug closed.

That message indicates your IO subsystem is overloaded. It cannot handle the load. This could lead to things taking longer, which could mean more concurrency in tempdb.

What is abnormal? Do...

I agree with Lynn. Use a DDL trigger here that will read metadata to build the changes needed for a table to replicate it.

What I'd do is create a process...

We think we've found something that might cause this to occur. I hope a fix will come out soon. Will post a note when I see the deployment.

Use IPSec at the network layer (or VPN tunneling).

Look at unpivot

https://www.sqlservercentral.com/articles/an-alternative-better-method-to-unpivot-sql-spackle

Great point, Ralph. Note that PowerShell and Python are also great text processing utilities as well. Learning some of the Unix, PoSh, or Python skills can be very handy for...