Rob Tiffany

Tag Archive: SQL Server

Consumerization of IT Collides with MEAP: Android > Cloud

In my ‘Consumerization of IT Collides with MEAP’ article last week, I described how to connect Android smartphones and tablets to Microsoft’s On-Premise infrastructure. In this week’s scenario, I’ll use the picture below to illustrate how Android utilizes many of…
Read more

Consumerization of IT Collides with MEAP: Android > On-Premises

In my last ‘Consumerization of IT Collides with MEAP’ article, I described how to connect iPhones and iPads to Microsoft’s Cloud servers in Azure. In this week’s scenario, I’ll use the picture below to illustrate how Android devices can utilize…
Read more

Consumerization of IT Collides with MEAP: iPhone + iPad > On-Premises

In my last ‘Consumerization of IT Collides with MEAP’ article, I described how to connect a Windows Phone device to Microsoft’s Cloud servers in Azure. By now you’re probably thinking, “It’s easy to talk about Microsoft endpoints talking to Microsoft…
Read more

SQL Server

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.

Primary Key

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.

SAN Storage

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.