I do like the attempt at making things accessible. However, I agree, it's not working well enough with the current level of technology.

You could get away with using the older version, yes. I wouldn't. But you could. Stuff has been added, not taken away.

Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one of my accounts,...

The first execution time is stored with the query, and isn't the start time. Instead, it's the time of the first execution of that query. That value could be weeks...

Since the memory allocation is based initially on the query, database objects, and the statistics on all those, put together through the query optimization process, you can see exactly the...

As someone without a computer science degree or any certifications of any kind (except for a couple back in 1995, which are maybe a tad out of date at this...

It 100% depends on what code you have implemented. Yes, there are changes between RDS 11 and 14 in PostgreSQL. You will need to test your system and your code....

What are you pricing? Azure SQL Database? Azure Managed Instance, or just Virtual Machines?

(as to the spam, probably not. I see a lot of people ask the exact same question...

You're asking about a MySQL database on a Microsoft SQL Server forum... in the Reporting Services section. There is a MySQL section: https://www.sqlservercentral.com/forums/forum/sql-server-and-other-platforms/mysql

You may get much better answers there.

Have...

You'd be better served by...

If you do go to Azure SQL Database, while there are cross-database queries possible, the architecture is very different from any other implementation, so that will be a somewhat limiting...

Bacpac will not capture active transactions. So if you start a bacpac and while it's running some number of transactions complete, they won't be a part of the bacpac. It's...

Probably powershell. Run a scheduled check that can read the table list and compare it to a list of files. Have an IF statement that then fires off additional commands.

Then why not a table with Hotel,...

Be cautious about building this kind of catch-all query. Here's some great advice from Gail Shaw on the topic. Note that she has multiple posts on the topic. It's...