Database Engine Information Worker InfoCenter

In Microsoft SQL Server 2008, 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 Designing Database Diagrams (Visual Database Tools) Designing Tables (Visual Database Tools) Designing Queries and Views How-to Topics (Visual Database Tools) Languages Transact-SQL Reference (Database Engine) XQuery Language Reference (Database Engine) Tools Features and Tools Overview (SQL Server 2008)

More InformationDatabase Engine ConceptsInstalling SQL Server 2008 Initial Installation (SQL Server 2008) Installing SQL Server 2008 Components Considerations for Installing the SQL Server Database Engine Tutorials and Walkthroughs Tutorial: Getting Started with the Database Engine Tutorials Tutorial: Writing Transact-SQL Statements Tutorial: Database Engine Tuning Advisor Tutorial: sqlcmd Utility Troubleshooting Troubleshooting an Installation of SQL Server Troubleshooting (Database Engine)