Your best bet is to run this from sqlcmd and output to a file or use PoSh to do this. T-SQL doesn't give an easy way to save results to...

It's for plotting. Lots of people doing data anlysis with R, Python, etc. do not use Excel or Power BI.  Those are good tools for data analysis, but in a...

Lol, I still buy some, but not as much as I expected. Spotify has really been something I enjoy using to explore a variety of artists.

If you can't follow Jeffery's advice, what I would suggest is you examine your data. You should have some idea of what the uniqueness of a data should be. Email...

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...