SQLServerCentral.com Content tagged Database Design, Basics, Administering, SQL Server 7, 2000http://www.sqlservercentral.com/Content tagged Database Design, Basics, Administering, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Data Dictionary from within SQL Server 2000Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Beware of Mixing Collations - Part 1A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article. http://www.sqlservercentral.com/articles/Administering/collate_part1/875/2002/12/19http://www.sqlservercentral.com/articles/Administering/collate_part1/875/Bill Wunder's DDL Archive Utility Launches as FreewareBill Wunder has donated his utility for those who have a free SQLServerCentral.com mebership. The DDL Archive Utility will look into a database and automatically archive the DDL from the database into Source Safe saving hours of hassles! http://www.sqlservercentral.com/articles/Administering/729/2002/07/11http://www.sqlservercentral.com/articles/Administering/729/Data Dictionary from within SQL Server 2000Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Design Oversight - Preliminary ReviewWe all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design. http://www.sqlservercentral.com/articles/Administering/designoversight-preliminaryreview/414/2001/08/20http://www.sqlservercentral.com/articles/Administering/designoversight-preliminaryreview/414/