Can you connect using other tools? The error tells you what is wrong though - Visual studio can't see the server. If I had to guess, I would say firewall,...

To add to what Frederico_fonseca said, we don't even know what tool you are importing the data to/from. You say "ETL", but is this SSIS? I think so, but not...

Just trying to eyeball your deadlock, it looks like the deadlock is caused by a python script. Quick review of the deadlock XML, it kind of looks like you are...

I know a lot of discussion has already happened on this, but I wanted to point out that it would be nice to see the actual vs estimated execution plan....

As far as I am aware, you can make the SSIS package in newer versions of VS, you just can't deploy IF the version is too new.

For example, I have...

Have you tried connecting by IP instead of server name set up in the hosts file? I am wondering if SQL Server Engine doesn't "trust" the hosts file and is...

One thing to point out though about the hashing approach and indexing on it though - is that index useful? You likely are not searching by the hash and are...

To add to this, settings for parallelism are not some "magic" number that can be applied across any environment. If it could be recommended with little to no information, then...

Yep. Lets say you are doing an update on a table or insert which requires an exclusive lock on the table. Having the query go parallel creates self-blocking as you...

Another thing - is there a query hint to put the MAXDOP to another value? I know you can set that at the instance level, database level, and query (or...

Your powershell is wrong for that. Your convert to HTML call is happening outside of your loop. You will need your convert to HTML to be inside the loop AND...

The only thing I can think of is user permissions. Likely something with permission chaining or delegating permissions (not sure if those terms are correct, but I think so). I...

Possibly a dumb question but is your new laptop domain joined and on the corporate network (VPN or on site)?

xp_cmdshell runs server side so you would need to be able to browse the directory from the server side not your local dos command line.

My opinion though - SQL Server...

I did a quick google on that wait type as I had never seen it and was curious and it sounds like it is not exactly related to memory, but...