I love cookies—the kind you eat, not the kind in my browser.
I've been wrong before, but I believe that SQL Server CE is one of the most important tools in Microsoft's quest for dominance in the handheld computing market. Today, Palm Pilot devices have a huge deployment lead over Windows CE technology (including the Pocket PC), but I think that most people use their Palms as Personal Digital Assistants (PDAs). I haven't seen the market use the Palm as an integrated tool for corporate computing networks. I won't argue whether Windows CE is better than the Palm OS and its related devices, but at the very least, most people (even my friends who own Palms) admit that the newest Pocket PC incarnations are good enough to threaten the Palm in the PDA market. But revenue from a PDA market pales in comparison to revenue opportunities from business-integration opportunities. Regardless of Microsoft's ability to compete in the PDA market, Pocket PCs have a huge advantage in the business-integration market. Given a choice, most technical folks like simplicity and will select tools they're already familiar with. And like it or not, Windows developers can't leverage many of their tool skills if they decide to develop for the Palm. On the other hand, the Pocket PC relies on a development suite called eMbedded Visual Tools, which uses SQL Server CE as the disconnected data store. eMbedded Tools is familiar to Visual Studio fans, and SQL Server CE is very similar to the full version of SQL Server. If your company develops for Windows, should you expect your developers to learn an entirely new paradigm or let them use the familiar Microsoft tools they're already comfortable with?
SQL Server CE expertise will be a valuable addition to your professional tool box. Wireless computing is a huge growth area, and someone will have to build the applications. I don't see large, pent-up demand for wireless applications just yet, but it's only a matter of time. When demand perks up, much of the corporate world will choose the wireless platform that most closely resembles its wired development environments and—for better or worse—that means Windows CE, or WinCE. (Let's hope we won't have to wince when people start building real applications in WinCE.
By the way, you can develop SQL Server CE applications even if you don't have a Windows CE device. Just download the software and use a standard desktop to get your feet wet with this technology. Here are some Microsoft resources to help you get started with SQL Server CE:
- http://www.microsoft.com/sql/productinfo/ceoverview.htm is the main SQL Server CE overview page and includes a link to the software's download site.
- http://www.microsoft.com/sql/productinfo/ceevalguide.htm is the SQL Server CE evaluation guide.
- http://www.microsoft.com/sql/productinfo/cesysreq.htm lists the system requirements for working with SQL Server CE.