It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.
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.
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.
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.
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 …