Staring in SQL Server 2000, I have published a series of 5 books on database design for Apress. You can find the latest here:
One of my most and least (it was a grueling project!) favorite projects is this book that Tim Ford and I wrote on the Dynamic Management Views for Red-Gate. While it has been out for nearly 8 years, it is still a great reference for the base DMV objects. The e-book is available for FREE from Red-Gate, or you can purchase a dead tree version from Amazon.