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.
SSCE
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.
Mobile Merge Replication Performance and Scalability Cheat Sheet
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:
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… Read More »Microsoft SQL Server Compact 3.5 SP2 has Arrived
Making Microsoft MEAP Real
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… Read More »Making Microsoft MEAP Real
Interview with Rob Tiffany at Tech Ed Europe
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… Read More »Interview with Rob Tiffany at Tech Ed Europe
Yes, Microsoft does have a Mobile Enterprise Application Platform (MEAP)
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… Read More »Yes, Microsoft does have a Mobile Enterprise Application Platform (MEAP)
Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication
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®… Read More »Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication
The Hidden Message Queue on your Windows phone
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… Read More »The Hidden Message Queue on your Windows phone
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… Read More »What ever happened to RDA?