Tag Archive: Remote Data Access

Performance and Memory Management Improvements with Windows Embedded Handheld

pp-Psion-Teklogix-12-6-10

It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

SQL Server Compact 4.0 Lands on the Web

SQL Server

With the new version 4.0, the little-database-that-could has grown up into a powerful server database ready to take on the web.

Reducing SQL Server Sync I/O Contention :: Tip 3

Primary Key

Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is uniquely identified by its Primary Key.

Reducing SQL Server I/O Contention during Sync :: Tip 1

SAN Storage

The act of tracking changes made by each SQL Server Compact or Silverlight sync subscriber can cause a lot of locking and blocking on the server.

Windows Phone 7 Line of Business App Dev :: Improving the In-Memory Database

Phone 7

About a month ago, I wrote an article intended to help you fill some of the gaps left by the missing SQL Server Compact database. Since your Windows Phone 7 Silverlight app is consuming an ObservableCollection of objects streaming down…
Read more

Microsoft SQL Server Compact 3.5 SP2 has Arrived

SQL Server Compact

My favorite embedded database for Windows Phones, laptops, tablets and desktops has been released to the Web along with Visual Studio 2010. New features for SQL Server Compact 3.5 SP2 include: Supports working with a SQL Server Compact 3.5 database…
Read more