I could be mistaken, but I am 99% sure that your schema lock is going to prevent the table rename. The rename will only commit to disk after the query...

Just wanted to add to Frederico_fonseca's reply about pings - pings  are not a reliable way to see if a system is up. MOST security experts recommend having ICMP ECHO...

Another thing it could be is firewalls.

If I am reading things right - pulling data from ERP using SSMS (19) locally works fine, but SSMS (20) from the Azure VM...

The aliases must be set up client side, not server side. You can set them up server side, but it doesn't benefit the client to have it set up on...

So it shouldn't need to be set up on the server hosting the SQL instance, just anything that will connect to that SQL instance.

My next thought would be to verify...

I personally have found that the saved connections are often misleading and I've had them get blown out by updates. I prefer to set up registered servers, specifically a Central...

Possibly a dumb question but where are you configuring the SQL Aliases? The aliases need to be configured on ALL instances that are going to connect to the server. SQL...

Just my 2 cents, but this really sounds like interview questions for a consultant to come in and help with.

But to give a quick read on the question, I think...

As a thought (I could be completely out in left field here), but my GUESS is that your DELETE is because you are removing the data before re-inserting it based...

Every time I've seen that error it has been either:

A- typo in server/instance name

B- firewall

C- network issues

A is easy to fix - double check the server and instance name (and...

how much memory does the SERVER have in total and how much is dedicated to SQL Server? If I am reading your question correctly,  you have 300 GB RAM on...

As someone who has had (and currently has) VPN access on their phone AND RDP access on my phone, I do not recommend it. While it is possible, it is...

Just to add to what Jo Pattyn said, there are a lot of reasons why a thing can be fast in SSMS and slow in applications. You could have some...

Just my 2 cents on this - I wouldn't rely on "ping". PING will only tell you that the computer is online assuming ICMP isn't disabled at the firewall. It...

Another thing to note - SQL Server, with the default configuration, will use up to 2 PB of memory or whatever is available in the system. In order to reduce...