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.


  • How To Configure Windows 10 for Intel Optane Memory

    Intel's Optane memory technology can significantly improve the performance of your Windows 10 system -- provided you enable it correctly. A single mistake can render the system unbootable. Here's how to do it the right way.

  • Microsoft and SAP Enhance Partnership with Teams Integration

    Microsoft and SAP this week described continuing partnership efforts on Microsoft Azure, while also planning a Microsoft Teams integration with SAP's enterprise resource planning product and other solutions.

  • Blue Squares Graphic

    Microsoft Previews Azure IoT Edge for Linux on Windows

    Microsoft announced a preview of Azure IoT Edge for Linux on Windows, which lets organizations tap Linux virtual machine processes that also work with Windows- and Azure-based processes and services.

  • How To Automate Tasks in Azure SQL Database

    Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in Azure.

comments powered by Disqus