Tag: Synchronize

Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure

Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure

| September 11, 2011 | 13 Comments

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 a must.  Luckily, Microsoft has brought the power to synchronize data with either SQL Server […]

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

Mobile Merge Replication Performance and Scalability Cheat Sheet

Mobile Merge Replication Performance and Scalability Cheat Sheet

| April 22, 2010 | 4 Comments

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

Making MEAP Real

Making MEAP Real

| February 1, 2010 | 2 Comments

After all the logical diagrams of Microsoft MEAP and spelling out how it meets Gartner’s critical capabilities, I thought I’d show you a picture that provides a more concrete view of what our MEAP offering looks like. Hopefully, this will better crystallize how Microsoft lines up with those critical capabilities and how our reusable mobile […]

Continue Reading

Interview with Rob @ Tech Ed Europe 2009

Interview with Rob @ Tech Ed Europe 2009

| December 23, 2009 | 0 Comments

Check out the interview I did with David Goon at Tech Ed Europe 2009 in Berlin.  I discuss Microsoft’s Mobile Enterprise Application Platform and talk about how it aligns with Gartner’s MEAP critical capabilities and how it can save money for companies. With the tidal wave of mobile and wireless technologies sweeping across both the consumer and […]

Continue Reading

Yes, Microsoft does have a Mobile Enterprise Application Platform (MEAP)

Yes, Microsoft does have a Mobile Enterprise Application Platform (MEAP)

| October 28, 2009 | 9 Comments

Gartner says that the Mobile Enterprise Application Platform (MEAP) market will top $1 Billion by the end of 2010 and that more than 95% of organizations will choose MEAP instead of point solutions through 2012.  The big takeaway here is that companies have been building tactical mobile application silos that support only one application and […]

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