News

Microsoft Ships 2.0 of SQL Server CE

Microsoft this week put out a second version of the handheld edition of its SQL Server database.

SQL Server 2000 Windows CE Edition, or SQL Server CE 2.0, is available immediately for download at www.microsoft.com/sql/CE/default.asp.

In Microsoft's view, a core benefit of the SQL Server CE software, both 1.0 and 2.0, is that it presents a unified programming target -- SQL Server -- for database developers across all server and client levels.

Aside from the usual performance enhancement work, Microsoft crammed several new features into the compact database. Its Query analyzer has an improved user interface for object management. A query processor includes new intrinsic functions and parameterized queries. An improved storage engine adds index pulls, upload-only features and support for 249 indexes per table. A connectivity wizard facilitates setup of security and connectivity options for data replication. An on-device query tool allows stored queries and schema viewing on the device.

The download availability of SQL Server CE 2.0 was simultaneous with a private Beta 2 release of the Visual Studio "Everett" developer toolset. The "Everett" version of Visual Studio is supposed to be available around the same time as Windows .NET Server 2003 comes out. The Beta 2 release includes a beta version of the .NET Compact Framework, which is tightly integrated with SQL Server CE 2.0.

About the Author

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

Featured

  • World Map Image

    Microsoft Taps Nebius in $17B AI Infrastructure Deal To Alleviate Cloud Strain

    Microsoft has signed a five-year, $17.4 billion agreement with Amsterdam-based Nebius Group to expand its AI computing capabilities through third-party GPU infrastructure.

  • Microsoft Brings Copilot AI Into Viva Engage

    Microsoft 365 Copilot in Viva Engage is now generally available, extending Copilot's AI-powered assistant capabilities deeper into the Viva platform.

  • MIT Finds Only 1 in 20 AI Investments Translate into ROI

    Despite pouring billions into generative AI technologies, 95 percent of businesses have yet to see any measurable return on investment.

  • Report: Cost, Sustainability Drive DaaS Adoption Beyond Remote Work

    Gartner's 2025 Magic Quadrant for Desktop as a Service reveals that while secure remote access remains a key driver of DaaS adoption, a growing number of deployments now focus on broader efficiency goals.

Most   Popular