Then walk through all other roles and groups that the login is associated with. Something has gone south.

Not much data to go on, but that looks like a pretty benign thing. It's had 3 seconds of waits over however long it's been connected (can't see that in...

Also, you sometimes see this kind of thing when thresholds are crossed such that the row counts change and different execution plans get generated. Over time, statistics and data distribution...

Take a look above at the "Stairways" menu choice. Inside there are tons of classes, including several on T-SQL fundamentals. They're 100% free. Go here.

Just for clarification, each execution plan is only, ever, for a given query. Sure, a batch or procedure might have 50 queries, but there will be 50, individual, execution plans...

Is your user in the public role? If not, that could be it. That's required to access sys.dm_os_host_info per the documentation.

Ken is correct, query store only works on the primary prior to 2022.

Yeah, query store is database by database, only, even in 2022. So each database gets it's own store....

Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a...

I don't have a degree. Will I get the degree if I answer the question?

Please, no, don't start throwing hints all over it. Instead, focus on getting the execution plan and understanding what it is telling about how the query is behaving and how...

Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a bacpac, an...

I guess you need to ask yourself, how likely is it that you're going to go back to Week 17 of Year 6 in your 10 years of weekly backups?...

You can do exactly that for the databases. However, there will be the downtime of copying them over to the new server prior to attaching them.

However, the system stuff, logins,...

Same...

Hey all!

Back from sabbatical. Happy to see we're still talking deadlocks. Ha!