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.
SQL Server Compact Overview (lots of demos with
This was a very demo heavy deck with supporting slides. Covers
many of our SQL Server Compact goals and non-goals, including the tooling
scenarios, split between VS and Management Studio. Slides and demo on
ASP.NET soft block, programming models with DataSet and SqlCeResultSet.
(This deck was before we had LINQ to Entity support available). Covers a
quick overview of optimized online, offline enabled architectures, with demos
of Sync Services for ADO.NET, including 2 tier and N Tier. Then wraps up
with Logical Queuing as the overall architecture for client based apps. I
had a lot of fun with this presentation, but it was hard to fit in an hour.
Unlocking the Power of SQL Server Compact (Tech Ed
Covered several topics, such as the questions on how fast can SQL
Server Compact insert data. For Tech Ed EMEA, I added the section
discussing stored procedures, and how a common DAL layer can actually provide
more functionality than sprocs for both local data and server data. (yes, I'm
sure there will be lots more to debate on this topic, but here's our thought
With some coverage on private deployment, including 64bit,
deep dive on perf and the managed sprocs demos, I bubbled back up to cover
several interesting aspects for using SQL Server Compact, including a
TraceListener to capture information from the field and sync it back with Sync
Services for ADO.NET. Then covered read only databases on DVD's and using
Compact as a custom Document format.
Managing and Versioning Client Databases (Tech Ed EMEA
Discusses the pros and cons of managing database deployment
on the client. Why deploying databases as files, through MSI's, ClickOnce
or other technologies can be easy for V1, but could lead to data loss in
V2. Why a little investment up front can yield you productive results
long term, and make for a better user experience.
Express with Scripts
Similar to the Compact deployment model, but with the
additional steps required to create the physical mdf/ldf combination.
The blog you got this document from, :) Lots of information on how we got here,
demos and powerpoints. But, since I've moved off the team, won't be able
to maintain the information going forward, so I'd recommend the following blogs
Compact Team Blog
Where most of the team posts info. Everything from our encryption
details, Entity support, query processor details, etc. You can think of
it as the authoritative source. Even Laxmi posts to the Team Blog as well
as his own...
One of great and passionate developers on the SQL Server Compact team. Be
careful what you ask for, ‘cause Laxmi will tell you J. Seriously, Laxmi spends a lot of time in the forums
listening and answering the issues and has a lot of experience with the
Server Compact Forums
Where the team and our MVPs hang out to answer your questions. In
addition to the product team, you'll also find answers from those that are
actually using the product. We've gotten some great info here as well for
how the product is actually used, as opposed to what we thought developers
would do with Compact <g>
Sync Development Center
The home for the sync team and discusses the Sync Framework as well as Sync
Services for ADO.NET.
Sync Team Blog
Less formal information on Sync Services and the Sync Framework
Framework/Sync Services for ADO.NET Forums
A great place to post questions and find answers from the Sync team
Syncmaster Rafik website
Rafik Robeal was one of our core developers for Sync Services for ADO.NET and
has all the nuts and bolts knowledge for what we originally built.
Unfortunately, Rafik has moved onto other ventures. However, he's still
got some great content on his site.
Enjoy the holidays,