SQL Server Developer Edition

author-image
CIOL Bureau
Updated On
New Update

BANGALORE, INDIA: 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.

Advertisment

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.

Click here to know more...!

tech-news