Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Monday, November 09, 2009 2:12 PM

Merge replication vs. Sync Services for Compact

SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and “Sync Services”. Users might be using one or the other, and interested in knowing the differences between the two technologies, from a use-case point of
Posted by SQLCEBLOG | 0 Comments
Wednesday, October 07, 2009 2:27 PM

SQL CE Binaries - Details

Many times developers get puzzled on which exact set of binaries one should consume in their application. There is also a misconception that SQL CE engine is too big in size. This may be because there was no effort from our side to clarify on “Which binary
Posted by laxminro | 0 Comments
Filed under: , ,
Wednesday, May 06, 2009 4:26 AM

Troubleshooting: Access Violation exception while using SQL Server Compact database with ADO.NET provider

Possible causes for Access Violation exception in general: An access violation occurs in unmanaged or unsafe code when the code attempts to read or write to memory that has not been allocated, or to which it does not have access. This usually occurs because
Posted by SQLCEBLOG | 0 Comments
Tuesday, May 05, 2009 3:52 PM

SQL Server Compact Garbage Collection – Whys and Hows

Some background about SQL Server Compact: SQL Server Compact is an embedded database implemented in native and it can be accessed in application by either OLEDB or ADO.NET provider model. ADO.NET provider for SQL Server Compact is a managed assembly which
Posted by SQLCEBLOG | 0 Comments
Wednesday, April 01, 2009 1:16 PM

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 more time and also increases the database file size. The Reason : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized sort
Posted by SQLCEBLOG | 0 Comments
Friday, February 06, 2009 3:22 PM

Overview of SqlCeReplication methods - LoadProperties and SaveProperties

Whenever sync is started, developers provide all the necessary properties to an object of SqlCeReplication class. These properties are provided through the constructors or by directly setting the public properties of the object. In this approach developers
Posted by SQLCEBLOG | 1 Comments
Filed under:
Monday, October 06, 2008 2:20 PM

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 this is approved my employer or me J ” Location of SQL Compact Bootstrapper <BootstrapperDir> \Packages\SQL Server Compact Edition\ <LocaleCultureDir>
Posted by SQLCEBLOG | 1 Comments
Monday, October 06, 2008 1:40 PM

Sync Services optimizations

There are some optimizations that can be done for an "Sync Services" sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering
Posted by SQLCEBLOG | 0 Comments
Monday, October 06, 2008 1:39 PM

Disclaimer

Disclaimer : The information in this weblog is provided "AS IS" with no warranties, and confers no rights. This weblog does not represent the thoughts, intentions, plans or strategies of my employer. It is solely our opinion. Inappropriate comments will
Posted by SQLCEBLOG | 2 Comments
Wednesday, August 13, 2008 8:37 PM

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 Service Pack? - Click here and here Where to download? SQL Server Compact v3.5 SP1 for Desktops (32-bit and 64-bit) SQL Server Compact v3.5 SP1 for Devices
Posted by laxminro | 1 Comments
Filed under:
Wednesday, June 25, 2008 4:20 PM

Insight into SQL Server Compact database corruptions

Database corruptions are often the most painful bugs to repro and debug. A good percentage of the SQL Server Compact bugs reported are in this category. However it so turns out that in majority of the cases Compact is not the culprit. Surprised!! Let
Posted by SQLCEBLOG | 3 Comments
Filed under: ,
Wednesday, June 25, 2008 1:31 PM

Katmai new datatypes support

In Katmai, new datatypes are introduced. Some of these (including some older types in Yukon) are supported for merge replication synching with SQL Compact in SQL Compact 3.5 SP1. These types are mapped to downlevel compatible types for SSC. These types
Posted by SQLCEBLOG | 1 Comments
Filed under:
Wednesday, April 30, 2008 6:15 AM

Query performance

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance
Posted by SQLCEBLOG | 2 Comments
Thursday, April 03, 2008 4:13 PM

Dropping Defaults (Column Constraint)

There were some recent changes that were done in regards to column defaults. In this blog entry I want to bring out, what used to happen and what happens now. I have discussed the case of dropping a default on a column in this post, however, in a case
Posted by SQLCEBLOG | 1 Comments
Friday, March 07, 2008 4:36 PM

My First Entity Application Against SQLCE

Now that SQL Server Compact 3.5 SP1 Beta is released it's time to take the first step, making your first entity application using SQLCE as a backend. In his previous post, Ambrish gave steps on how to install SQL Server Compact SP1 Beta, along with Ado.Net
Posted by SQLCEBLOG | 8 Comments
Filed under:
More Posts Next page »
 
Page view tracker