Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure
Microsoft has brought the power to synchronize data with either SQL Server on-premise or SQL Azure in the cloud to the world of mobility.
Sync Framework
Consumerization of IT Collides with MEAP: Windows > Cloud
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, … Read more
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.
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.
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.
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.
Sync Framework 2.1 has Arrived!
With Sync Framework 2.1, you can leverage the Windows Azure Platform to extend the reach of your data to anyone that has an internet connection, without making a significant investment in the infrastructure that is typically required.
Microsoft SQL Server Compact 3.5 SP2 has Arrived
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 … Read more
What ever happened to RDA?
Who remembers using RDA 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 … Read more