Tag: Remote Data Access

Keeping Windows Tablets in Sync with SQL Server

Keeping Windows Tablets in Sync with SQL Server

| March 19, 2013 | 11 Comments

So you need to build a mobile enterprise app that runs on Windows tablets… Your app must retrieve data from SQL Server and take it offline.  It must allow the mobile user to view, manipulate, capture new information, and then send it back to the data center.  There’s lots of data involved, so you require […]

Continue Reading

Performance and Memory Management Improvements with Windows Embedded Handheld

Performance and Memory Management Improvements with Windows Embedded Handheld

| September 4, 2011 | 0 Comments

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

SQL Server Compact 4.0 Lands on the Web

| January 17, 2011 | 0 Comments

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

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

| January 10, 2011 | 4 Comments

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

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

| January 7, 2011 | 0 Comments

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

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

| January 5, 2011 | 0 Comments

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

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

| November 26, 2010 | 6 Comments

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 […]

Continue Reading

Microsoft SQL Server Compact 3.5 SP2 has Arrived

Microsoft SQL Server Compact 3.5 SP2 has Arrived

| April 14, 2010 | 0 Comments

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 using the Transact-SQL Editor in Visual Studio 2010. The Transact-SQL Editor can be used to […]

Continue Reading

Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication

Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication

| October 23, 2009 | 7 Comments

I’m happy to say that my latest book is now available on Amazon. With the world’s largest organizations rolling out tens of thousands of Windows® phones, laptops, tablets and Netbooks to empower their respective mobile workforces, the ability to create mobile line of business solutions that support large numbers of users is absolutely critical. In […]

Continue Reading

The Hidden Message Queue on your Windows phone

The Hidden Message Queue on your Windows phone

| October 2, 2009 | 2 Comments

The ability to be “offline” and “occasionally-connected” is a critical component of successful mobile apps.  Wireless data networks lack complete coverage and exhibit a level of unreliability that immediately disqualify permanently-connected apps like you might see on a corporate LAN.  For a mobile app to be successful, it must allow the user to keep working […]

Continue Reading

What ever happened to RDA?

What ever happened to RDA?

| September 22, 2009 | 3 Comments

Who remembers using Remote Data Access to synchronize data between SQL Server and SQL Server Compact?  I certainly do! Before I dove head first into the world of Merge Replication, I always used RDA to get my customers up and running quickly.  Mobilizing an organization’s workforce quickly and easily is what it’s all about so […]

Continue Reading