The Database Tuning Advisor is an actively dangerous tool to use. It makes a lot of recommendations. Most of the time, they're useless. You can see right there in the...

Hmmm... Sorry. I can't think of anything else it could be. A backup includes Query Store and there's no step you have to do or command or anything. It's just...

Everything that Jeff says, plus, under resourced servers, network configuration issues, and a whole slew of other system, network, OS, or server configuration issues. Just based on the information, "things...

If Query Store is enabled on a given database, when that database gets backed up, the information within Query Store will also be backed up. No extra steps are necessary...

Although, we do have a MySQL forum. It doesn't get much love though. I'd post any further MySQL questions there. You're more likely to get people who know about...

The only way to make a query without any filtering run faster is by purchasing bigger, faster, hardware. There's no magic that can be done when you move everything. Jeff's...

The plan didn't upload, so it's going to be really hard to make a suggestion without the plan or the query.

Obviously I agree with that principle, as a general rule. Would you say...

I am not an Azure Analysis Services expert by any means. However, Azure SQL Database, I believe part of the underlying architecture, doesn't support Profiler/Trace. Instead, you must use Extended...

In a key lookup operation, what's being looked up is not the key value, but other values. The clustered key value is actually already a part of the nonclustered index....

Check out the ISNUMERIC() function. That will tell you what you want to know.

Strong advice: all tables, all databases, all the time, use appropriate data types. It really matters.

The best licensing answers are always going to come from Microsoft itself, not some Yahoo on the internet.

That said:

1. Microsoft is going to argue, and I'm pretty sure legal case...

I'd have one word:

Don't.

That's the best advice on how to store a file inside SQL Server.

Can you do this? Yes. The link provided above will give you the details. Should...

You can't just change the IP address locally. That has to go through however you're administering IP addresses within your system. Then, yes, once that IP address changes, you'll have...

You may not have...