Tag Archives: Database
A Quick Note on Speedy, Scalable, Available Architectures
Just a few thoughts on concepts needed to give mobile users of your SOA infrastructure the best, fastest User eXperience possible: If you care about speed & scalability, your web service will always check the distributed cache before querying the … Continue reading
Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure
The profound effects of the Consumerization of IT (CoIT) is blurring the lines between consumers and the enterprise. The fact that virtually every type of mobile device is now a candidate to make employees productive means that cross-platform, enabling technologies are … Continue reading
Performance and Memory Management Improvements with Windows Embedded Handheld
It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld. Continue reading
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. Continue reading
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. Continue reading
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. Continue reading
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. Continue reading
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 … Continue reading
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 … Continue reading
The Windows Phone 7 Mobile Enterprise Application Platform (MEAP) @ Tech Ed Europe 2010
A Mobile Enterprise Application Platform (MEAP) allows corporate IT departments to support multiple mobile applications on a single platform. Gartner states that this market currently tops $1 billion, and forecasts that 95% of the world’s organizations will standardize on a … Continue reading
Developing Cloud Connected Applications for Windows Phone 7 @ Tech Ed Europe 2010
The Silverlight development environment has proven itself to be a rich, capable and adaptable runtime that has reached across platforms to support Windows, the Mac, the Web, Nokia and Windows Phone 7. Azure is Microsoft’s powerful cloud offering that brings compute, … Continue reading
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 … Continue reading
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: Continue reading