To add to what Grant said, I would also like to know why you think that is a "common database maintenance task"? My opinion, database maintenance tasks include things that...

I've not set something like that up before, but I'd try taking different things out of the equation. Can you query it without using powerBI? or is it slow if...

My first step would be to check the MS documentation - https://learn.microsoft.com/en-us/sql/relational-databases/replication/troubleshoot-tran-repl-errors?view=sql-server-ver16

But in your specific use case, I think you are stuck between a rock and a hard place. If...

To play Devil's advocate, I would say it really depends. If you are currently employed, what does your employer use? I know at my workplace, we are not using SSAS...

We have a policy at our company that the C# code must call stored procedures to get or manipulate any data. It gives us better tuning opportunities and allows us...

I agree with Jo Pattyn - this looks like a duplicate of that other question and my advice is still the same. If you want to track changes, you need...

First question I'd ask is "what problem are you trying to solve by putting the Excel data into SQL Server?". How will putting the data into SQL Server help you?

But...

DBA's should be involved in database design (my opinion)... otherwise what is stopping a developer from making tables that are not normalized or using bad datatypes (TEXT for example)... Makes...

Every time I have seen "Attempting to use an NT account name with SQL Server Auth" it means that my SQL instance is set up for Windows Authentication (instead of...

To me that is a good argument to move it from MySQL to MSSQL. That is one of the use cases where I'd do the migration.

As for the database schema,...

This is actually pretty easy to do and Microsoft even has a writeup on it:

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-total-to-a-group-or-tablix-data-region-report-builder-and-ssrs?view=sql-server-ver16

The steps are:

In the tablix data region row group area, right-click a cell in the column...

@ScottPletcher I do agree that triggers and CDC are not necessarily performance killers, but they do impact performance. I haven't set up CDC, so I am not sure what the...

If memory serves, CDC is not trivial to set up and it can be a performance suck as well.

My opinion is still that targeting the stored procedure or application code...

To add to what Ant-Green suggests (dumping to flat files), that also would allow you to build a proper schema for it. I've seen some of the automated tools for...

My opinion, the easiest way to set this up (as a SHORT TERM thing) would be an after update trigger then. I say short term as triggers are "hidden problems"...