Tag: Merge Replication

Building Microsoft MEAP: Scaling Out SQL Server 2012

Building Microsoft MEAP: Scaling Out SQL Server 2012

| January 8, 2013 | 3 Comments

In this third article on building Microsoft MEAP, I’ll show you how to Shard your SQL Server 2012 database using Replication to create a Shared Nothing data architecture to support Internet-scale mobile solutions. In the previous article, I discussed Gartner’s Enterprise Application Integration Tools (EAI) critical capability for building a Mobile Enterprise Application Platform (MEAP) using Microsoft […]

Continue Reading

SQL Server Compact 3.5 Service Pack 2 Cumulative Update Package 7 RTW

SQL Server Compact 3.5 Service Pack 2 Cumulative Update Package 7 RTW

| August 18, 2012 | 0 Comments

Hey folks, just wanted to let you know that cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 has been released to the web. You can download the new bits over at http://support.microsoft.com/kb/2665342. This is a hotfix for an incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 that synchronizes with […]

Continue Reading

Books and Taxes

Books and Taxes

| February 4, 2012 | 0 Comments

Wow!  Just opened a 1099 tax document for 2011 from Apress.  People must still be buying my old books on eMbedded Visual Basic, the .NET Compact Framework 2.0, and SQL Server Compact 2.0.  The Pocket PC and Windows Mobile live on! A separate 1099 for Hood Canal Press tells me that my SQL Server Merge […]

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

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

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

| March 9, 2011 | 0 Comments

Today’s tip is an easy one. When it comes to delivering server solutions with Windows Server and SQL Server, speed is your friend (as we used to say in the submarine service). More speed means more things can happen in a given period of time. If more things can happen in a given period of […]

Continue Reading

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

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

| February 27, 2011 | 0 Comments

One of the features that makes SQL Server Merge Replication superior to other sync technologies is something called Precomputed Partitions.  SQL Server creates and maintains distinct data partitions/subsets for each unique user or other type of filter value.  Other sync technologies figure out “what’s-changed” on the fly when a Subscriber synchronizes.  This means all change-tracking […]

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