Pro's of seperating ssrs from database server:
More resources available for the database
More control of resources used. Resource management in SSRS is limited
Possible to reboot SSRS without impacting...

You can explore powershell for managing security etc
https://www.sqlshack.com/managing-ssrs-security-using-powershell-automation-scripts/

Maybe it is not your database but your web/app frontend that got hacked?
Your website might execute an addional javascript to provide the tampered content or reroute requests?

cost of threshold is 5 -> any reason for this low number?

A picture would be handy.
Are the constraint lines full lines (all success) or dotted (any success)?

Thanks for mentioning Microsoft's SQL Server Database Experimentation Assistant. Didn't know the tool existed

1.Is it possible to have another server next to the domain controller? Many products refuse to install on a domain controller.
2. Licensing: SQL Server 2017 licensing guide....

When using the oracle oledb driver, make sure to try some batch/buffer memory sizes. Currently working with batchsize 5000 instead of the default.

Try starting it from the program files directory instead of program files (x86)
ssis memory errors

^^ :blink: Thanks for mentioning it. The second bummer is SSDT for Visual Studio 2017 (15.8.1) doesn't support designing packages that contain Oracle/Teradata source/destination. Use SSDT for Visual Studio...

Quite dangerous without a test environment.
1. Can I patch from sp1 to sp3 or it has to be in order? -> usually you can patch straight to sp3 as the...

Thats quite a complex nested view to diagnose.
Maybe it is possible to rewrite currentstatus because you have a group by there.for  R_FormNumber, with probably causes the hash match. Good...

A more recent link about tls 12
What version of ssis?

Regarding "I am ignoring all errors during this process"
May an error cropped up and a full batchsize was not imported? (bulk vs individual loads)

Do you have the create table and create index scripts?
Which indexes and in what fieldorder are those on [dbo].[IncidentFormSearchModel] ?
Does your used index  include IncidentStatus?
What version of...