Archive for the_time('F Y')

7 February 2007 in .Net & Code & Microsoft | Comments (2)

This evening I delivered a quick presentation on SQL Server 2005 Compact Edition (SQL CE). Below is my demo project that shows how to connect and execute SQL commands. Note that if you run my code you’ll need to update the location of the database file in the connection string. You will also need the SQL CE Runtime (link at the end of this post)

Download the demonstration project

Product overview

Advantages of SQL CE:

  • Tiny footprint, 1.7MB
  • Replication to SQL Server, great for Smart Client and Mobile applications
  • Works on Windows XP, 2003, Vista, Windows Mobile, CE, Smartphone
  • Single file for the database makes deployment easy
  • Zero cost!

Limitations of SQL CE:

  • Maximum database size of 4GB
  • Not all SQL data types or features (you have to sacrifice something :)
  • Note that most of these limitations won’t be an issue for most of you.

Overall it makes great sense to be hooking SQL into any desktop applications. Given the simplicity of integration and small file size it makes a great case for just dropping a SQL engine into any application that needs to store data (much much sexier than managing xml files or any other hybrid data repository).


Microsoft SQL CE DataSheet

Microsoft SQL CE Download

Microsoft SQL CE Homepage

– JD

Average Rating: 4.8 out of 5 based on 287 user reviews.

1 February 2007 in Google & Microsoft & Search Technology | Comments (3)

Just a quick post today.

  1. Visit
  2. Type in “search”
  3. Click “I’m feeling lucky”

I wonder how long this will exist for? :)  

 - JD

Average Rating: 4.6 out of 5 based on 220 user reviews.