Tag Archives: SQL CE

Keeping Windows 8 Tablets in Sync with SQL Server 2012 is available on the Kindle

For all you tech readers that like to keep your books digital, I’m happy to announce my new book “Keeping Windows 8 Tablets in Sync with SQL Server 2012″ is available on the Kindle.

Kindle

For just $9.99 USD, you can learn how to rapidly virtualize your data sync infrastructure for private, public, or hybrid cloud scenarios.  Building on that, the book shows you how leverage Microsoft’s data sync technologies and mobile database to avoid writing thousands of lines of unnecessary code.  Lastly, you get to combine your existing desktop .NET development skills with Modern UI concepts to port existing or create new Windows 8 tablet apps for the enterprise.

The eBook is available globally through Amazon including:

Reduce your time to market, lower risk to your projects, and leverage your existing skills, assets, and technologies to enter the tablet era.

- Rob

SQL Server Compact 3.5 Service Pack 2 Cumulative Update Package 7 RTW

Hey folks, just wanted to let you know that cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 has been released to the web.

You can download the new bits over at http://support.microsoft.com/kb/2665342.

This is a hotfix for an incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 that synchronizes with a publisher in SQL Server.  For instance, you may have a column with an ASC index on SQL Server, but during sync, the sort order may not be specified.  The problem occurs due to an incorrect index creation statement in the .OUT file in the virtual directory on IIS.  Therefore, only the Server Tools need to be updated.  Both x86 and x64 versions of the update are available to download.

Keep in mind that cumulative updates 6 and above will allow your Windows tablets, laptops and Windows Embedded Handheld devices to sync with SQL Server 2012.

Go get things sorted out,

-Rob

 

Rob Tiffany

February 4, 2012

Wow!  Just opened a 1099 tax document for 2011 from Apress.  People must still be buying my old books on eMbedded Visual Basic, the .NET Compact Framework 2.0, and SQL Server Compact 2.0.  The Pocket PC and Windows Mobile live on!

A separate 1099 for Hood Canal Press tells me that my SQL Server Merge Replication books are still killing it!  Our world of disconnected devices require efficient data sync now more than ever.  Despite a variety of sync technologies out there, Merge is still the best!

Performance and Memory Management Improvements with Windows Embedded Handheld

A lot has changed since the launch of Windows Phone in the Fall of 2010.  Microsoft now has a compelling phone platform that targets consumers inside and outside the office.  One thing that that hasn’t changed is the widespread use of Windows Embedded Handheld to solve tough enterprise mobility problems.  It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.  They include support for barcode scanning, RFID reading, rugged hardware, every type of wireless, full device encryption, complete over-the-air software distribution and device managment support, FIPS compliance, and both capacitive touch and stylus operation.  On the application platform side of the equation, they have rich support for WinForm development using Visual Studio and the .NET Compact Framework, C++ and a full-featured database with built-in sync capabilities via SQL Server Compact.  They can easily communicate with WCF SOAP and REST web services running on Windows Servers on-premise or with Azure in the cloud.  Support for Merge Replication means faster time to market to get device synchronizing with SQL Server with almost no coding.

 

 

 

 

 

 

 

 

 

Since Windows Embedded Handheld uses an advanced version of the operating system kernel used by Windows Mobile 6.5.3, many of the techniques and best practices I’ve taugh customers and developers all over the world still apply.  While it still uses the slotted memory model found in Windows CE 5 with 32 processes and 32 MB of memory per process, you’ll find that numerous enhancements and tuning has taken place to give your line of business apps more of what they need.  I’m talking about more memory per process and improved performance.  Therefore, I’d like you to sit back and watch the video of a presentation I delivered at Tech Ed in Los Angeles a couple of years ago so you can better learn what this mobile platform has to offer in the form of better memory management and improved performance:

A recent Gartner report recommends that organizations should stay with Windows Embedded Handheld as the best mobile platform for enterprise line of business needs.  Great devices are available from OEMs like Intermec, Motorola, Psion, and Honeywell just to name a few.  I hope this video helps you with any memory management or performance issues you may need to deal with in your enterprise mobile apps.

Best Regards,
Rob

Windows Phone SDK 7.1 Beta2 is Available!

Head on over to http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26648 to download the new tools.  This update can be used to develop applications for both 7.0 and 7.1 (Mango) version of Windows Phone OS releases.

The Windows Phone SDK includes the following components:

  • Windows Phone SDK 7.1 (Beta2)
  • Windows Phone Emulator (Beta2)
  • Windows Phone SDK 7.1 Assemblies (Beta2)
  • Silverlight 4 SDK and DRT
  • Windows Phone SDK 7.1 Extensions for XNA Game Studio 4.0
  • Microsoft Expression Blend SDK Preview for Windows Phone 7.1
  • WCF Data Services Client for Window Phone 7.1
  • Microsoft Advertising SDK for Windows Phone 7

Beyond developing apps and games with Silverlight and XNA, take advantage of the new emulator to view and test your new HTML5 websites.

-Rob