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

  • Azure Backup for SQL Server Now Commercially Available

    Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use.

  • Insights for MyAnalytics Getting Switched On for Office 365 Users This Month

    Microsoft is planning to activate "Insights for MyAnalytics" sometime late this month for most Office 365 users, but the ability of organizations to manage this feature won't be available until possibly mid-May.

  • SharePoint Framework 1.8 Now Generally Available

    Microsoft this week announced that SharePoint Framework 1.8 had reached "general availability" status, although some features are still at the preview stage.

  • How To Create Office 365 User Accounts in Bulk

    Manual account creation can be tedious, time-consuming and prone to human error, especially if you have more than a handful of Office 365 users to set up. Brien shows you a better way.

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.