A convenient way of browsing object descriptions from within SQL Server Management Studio.
SQL Server Articles
4 options you have to edit column descriptions in SSMS and 2 for describing tables.
A tutorial that shows how to document SQL Server database with Visual Studio and then export it to PDF and HTML.
Practical guide on creating ER diagrams with Microsoft SQL Server Management Studio (SSMS).
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a method to measure your database.
List of SQL queries for SQL Server Catalog / Data Dictionary handy for any DBA.
A comparison between two database documentation tools - Dataedo and Redgate SQL Doc.
Short tutorial on how to quickly generate documentation for your SQL Server databases with free edition of Dataedo. Part 1 of series of tutorials that show the power of Dataedo to document databases and manage database complexity.
What is Data Dictionary - explanation of its two meanings.