https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver15

This question doesn't really make sense. Not sure what you are describing here. Can you provide more details?

1. Look for common column names, make guesses, check data. For keys, you have to determine uniqueness. Ultimately, I think asking questions and finding someone that can query the main...

I used to feel this way. I'll buy music, not rent it. I've changed.

I do want to own some things, and that should be an option. However, I also think...

I think the variation of the word is cultural, or maybe just a version of a techie-acronym-telephone-game.

I think I've heard it as consistent and consistency in different places. The concept...

Thanks and you are welcome. Got a couple more on my list, but looking for suggestions if there are things you want to learn or think others need to know.

The cloud vendors have government certified cloud offerings in the US.

https://azure.microsoft.com/en-us/global-infrastructure/government/

https://aws.amazon.com/govcloud-us/

I wouldn't be surprised if there are vendors offering something similar in non-US spaces.

https://www.sqlservercentral.com/stairways/stairway-to-alwayson

There is no Always On. This is an Availability Group. Use that term to ensure searches and questions make sense.

Then answer Andreas' questions.

Unspammed post. It might have been a report from a user or some glitch in the automated process. Either way, it's fixed.

Do the buildings change often? Honestly, I'd expand on Scott's solution. If there were 20 buildings, or 100, now and they rarely change, I'd just calculate all the distances now...

Scott has given an example, and Erland is right. It depends. Test both ways for your situation.

Phil has good advice. If the patterns aren't consistent, then use REVERSE and find the first occurrence.

All of these products work well for making, compressing, and restoring backups. I'm biased because I work for Redgate, but I'd suggest you download an eval for different ones and...

I think the dev story in the cloud is hard. I've seen people want to use RDS/Azure SQL DB for dev work, but the backup thing causes pain. This still...