Tag: SQL CE
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. For just $9.99 USD, you can learn how to rapidly virtualize your data sync infrastructure for private, public, or hybrid cloud scenarios. […]
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 […]
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 […]
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.
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.
Build mobile web sites that adhere to W3C Mobile Web Best Practices using the new WebMatix web development tool. This tool introduces simple-to-use ASP.NET Web Pages which don’t follow the MVC pattern nor do they include server controls like WebForms. It also introduces the “Razor” templating engine and a model where you have HTML and […]
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:
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 SQL Server Compact 3.5 SP2 include: Supports working with a SQL Server Compact 3.5 database using the Transact-SQL Editor in Visual Studio 2010. The Transact-SQL Editor can be used to […]