SQL Server MVP Deep Dives

Chapter 22. Placing SQL Server in your pocket

Christopher Fairbairn

SQL Server is a database engine that can scale to cope with the largest data centers and astronomically sized datasets, but it can also scale down to support incredibly small and resource-constrained scenarios.

Many workforces are increasingly becoming mobile and working outside the fixed confines of an office environment. This presents a challenge to system architects, as they need to consider how to make their company data accessible to field workers while coping with issues such as the high costs and slow speeds (and potential unavailability) of network connectivity.

In building a traditional three-tier distributed application, you may have used SQL Server 2008 to store ...