Database Engine Architect InfoCenter

In Microsoft SQL Server 2008, a Database Engine architect works in conjunction with application architects and system architects to design a data storage infrastructure that will support the processing requirements of the enterprise. The Database Engine architect decides the technology used for the data storage systems, and coordinates the interactions and interoperability between data-driven systems and Web sites within the enterprise. The Database Engine architect is a solution-level decision maker who provides vision and scope to data-driven projects, and has job titles such as Data Architect or Database Architect.

To help an architect be as effective as possible, the following lists provide links to the topics considered most useful in understanding how to use the different versions of the Database Engine to meet all of the levels of data storage across an enterprise.

Database Design Development (Database Engine) Native XML Web Services Concepts Moving Data Detaching and Attaching Databases Overview (Integration Services) About Bulk Import and Bulk Export Operations Scalability High Availability Solutions Overview Hardware and Software Requirements for Installing SQL Server 2008 Federated Database Servers Partitioned Tables and Indexes

More InformationSQL Server Database EngineInstalling the Database Engine Considerations for Installing the SQL Server Database Engine Installing SQL Server 2008 Components Considerations for Installing Analysis Services Considerations for Installing Integration Services Considerations for Installing Reporting Services Security Security and Protection (Database Engine) International Considerations Working with Unicode Data Working with Special Character Encodings Working with Collations Tutorials and Walkthroughs Tutorial: sqlcmd Utility Tutorials Troubleshooting Troubleshooting an Installation of SQL Server Troubleshooting (Database Engine) External Resources SQL Server TechNet