Microsoft SQL Server 2000 Developer

SQL Server 2000 is a fully Web-enabled database product, providing core support for XML and the ability to query across the Internet and beyond the firewall. Its features include a data-mining feature called Analysis Services, which lets anyone with SQL and Microsoft Visual Basic programming experience use OLAP tools to create custom analysis applications. Using a middle-tier server, SQL Server 2000 can perform complex analyses on large volumes of data with exceptional data-retrieval performance. Two new features, linked OLAP cubes and HTTP access to cubes, offer powerful data analysis over the Web. In addition to enabling you to extend your analysis capabilities to partners outside the firewall, these features deliver new value by creating opportunities to sell access to your database to new customers over the Web.

SQL Server 2000 extends your e-commerce functionality through rich support for XML, easy Web access to database information, and powerful analysis tools, coupled with high availability and tight security. This means that Web developers can access data using XML without having to do complex programming, and database administrators can manipulate data easily in XML format using Transaction SQL (T-SQL) and stored procedures. Secure HTTP database connectivity ensures that data can be queried--even by relatively inexperienced users--through a URL and intuitive user interfaces. SQL Server 2000 also makes querying from the Web relatively easy. The enhanced English Query tool allows developers to build natural, English-language interfaces to SQL Server in Microsoft Visual Studio. In addition, English Query can now generate Multidimensional Extensions (MDX) to query against OLAP cubes.