I am not a DBA, but an end user that mashes together data from various databases within my company to generate insights.
When I first encounter a new (to me) database, I spend time scrolling through the tables/views/columns in SSMS or Power Query to understand what data is in the database, and how it is structured. This is a manual process, and I may overlook key tables when scrolling through a long list.
Is there an easy tool that can scan a database and visually represent the database structure? I believe older versions of Visio could reverse engineer a database and generate a database model/entity relationship diagram, but the current version does not. If it matters, the databases in question are all MSSQL