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!

I was just troubleshooting a similar issue to find the difference was the default database assigned to the user accounts.  After getting query execution plans for both logins (which...

Yes. You will be hard pressed to find join in any EF tutorials; other than just the places...

PREACH BROTHER!

Writing the final chapter of the book, and the first section...