Might just be me, but is sounds like you are trying to reinvent the wheel. What you are asking for sounds a LOT like a document control tool to me....

Just wanted to add that this isn't a "microsoft defect" as it is the job of the DBA to make sure things are properly sized. I wouldn't blame DELL if...

I think the only way to do this entirely in SQL Server would be with "REPLACE" statements (ie replace <br> with a newline character) and after replacing everything you want...

My first step would be to reach out to your IT dept to see what URL they are trying that is saying that HSTS isn't enabled and verify that the...

Quick google of the answer brought me to this blog post by Pinal Dave (super smart guy!):

https://blog.sqlauthority.com/2017/02/13/sql-server-fix-error-19456-none-ip-addresses-configured-availability-group-listener-can-hosted-server/

That tells you how to fix it, but to quote what he has in...

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