Flessner: Meet SQL for CE

SAN FRANCISCO -- Today at the PASS SQL Server users conference, Paul Flessner, senior vice president of Microsoft’s .NET Enterprise Servers Group announced a brand new Microsoft product, SQL Server 2000 Windows CE. The announcement came in his opening keynote address to attendees of the conference.

SQL Server 2000 CE is made for handheld devices and offers flexible access to enterprise data. Like SQL Server 2000 for the enterprise, it is a full relational database management system, but also offers wireless HTTP support and a 1 MB footprint.

Flessner talked up several features of the new product: data access between the CE device and versions of SQL Server 6.5 and up; data is stored locally on the device; the ability to use a database password and data encryption to protect data on the device; the ability to connect to IIS over an Internet connection and use SSL to encrypt data over the wire; and the ability to get access SQL Server 2000 from beyond a firewall.

Other features, dicussed by Kevin Collins of Microsoft, were embedded Visual Basic in the software, merge replication, and central administration from SQL Server 2000 in the enterprise.

Merge replication allows the CE user to replicate data back to SQL Server 2000 that is obtained while not connected to SQL Server 2000. The CE version also enables IT to set up a subscription database, which enables the device to receive only data from SQL SErver 2000 that is relevant to the device user -- and not replicating the entire database onto the device. To do this, SQL Server 2000 CE employs dynamic horizontal partitions which control what sets of data come to the device, this can be specific to the device and can be changed by IT at any time.

Licensing of SQL Server 2000 will require users to purchase SQL SErver 2000 developers edition and pay a fee of $499. This will give them one developer license for unlimited deployment. Users can then go to the Micrsoft SQL Server site and download the CE edition. – Alicia Costanza

About the Author

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


  • Microsoft Starting To Roll Out New Excel Connected Data Types

    Microsoft on Thursday announced some Excel and Power BI enhancements that add "connected data types" on top of the standard strings and numbers options.

  • Windows 10 Users Getting New Process for Finding Optional Driver Updates

    Accessing Windows 10 drivers classified as "optional updates" will be more of a manual seek-and-install type of experience, starting on Nov. 5, 2020, Microsoft explained in a Wednesday announcement.

  • Microsoft Changes Privacy Platform Name to SmartNoise

    Microsoft Research has changed the name of its "differential privacy" platform from "WhiteNoise" to "SmartNoise," according to a Wednesday announcement.

  • Why Restarting a Failed SCVMM Job Might Be a Bad Idea

    Occasionally, restarting a failed System Center Virtual Machine Manager job can leave your virtualization infrastructure in an unknown state. Here's how to avoid that.

comments powered by Disqus