Rob Tiffany

Tag Archive: SQL Server Compact

SQL Server

SQL Server Compact 4.0 Lands on the Web

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.

Primary Key

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

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.

Database Storage

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

All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.

SAN Storage

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

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.

Phone 7

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

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

Windows Phone 7.5

Windows Phone 7 Line of Business App Dev :: Consuming an Azure WCF REST + JSON Service

In my last two articles, I showed you how to build WCF REST services using Visual Studio 2010 that can reside on-premise in Windows Server 2008 or in the Cloud in Windows Azure.  Furthermore, I demonstrated pulling data from a…
Read more

Sync

Sync Framework 2.1 has Arrived!

With Sync Framework 2.1, you can leverage the Windows Azure Platform to extend the reach of your data to anyone that has an internet connection, without making a significant investment in the infrastructure that is typically required.

HTML5

Build the Mobile Web with WebMatrix

Build mobile web sites that adhere to W3C Mobile Web Best Practices using the new WebMatix web development tool. This tool introduces simple-to-use ASP.NET Web Pages which don’t follow the MVC pattern nor do they include server controls like WebForms. …
Read more

SQL Server Compact

Mobile Merge Replication Performance and Scalability Cheat Sheet

If your Mobile Enterprise Application Platform (MEAP) is using SQL Server Merge Replication to provide the mobile middleware and reliable wireless wire protocol for SQL Server Compact (SSCE) running on Windows Mobile 5/6.x devices + Windows XP/Vista/7 laptops, desktops and tablets; below is a guide to help you build the fastest, most scalable systems: