Is there a data dictionary showing the relations between tables? If so, where can I find this?
I'd like to become more familiar with the schema :)
is this related question the best/official post to look at for the information?
Not really, although all of the relations follow a pretty self-evident naming pattern of
In the meantime, the post you've linked to is probably the best source of supplementary information for the schema, although it's a bit out of date. The schema in the side bar of the query editor on Data Explorer is generated from the actual table metadata, so it's ultimately the most authoritative source.
*The code might be transitioning to GitHub in the near future, which should hopefully make this easier
Found this pretty useful site... not sure how up-to-date it is though.
http://sqlserverpedia.com/wiki/Understanding_the_StackOverflow_Database_Schema, there is also a SQL script on importing the data-dumps, but as I found out, there is a 2GB limit to SQL Server importing XMLS, so i'm still out of luck on that front. Eitherway, it's a very helpful resource.