Tag Archive: SQL Server

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.

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.

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

Azure2

Windows Phone 7 Line of Business App Dev :: Moving your WCF REST + JSON Service to Windows Azure

Ever since my last blog post where I demonstrated how to create lightweight WCF REST + JSON services for consumption by Windows Phone 7, I’ve received many requests from folks wanting to know how to do the same thing from…
Read more

Visual Studio

Windows Phone 7 Line of Business App Dev :: Building a WCF REST + JSON Service

Let’s start at the server and work our way to the phone.  Anyone who knows me is probably aware that I come from a wireless background so I’m always obsessed with things like coverage, bandwidth and latency when it comes…
Read more