Keep an Open Eye » Open Source Database Designer

Keep an Open Eye » Open Source Database Designer: "Fabforce.net has produced a very practical database designer utility that allows users to create EREntity Relationship database model diagrams either from scratch or reverse engineered from existing databases. The types of databases that DBDesigner natively connects to includes MySQL, Oracle, SQL Server, and a host of desktop databases through ODBC. The screenshot shows the tool in action with MySQL WordWeb database data (this is a very nifty database of over 100,000 English words) ."

SQL Server 2005 Jobs

SQL Server 2005 Jobs: "I then checked the Application Log for the 2005 job failures since that is what MOM uses. I noticed that when a 2005 job failed, it wasn’t reported in the Application Log.
In SQL Server 2000, by default, the “Write to Windows application event log” “When the job fails” option is checked in the 'Notifications' tab when you create a job in Enterprise Manager.
In SQL Server 2005, this option is not checked by default."

Microsoft TechNet: Microsoft SQL Server TechCenter - Best Practices

Microsoft TechNet: Microsoft SQL Server TechCenter - Best Practices: "SQL Server - Best Practices
Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise from respected developers and engineers at Microsoft as they walk you through the specifics on solving particularly difficult issues."