Database Engine Developer InfoCenter

In Microsoft SQL Server 2005, the Database Engine developer role covers the full range of developer interaction with the Database Engine. Many types of developers, such as database designers or Web site developers, work with the Database Engine. For more information, see Database Engine Developers and Administrators.

To help Database Engine developers be as effective as possible, the following lists provide links to developer concepts and reference material for languages, object models, and APIs used to develop databases and data-driven applications and Web sites.

Application Design Concepts Building Database Objects with Common Language Runtime (CLR) Integration Building Applications with SQL Native Client Handling Errors and Messages in Applications Elements of Transact-SQL Procedural Transact-SQL Changing Data in a Database Manipulating Result Sets Tuning the Physical Database Design About Bulk Import and Bulk Export Operations Database Design Concepts Understanding Synonyms User-Schema Separation Query Fundamentals Query Tuning Locking and Row Versioning Batch Execution Environment and MARS Tables Partitioned Tables and Indexes Views Stored Procedures DML Triggers User-Defined Functions Languages Transact-SQL Reference (Transact-SQL) XQuery Against the xml Data Type Data Access Programming Database Engine .NET Framework Programming SQL Native Client Programming Administration Programming SQL Server Management Objects (SMO) DDL Triggers Event Notifications WMI and SQL Server Tools Database Mail Service Broker SQL Server Notification Services sqlcmd Utility SQL Server Management Studio

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 Writing International Transact-SQL Statements Programming Database Applications That Use Unicode Setting and Changing Collations Working with Special Character Encodings Tutorials and Walkthroughs sqlcmd Utility Tutorial SQL Server Management Studio Tutorial Best Practices CAST and CONVERT (Transact-SQL) Troubleshooting Troubleshooting an Installation of the SQL Server Database Engine Troubleshooting the Database Engine External SQL Server Developer Center