http://www.insidesqlserver.com/ -- SQL Server Magazine
http://www.brainbuzz.com/topsites/default.asp?CatID=1 - Great Certification sites on the Web
These are sites that I find are useful for someone learning about/wanting to know more about SQL server.