My first thought would be blocking by another resource, so I'd focus there. However, it's possible that a recompile event leads to differences in the execution plan. Capture it when...

As long as you're capturing rpc_completed or sql_batch_completed, you're capturing the incoming calls. However, triggers could fire and affect things and you won't see them as such. Instead, you have...

Couldn't you just UNION the two together?

I'd suggest focusing primarily in the area of DevOps. Automation as administration or administration through automation if you like. I think this is the area that is most challenging, most...

Sounds like the backup is corrupt. It happens. It's part of why validating backups is so important.

I used the feedback link. There isn't...

Sorry about that. I was able to replicate your problem. It looks like some sort of bug. From what I can tell (and I haven't tried setting up extended events...

Wait though.... That doesn't make sense. Hang on. More testing needed.

So here's the deal, the Azure Query Editor window doesn't allow you to highlight a query and run it in parts. It runs the whole query as a single statement....

So I understand, your first table has a unique constraint consisting of two columns, but you're trying to set up a FK relationship to only one of the columns? You...

So mirroring won't work from 20 different databases into 1 database. If you want to do something like that you're looking at either building your own tool, or using