Heading to Tech Ed US 08

It’s that time of year again. A quick note on some of the sessions/panel discussions I’ll be presenting at, and some others that relate to SQL Server Compact.

Code	Session
DAT325 Wednesday 8:30AM-9:45AM	Unlocking the Power of Microsoft SQL Server Compact 3.5 With Visual Studio 2008, you can now embed SQL Server Compact as dlls directly within your application. But you’ve seen the intro talks; now what? In this demo packed session, Ginny and Steve will dig into the more advanced scenarios for how to take advantage of SQL Server Compact within your applications. How to write managed Stored Procedures, sharing a common dll between desktop and device apps, using SQL Server Compact as a custom document format, tips on maximizing performance and how to deploy and version a local database within your app are all just some of the demos you’ll see to maximize your end users productivity with Visual Studio 2008 and SQL Server Compact. Location: S220 E Presenters: Ginny Caughey and Steve Lasker

TEO Panel _24 Wednesday 1:00PM-2:00PM	Building Offline Enabled Applications Panel Discussion In an online world, why are we building offline apps? Because networks are only occasionally available, or occasionally not available. However, building Offline apps is a bit more complicated. Come bring your thoughts to a panel of speakers that work on enabling offline apps from the storage, sync, programming model, and UI stack. The panelists will discuss what we’re working on today, and what’s coming in the future. Location: Open Spaces on the main floor Panelists: Steve Lasker, Ginny Caughey, Rob Tiffany, Liam Cavanagh, Glenn Block

TEO Panel _33 Friday 2:00PM-3:00PM	LINQ in the UI Layer LINQ is commonly known as a great way to query data from external sources (databases, web services, XML, SharePoint, etc). However, there are numerous other places where LINQ can make the developers life much easier when working on the end user interface, especially when you incorporate DataSet into the mix. This panel will talk about these approaches and the possible pitfalls of using them. Location: Open Spaces on the main floor Panelists: Erick Thompson, Steve Lasker, Amanda Silver

MBL403	Building Custom Sync Providers for the Microsoft Sync Framework Andy Wigley Wednesday 2:45

WIN202	Introduction to Microsoft Sync Framework Liam Cavanagh Thursday 1:00

MBL404	Microsoft SQL Server 2005 Compact Ultimate Performance Tuning Darren Shaffer Thursday 4:30

MBL07-TLC	Microsoft Synchronization Services for ADO.NET: From Desktops to Devices Liam Cavanagh Friday 8:30

MBL01-TLC	Taking Data Offline: Introduction to Microsoft Synchronization Services for ADO.NET Liam Cavanagh Friday 4:30

Road Trip

The week after Tech Ed Developers we’ll be doing our next Road Trip. We still have some time in a few of the cities, so if you’ve got something interesting, let me know and we might be able to swing by.

Tampa Florida, Monday-Tuesday, June 9^th-10^th
Los Angeles , Wednesday, June 10^th
San Francisco, Friday, June 13^th

PowerPoint Presentation

The following links were posted prior to Tech Ed. In typical fashion the content will continue to evolve until we actually present. I’ll leave a note here when these have been updated post the session.

Tech Ed US 08 DAT325 – Unlocking the Power of SQL Server Compact

The following demos were presented either as part of the Unlocking the Power of SQL Server Compact session Ginny and I gave, shown at the booth, or shown at other presentations for our June ’08 Road Trip

Demos

We’ll be spending a lot of time at the booth hearing from all of you that have started to work with Compact. We continue to hear about cool scenarios, so come on by, and tell us what you like and what you think we need to do in our 4.0 release.

Thanks,
Steve

2Comments

Add yours

1

Ram on July 9, 2008 at 2:25 pm

Hello Steve,
When I use the local db cache feature I would like to be able to use a VIEW from the main server to actually sync with my local cache because SQLCE does not support views, but the variables I am pulling to populate local db is coming from one or more tables from the server. How do I accomplish this?
I understand it gets a bit complicated when the sync is on both ends (Client/Server), but I am synchronizing only the client db then why isn’t views being supported to pull data from server?
Thanks,
Ram

LikeLike
2

Steve.Lasker on July 9, 2008 at 5:00 pm

Hi Ram,
I think you’re asking to enable “download only” data from Views on SQL Server. If that’s correct, this isn’t enabled through the designer, but can be done in code relatively easily. It’s effectively the same as a standard table for a view over a single table The challenge is actually in calculating “what changed” when you’re joining multiple tables. Since the view could represent rows from multiple tables, you have to actually ask the server “where T1.LastEdit > @anchor, or T2.LastEdit > @anchor, or T3.LastEdit > @anchor.
This extra logic isn’t incorporated into the SyncAdapterBuilder, which is what the designer is based upon, so you’d have to hand author the queries to get the deltas.
You could of course to a download each time, but then you’re really not getting the benefits of sync.
Hope that helps,
Steve

LikeLike

Share this:

Like this:

Related