Microsoft SQL Server

Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this section you will find information for several versions of SQL Server. You will find articles on database and database application design, as well as examples of the uses that SQL Server can be put to.

SQL Server 2008, the latest version, includes enhanced XML support, integration of .NET Framework objects in databases, improved integration with Microsoft Visual Studio and the Microsoft Office System, as well as improved analysis, reporting, and data integration services.

SQL Server Programming Reference

Programming Reference

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

The following features and technologies allow you to develop applications that access data in a SQL Server database.

Programming Reference Sections

Common Language Runtime (CLR) Integration Programming Concepts

Native XML Web Services Concepts

SQL Server Native Client Programming

SQLXML 4.0 Programming Concepts

WMI Provider for Configuration Management Concepts

WMI Provider for Server Events Concepts

WMI Provider Events and Errors

SQL Server Management Objects (SMO)

SQL Distributed Management Objects (SQL-DMO)

Database Engine Extended Stored Procedure Programming

Data Collector Programming

Exception Message Box Programming

ADOMD.NET

Analysis Management Objects (AMO)

ASSL

OLE DB for Data Mining

Integration Services Developer's Guide

Replication Developer's Guide

Reporting Services Developer's Guide

Other Programming Resources

Developing a data-access application may require you to use one or more of the following technologies:

Accessing Data in Visual Studio

SQL Server 2005 Driver for PHP

JDBC