Strictly talking INSERT, and nothing else. Assuming the data being inserted is coming from an identical structure. That structure does, in fact, have foreign keys in place. Those keys are...

Pretty sure the answer to using the Microsoft backups is that your choices are:

• Portal
• Powershell
• Azure CLI
• REST API

That's per the documentation.

The issue is simple, that stuff is...

OMG. I'm so sorry. Deleting my responses. Reading is fundamental and I have failed.

You can use Extended Events to capture the statements executed. If I was doing this one, I would capture rpc_staring, sp_statement_completed and rpc_completed. All three filtered to the object id...

Just my 2ct: did you try to checkpoint all databases before running the backup ?

btw: We mostly produce local backup files and only copy those afterward to a safe...

<deleted>

• This reply was modified 2 weeks, 5 days ago by  Grant Fritchey.

Well, doesn't sound ideal then. Still, might be worth a test.

Something entirely different to look at would be to add the use of a columnstore index. Those things are specifically built to work with analytical style queries like this. You...

<deleted>

• This reply was modified 2 weeks, 5 days ago by  Grant Fritchey.

Interviewing for open position...

My boss: Rate your SQL skills & knowledge on a scale of 1 to 10.

Interviewee: 7 or 8

Me: Let's talk about backups and restores.

Interviewee: I have...

Clean up was pretty severe. I dropped a bunch of repos, including one empty one. Don't ask. But yeah, I really let that slip.

And when my mother-in-law passed, we went...

Suggestions? Not as such. Meta data is really going to be the only thing you can do, so it's a good place to focus.

With Azure MI, yeah, you can restore using T-SQL. Microsoft documentation on it is pretty thorough. You will have to figure out how you want to secure your Azure...

I suspect the answer is no, but you know, the best person to ask would be Steve. Pretty sure he has open DMs here on the platform. Send him a...

Generally speaking, it all goes through one person, Steve Jones. I don't think he has a team checking things out like that.