You should know by now that you need to post consumable sample data and expected results. I'm sure there's a way, yes, but help us help you. When you post...

Personally I tend to also do ELT as well, for the same reason that many have listed. i tend to find that doing toe transformation with T-SQL is far far...

I'm not quite sure I understand your question here. Are you looking to to create an SSRS report which takes a username as input, to see what reports they can...

This is unclear at the moment. can you provide your sample data in a consumable manner (have a look at the link in my signature), but also provide your expected...

When you deploy projects to the SSISDB the package, and projects are deployed unencrypted (well, they are still encrypted, but so that only SQL Server can read them). It tells...

SELECT * FROM MyTable;
If that statement is returning no results, it's because there are no rows in the table MyTable. If, prior to that, you are inserting into that...

Best person to speak to his your software vendor. They will be able to give you a much better cost analysis.

The reason it's taking so long is because using REPLACE is making the query non-SARGable, thus the (poor) data engine is having to scan every row, and applying the REPLACE...

Duplication of https://www.sqlservercentral.com/Forums/1927469/Limitations-in-Azure-Database-for-SQL-Server.

had this issue plenty of times. I make a habit (now) of typing everything, and then the last thing I do is add the hyperlinks. The only problem is if...

Out of interest, why do you want to use PHP to do the loading of an xls(x) file? A proper ETL tool would be better instead.

Sounds like you have caching or snapshots enabled. What is the settings on the Snapshot Options, Report History and Cache Refresh pages on the report?