Database Engine Architect InfoCenter

In Microsoft SQL Server 2005, 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 Designing and Creating Databases Using XML in SQL Server Using Native XML Web Services in SQL Server 2005 Moving Data Detaching and Attaching Databases Integration Services Overview About Bulk Import and Bulk Export Operations Scalability Configuring High Availability Hardware and Software Requirements for Installing SQL Server 2005 Federated Database Servers Partitioned Tables and Indexes

More InformationSQL Server Database EngineInstalling the Database Engine Installing the SQL Server Database Engine Running Setup from the Command Prompt Installing SQL Server 2005 Components Installing SQL Server Analysis Services Installing SQL Server Integration Services Installing SQL Server Reporting Services Security Security Considerations for SQL Server International Considerations Working with Unicode Data Working with Special Character Encodings Working with Collations Tutorials and Walkthroughs sqlcmd Utility Tutorial SQL Server Management Studio Tutorial Troubleshooting Troubleshooting an Installation of the SQL Server Database Engine Troubleshooting the Database Engine External Resources SQL Server TechNet