Microsoft's Embedded Database - SQL Server Compact - Team Blog
SQL Server Compact is a SKU of SQL Server family of products from Microsoft. This is a thin light-weight, embedded, in-proc database engine which supports synchronization to SQL Server, etc.
SQL Server Compact 4.0 Tooling Support in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1
Quick Navigation Links: Overview Advantages of using Visual Studio 2010 SP1 or Visual Web Developer...
Date: 03/15/2011
Microsoft SQL Server Compact 4.0 is available for download
The SQL Server Compact team is happy to announce that the next version of Microsoft SQL Server...
Date: 01/12/2011
Downloads Available for SQL Server Compact 4.0 CTP2, Visual Studio 2010 SP1 Beta Tools for SQL Server Compact 4.0 CTP2, and CMS (mojoPortal, Orchard and Umbraco) that work with SQL Server Compact.
The second community technology preview release of SQL Server Compact 4.0 is available for download...
Date: 12/22/2010
Introducing SQL Server Compact 4.0, the Next Gen Embedded Database from Microsoft
Microsoft SQL Server Compact 4.0 is the next generation of embedded database from the SQL Server...
Date: 07/07/2010
Troubleshooting: Privately deploying the SQL Server Compact 3.5 SP2 ADO.NET Entity Framework provider (System.Data.SqlServerCe.Entity.dll) in the application folder does not work
For complete instructions about deploying SQL Server Compact ADO.NET Entity Framework provider...
Date: 05/12/2010
Microsoft SQL Server Compact 3.5 with Service Pack 2 released with Visual Studio 2010 and on the Web.
The latest release of SQL Server Compact also referred to as SQL CE or SQL Server Mobile, released...
Date: 04/14/2010
Merge replication vs. Sync Services for Compact
SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and...
Date: 11/09/2009
SQL CE Binaries - Details
Many times developers get puzzled on which exact set of binaries one should consume in their...
Date: 10/07/2009
After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time
If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes...
Date: 04/01/2009
Overview of SqlCeReplication methods - LoadProperties and SaveProperties
Whenever sync is started, developers provide all the necessary properties to an object of...
Date: 02/06/2009
How to: Authoring a 64-bit ClickOnce Bootstrapper package in Visual Studio 2008 SP1
Before going into further details first “Disclaimer: This is just to help and does not guaranty that...
Date: 10/06/2008
Sync Services optimizations
There are some optimizations that can be done for an "Sync Services" sync scenario. These are,...
Date: 10/06/2008
Disclaimer
Disclaimer: The information in this weblog is provided "AS IS" with no warranties, and confers no...
Date: 10/06/2008
Released - SQL Server Compact v3.5 SP1, SQL Server 2008 RTM, Visual Studio 2008 SP1, .NET Framework v3.5 SP1
Yes, all of them are released on August 11, 2008. SQL Server Compact v3.5 SP1: What is new in this...
Date: 08/13/2008
Insight into SQL Server Compact database corruptions
Database corruptions are often the most painful bugs to repro and debug. A good percentage of the...
Date: 06/25/2008
Katmai new datatypes support
In Katmai, new datatypes are introduced. Some of these (including some older types in Yukon) are...
Date: 06/25/2008
Query performance
Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly...
Date: 04/30/2008
Dropping Defaults (Column Constraint)
There were some recent changes that were done in regards to column defaults. In this blog entry I...
Date: 04/03/2008
Download available for SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3
The SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 is available for download at...
Date: 02/21/2008
SQL Server Compact Release Versions
This blog post is meant to give different build version numbers of our SQL Server Compact Releases....
Date: 02/08/2008
Connectivity Cross Version Compatibility (SQL Server Compact 3.5)
Connectivity Cross Version Compatibility This blog post explains the Merge Replication connectivity...
Date: 12/18/2007
Can’t find P/Invoke DLL sqlcemeNN.dll
I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me...
Date: 10/26/2007
Troubleshooting: Can’t load sqlce dll
SQL Server CE/Comapct uses Windows API LoadLibrary (PlatformBuilder or WinCE or Win32) to load the...
Date: 10/26/2007
SqlCeEngine/ISSCEEngine: Shrink Vs Compact
The difference between these two is much similar to Internal and External Memory Fragmentation. From...
Date: 10/25/2007
SQL Server Compact 3.5 Downloads
Microsoft SQL Server Compact 3.5 released with Visual Studio 2008. The English release of SQL Server...
Date: 08/30/2007
LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)
Querying data from Sql Server Compact database gets easier! “LINQ” stands for .net Language...
Date: 08/21/2007
Merge Subscribe Once, Copy and Deploy Multiple Times
"Merge Subscribe Once, Copy and Deploy Multiple Times" - This has been the real good feature I like...
Date: 06/26/2007
HOWTO: Pending Changes for a Merge Subscription (Server Side)
Earlier in the other blog article we discussed on “HOWTO: Pending Changes for a Merge Subscription...
Date: 06/26/2007
HTTP/Internet Proxy Detection - Using WINCE API
SqlCeReplication and SqlCeRemoteDataAccess have InternetProxyServer, InternetProxyLogin,...
Date: 06/19/2007
Connection String - Database Creation-time Only Options
In this article, we will discuss the Connection String Parameters that are meant for use only for...
Date: 06/13/2007
The Story of Max Database Size (Connection String Parameter)
Maximum Database Size is NOT a persistent configuration (It is NOT stored in database file). SQL CE...
Date: 06/13/2007
HOWTO: Pending Changes for a Merge Subscription (Client Side)
Often there will be need to find out if there are any pending changes on client side to upload. Note...
Date: 04/18/2007
Merge Replication System Tables
The earlier blog post “How to: Detect the database is merge replicated”, gave a list of the system...
Date: 04/18/2007