SQL Server 2000 Continues Microsoft’s Enterprise Push

SQL Server 2000 is Microsoft Corp.’s latest version of its flagship relational database management system offering. The long awaited follow-up to SQL Server 7.0 was released to manufacturing on August 7.

While SQL Server will continue in its role as the anchor of the BackOffice suite in smaller businesses, Microsoft made enhancements in SQL Server 2000 to push further into competition with Oracle and IBM for large database accounts, a move the company started with SQL Server 7.0.

After SQL Server 6.5 came out, the RDBMS underwent a radical code redesign and the product that emerged from it is what we know now as version 7.0. While SQL Server 2000 -- originally known by the codename “Shiloh” -- has not gone through such a noticeable revamp, Microsoft’s present offering does include major changes.

Much of the buzz on SQL Server 2000 surrounds its new XML capabilities. The product can now get XML messages out of relational data, provide XML views to relational data tables, provide relational data views on XML data, and offers XML updating. Since SQL Server 2000 is such a big part of Microsoft’s e-commerce strategy and .NET, it will also feature support for the BizTalk XML framework, as well as for the BizTalk Server 2000.

 Looking to simplify the data mining and OLAP process, Microsoft has integrated those services with the database – these will now be known as Analysis Services.  The company also wanted to improve the product’s overall ease of use. To do that, Microsoft added multi-instancing of the database, and full-text search and English query features.

SQL Server 2000 is also offering a slew of other newbies, including a core relational engine, core storage engine, replication, and data mining.

Microsoft also introduced a controversial scalability clustering mechanism in SQL Server 2000 called Distributed Partition Views. The feature allows very large databases to be built in pieces on a number of standard servers.

Microsoft leapfrogged to the head of the Transaction Processing Performance Council’s OLTP benchmark ( using the technique on beta code of SQL Server 2000. While the results were later recalled on a technicality, Microsoft rewrote the code to address the concerns and reposted its results. Some industry observers contend the distributed approach is an overly complex method for building large databases that real-world database administrators would not use.

Users can also look for large and smaller versions of the database in the months to come. Microsoft is working on SQL Server 2000 version for 64-bit computing and one for Windows CE. – Alicia Costanza

For Microsoft’s overview of SQL Server 2000, see

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.


  • Microsoft Hires Movial To Build Android OS for Microsoft Devices

    Microsoft has hired the Romanian operations of software engineering and design services company Movial to develop an Android-based operating system solution for the Microsoft Devices business segment.

  • Microsoft Ending Workflows for SharePoint 2010 Online Next Month

    Microsoft on Monday gave notice that it will be ending support this year for the "workflows" component of SharePoint 2010 Online, as well as deprecating that component for SharePoint 2013 Online.

  • Why Windows Phone Is Dead, But Not Completely Gone

    Don't call it a comeback (because that's not likely). But as Brien explains, there are three ways that today's smartphone market leaves the door open for Microsoft to bring Windows back to smartphones.

  • Feature Update Deferral Mix-Up in Windows 10 Version 2004 Further Explained

    Microsoft last week described the confusion it is attempting to avoid by removing the client graphical user interface (GUI)-based controls to defer Windows 10 feature updates, starting with version 2004.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.