Tag: Sync Framework

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 | 16 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

Consumerization of IT Collides with MEAP: Windows > Cloud

Consumerization of IT Collides with MEAP: Windows > Cloud

| August 9, 2011 | 1 Comment

In my Consumerization of IT Collides with MEAP article last week, I described how to connect a Windows 7 device to Microsoft’s On-Premises servers.  Whether you’re talking about a Windows 7 tablet or laptop, I showed that you can follow the Garter MEAP Critical Capabilities to integrate with our stack in a consistent manner.  Remember, […]

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

The Windows Phone 7 Mobile Enterprise Application Platform (MEAP) Tech Ed Video

The Windows Phone 7 Mobile Enterprise Application Platform (MEAP) Tech Ed Video

| November 15, 2010 | 0 Comments

Continue Reading

The Microsoft Sync Framework 4.0 October 2010 CTP has Arrived!

The Microsoft Sync Framework 4.0 October 2010 CTP has Arrived!

| October 28, 2010 | 2 Comments

Run, don’t walk, and download the new SyncFx bits to sync your connected devices with SQL Server and SQL Azure!  Below is a quick rundown of all the features from the Microsoft Download Center page: Microsoft Sync Framework 4.0 October 2010 CTP Overview The Microsoft Sync Framework 4.0 October 2010 CTP is built on top […]

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

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