Tag: RDA

Keeping Windows 8 Tablets in Sync with SQL Server 2012

Keeping Windows 8 Tablets in Sync with SQL Server 2012

| June 2, 2013 | 5 Comments

I’m pleased to announce that my newest book, “Keeping Windows 8 Tablets in Sync with SQL Server 2012,” is now available for sale on Amazon. Spending a decade travelling the globe to help the world’s largest companies design and build mobile solutions had taught me a few things.  Large organizations are not interested in constantly running on […]

Continue Reading

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode III

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode III

| April 21, 2012 | 4 Comments

Back in my first article, I showed you where to find Microsoft’s latest updates to the SQLCE and RDA technologies so you can begin synchronizing data with the new SQL Server 2012 (Denali) database.  Just imagine, you now have mobile sync components that give you the flexibility to to work with SQL Server 7, 2000, […]

Continue Reading

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode II

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode II

| April 9, 2012 | 6 Comments

In my last article, I walked you through finding, downloading, installing, and configuring SQL Server 2012 Express, SQL Server Compact 3.5 SP2 CU6, and the Sync Server Tools.  With that series of tasks completed, you’re now capable of performing data synchronization with a mobile Windows client. Open SQL Server 2012 Management Studio and connect to the local SQL […]

Continue Reading

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I

| March 27, 2012 | 1 Comment

Now that SQL Server 2012 has been released, some of you might be wondering if SQL Server Compact is capable of synchronizing with it.  With the release of Cumulative Update Package 6 for SQL Server Compact 3.5 Service Pack 2, the answer is a resounding yes!  Build number 3.5.8088.00 adds support for replication with SQL Server “Denali” which is […]

Continue Reading

Performance and Memory Management Improvements with Windows Embedded Handheld

Performance and Memory Management Improvements with Windows Embedded Handheld

| September 4, 2011 | 0 Comments

It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

Continue Reading

Reducing SQL Server Sync I/O Contention :: Tip 5

Reducing SQL Server Sync I/O Contention :: Tip 5

| March 9, 2011 | 0 Comments

Today’s tip is an easy one. When it comes to delivering server solutions with Windows Server and SQL Server, speed is your friend (as we used to say in the submarine service). More speed means more things can happen in a given period of time. If more things can happen in a given period of […]

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

Windows Phone 7 Line of Business App Dev :: Improving the In-Memory Database

Windows Phone 7 Line of Business App Dev :: Improving the In-Memory Database

| November 26, 2010 | 6 Comments

About a month ago, I wrote an article intended to help you fill some of the gaps left by the missing SQL Server Compact database.  Since your Windows Phone 7 Silverlight app is consuming an ObservableCollection of objects streaming down from Windows Azure and SQL Azure, it makes sense to organize those objects in a […]

Continue Reading