Demos, Presentations, Links, Screencasts and Videos for SQL Server Compact

I often find it hard to find my own demos scattered throughout my blog, so figured I’d just create a single posting that had all my current demos and powerpoints. Recent Presentations at PDC and Tech Ed SQL Server Compact Overview (lots of demos with supporting slides)  This was a very demo heavy deck with…

8

Tech Ed EMEA 08 Powerpoints and Demos

Another great year in Barcelona.  In addition to the sessions below, we had several nights out on the town.  As usual, we had the Microsoft Regional Director get togethers.  It’s always interesting when you have social geeks out on the town.  Chris Menegay and I decided to make it a late night on Friday.  I had…

3

Heading to Tech Ed EMEA Barcelona

I always love going to Barcelona.  Sure, it’s a great city, and loved riding motorcycles into the mountains last year with my wife; but it’s just a great event to attend and present. It sort of like PDC and Tech Ed US wrapped into one event.  Anyway, I’ll be giving two presentations this year, and…

1

Compact Tips & Tricks at the Redmond We-Dig users group

This Wednesday, November 5th 2008, I’ll be giving doing a local users group presentation that will cover some of the perf tips from PDC and some client database deployment tips for deploying and versioning local databases.  I’ll be giving a talk on script based deployment at Tech Ed EMEA in 2 weeks, so this is…

2

PDC 2008 – Embedding SQL Server Compact In Desktop And Device Applications

This week I presented a session on SQL Server Compact.  Video Recording of the session is here.  The session focused on 3 main topics: Why SQL Server Compact “changes the game” for how you might think about leveraging a database in your app Performance of SQL Server Compact Interesting scenarios you can use a local…

3

Privately Deploying SQL Server Compact with the ADO.NET Entity Provider

When privately deploying SQL Server Compact you will need to take a few extra steps if you wish to use the ADO.NET Entity Model.  Here’s some info on how to do it. Why the extra steps?The ADO.NET Entity model was designed as a mid-tier solution.  In the mid tier, IT owns the box and they…

15

Evolution or Revolution for moving to offline architectures

There’s been a lot of talk, momentum and questioning for where and how occasionally connected designs fit into the application landscape.  There have been a lot of questions for “if and how” developers can take their existing apps “offline”.  There have been a number of efforts for enabling offline apps and some longer term plans. …

1

Why doesn’t Visual Studio 2008 SP1 installer update SQL Server Compact 3.5 for Devices?

In addition to the 64bit support being a web-only download, I should have also noted that for similar reasons, the Devices version of SQL Server Compact 3.5 SP1 is also only available as a web download.  Why:  Because of the multiple platforms, the download is ~22mb.  That’s a big chunk for the Visual Studio Service…

2

Why does VS 2008 SP1 not include SQL Server Compact 3.5 SP1 64bit?

So you want 64bit support so you can set Target = Any.  You just installed VS 2008 SP1, but when you run your app you still get an error… Why?  Because VS 2008 SP1 doesn’t actually include the 64bit version of SQL Server Compact 3.5 SP1.  To remedy this, simply install the 64bit version from…

9