Chapter 22 – Placing SQL Server in your pocket

A clever, catchy title for the chapter by Christopher Fairbairn (Blog | StackOverflow). 

I find myself spending the majority of time working to scale, optimize, tune, develop and administer large SQL Server environments.  As a result this chapter was a wake up call for me.  It’s good to be reminded of entire editions of a product that I spend countless hours every week working on. 

With that said, there are a few things that really struck me with this chapter.  The first was the footprint.  Yeah, I knew that the CE (compact edition) of SQL Server was small… but 4MB?  Good grief.  I’ve deployed t-sql scripts for products or customer releases that are larger than that.  It’s truly incredible that Microsoft can pack enough of the engine into a 4MB footprint so as to make it able to support merge replication, multiuser, locking (transactional consistency), be cross-platform and even encrypted!  It’s like a lite beer with all the taste for… well, for nothing! 

So, with the wake-up call to CE I have some next steps.  One is to learn more about it, where it might fit in with my client’s overall strategic goals and more importantly for me to become familiar with.  I haven’t yet had a project that required disconnected hand-held devices to operate an application and then synch back up to the network.  That said, there are clearly a ton of applications out there doing just that.

My mind can’t help but wander with this subject to azure and how CE and Azure will co-exist.  There is probably some information out there on this already, I simply haven’t come across it.  If you have come across it, leave a comment and help educate me and the population of folks following this blog.

Next week is the last chapter of Part 2, Database Development.  Part 3 will begin the broader subject of Database Administration.  If any of you have ideas or comments about the format of this site, the posts themselves or constructive criticism, please don’t hesitate to leave a comment or e-mail one or all of the three main authors of this blog.  Our e-mail addresses and the schedule for the remaining chapters of the book can be found here and here, respectively.

Happy 4th of July to those of you in the U.S.


0 Responses to “Chapter 22 – Placing SQL Server in your pocket”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 11 other followers