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...

Looking at the docs for the Microsoft Oracle Connector, you can use LDAP for authentication - https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connection-manager?view=sql-server-ver16.

It states that you can pick to use Windows Authentication or Oracle Authentication. Windows...

thx Brian.   Unfortunately you are seeing a mention about the speed issue out of context.   I was just trying to find COMMIT size here like i believe we used...

One thing to note about things being slower when run over VPN in SSIS, slower than where? Slower than the exact same workstation (laptop/desktop) being on site OR slower than...

I have not tested this script, but what about this link:

https://eitanblumin.com/2021/05/11/t-sql-tuesday-138-sp_help_revlogin-is-dead-long-live-sp_help_revlogin2/

Eitan Blumin has a script that he claims works to move logins and users across different systems. NOTE I have...

I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful with...

I wonder if it is impatience on Steve Jones's part OR a configuration thing? I can't remember if the SQL services are set to auto-restart on unexpected stop or not,...

Index Optimization: Review and optimize indexes to ensure they complement the new primary key and do not degrade performance. Data Integrity Checks: Implement regular checks to ensure data integrity,...