Database Engine Information Worker InfoCenter

In Microsoft SQL Server 2005, a Database Engine information worker is a domain expert who understands the relationships between the data stored in a database and is able to translate the data into business information. Information workers rarely interact directly with primary online transaction processing (OLTP) databases, instead they use the applications that are associated with the database. When information workers interact directly with databases it is typically to run ad-hoc queries or reports against secondary reporting databases, or to work with smaller databases that are distributed with workgroup or personal applications.

To help the Database Engine information worker be as effective as possible, the following lists provide links to topics about understanding database designs, connecting to instances of the SQL Server Database Engine, and querying the data in the databases.

Working with the Database Engine Accessing and Changing Database Data Using XML in SQL Server Designing Database Diagrams (Visual Database Tools) Designing Tables (Visual Database Tools) Designing Queries and Views (Visual Database Tools) Languages Transact-SQL Reference (Transact-SQL) Using XML in SQL Server Tools SQL Server 2005 Tools and Utilities Reference Overview Visual Database Tools How-to Topics

More InformationDatabase Engine ConceptsInstalling SQL Server 2005 Installing SQL Server 2005 Installing SQL Server 2005 Components Installing the SQL Server Database Engine Tutorials and Walkthroughs SQL Server Tools Tutorials Troubleshooting Troubleshooting an Installation of the SQL Server Database Engine Troubleshooting the Database Engine