Availability groups and read only secondaries are, I think, supported on managed instances. That would be a solution.

It completely depends on what we're talking about when we say "Azure". So, if by Azure you mean Virtual Machines managed on Azure, it's just SQL Server instances and everything...

Second vote for Redgate SQL Monitor. That will do everything you're asking for.

However, if you really want to build it yourself, look to Extended Events. You can use...

Generally SQL Server will consume every bit of memory it can and hold on to it. That your'e seeing it go up and down is more concerning than that it...

Sorry. I don't know of a good and free tool. If you want a good tool, Redgate SQL Doc is the way to go.

Nothing in the backup and restore would make the query run faster. However, what you're likely seeing is the result of a new compilation of the query, possibly with different...

For the tools, SQL Server 2017 has separated the tools install from the server install. If you need the new tools, you have to track them down separately.

Man, I'm sorry. I've got nothing. You might be looking at some kind of bug.

The only way that stats won't exist is if there is no data in the table when the index gets created AND you have turned off auto-update stats AND you...

You can query the sys.sql_expression_dependencies to find that information. Here's documentation on that. I would also suggest you look into setting up a continuous integration process for your...