Tag:

SQL Azure

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.

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 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 from Windows Azure and SQL Azure, it makes sense to organize those objects in a …
Read more

Windows Phone 7 Line of Business App Dev :: Working with an In-Memory Database

In my last article of this series, you finally got to consume wireless-friendly WCF REST + JSON Services from both Windows Server and Windows Azure with data coming from SQL Server/SQL Azure. You now have an ObservableCollection of Customer objects residing in a Singleton on your Windows Phone 7 device.  This Singleton looks similar to …
Read more

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 table in SQL Server/SQL Azure.  I serialized .NET Objects using lightweight JSON to speed data …
Read more

Ray Ozzie sees the Dawn of a New Day for Microsoft

Five years after Ray Ozzie penned The Internet Services Disruption, he reflects on Microsoft’s move to the cloud. While he’s most proud of Windows Azure and SQL Azure, he also gives our competitors their due by mentioning that they have out-executed us when it comes to mobile experiences.  He harps on the subject of how …
Read more

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 Windows Azure.  Using Visual Studio 2010, the Azure Development Fabric and SQL Server, I will …
Read more

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 to building mobile systems.  The only thing I assume in mobile development is frequent network …
Read more