Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...

Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware.   Read more...