My opinion - that's pointless. Statistics tell you information about your table data. If the table is empty, the statistics are (mostly) useless. You need data in the table for...

100% agree with Drew here and in your specific scenario, JOIN may perform better or worse. My advice is to test on your system as is (ie don't add extra...

With desktop versions of windows, if you see 90%+ memory being used, (14.5/15 GB), that is a good sign stuff is being paged to disk. Windows tries to not let...

Personally, I would test. If you to to your SSRS instance, can you "export" or "download" a folder? I cannot, but I'm also not on 2016 (I'm on 2012... I...

Your reports are NOT stored inside the SQL database if I remember right. It is metadata and jobs that is in the database side. So if you don't back up...

My advice - check the docs first. ALWAYS ALWAYS ALWAYS check the official docs as things MAY change between versions. Link to 2022 - https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver16

As for the sysadmin, I would...

As a different approach, any chance you could spin up SharePoint? It solves most of your problems as it allows for file storage, quick searching (no need for ElasticSearch), auditing...

My understanding is upgrading from standard to enterprise is something that can be done without issue.

Now, that being said, I would STRONGLY encourage you to do the transition on a...

My best guess is permissions or firewall. I imagine there is another log somewhere (windows event log for example) that contains more information about why it failed.

Looks like something is...

If writing your own stuff is not what you are looking to do, then the next best bet is a 3rd party tool. SSIS doesn't natively connect to NetSuite. But...

My opinion - it depends. The whole point of the report part is to make sure things can be converted (if I remember right). So you can skip the report...

Is the file it is looking for local or on shared storage (network drive)?

If it is shared storage, you SHOULD be using the FQDN path to the file instead of...

If I am not mistaken, C# scripting allows you to pass more parameters to the datetime.tryparseexact() function. Needs more parameters, but that'll allow you to set the exact format for...

The username and password stored in the ODBC can be different than in the SQL Job, depending on the configuration you set up there. With ODBC connections, the configuration is...

Maybe I am a bit out to lunch here, but shouldn't your primary and secondary instances be the same name and have the same path to the system files but...