Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

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

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

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

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 | 0 Comments
Filed under:

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 | 2 Comments
Filed under: ,

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 | 0 Comments
Filed under:

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

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 | 0 Comments

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:

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 Microsoft Download Center . To install SQL Server Compact 3.5 SP1 Beta Release for ADO.NET Entity Framework Beta 3 Install ADO.NET Entity Framework Beta
Posted by SQLCEBLOG | 8 Comments
Filed under: ,

SQL Server Compact Release Versions

This blog post is meant to give different build version numbers of our SQL Server Compact Releases. This blog post is a living one and gets updated for every release we make. Before getting into the mapping, first you want to know the version you are

Connectivity Cross Version Compatibility (SQL Server Compact 3.5)

Connectivity Cross Version Compatibility This blog post explains the Merge Replication connectivity cross version compatibility scenarios for the SQL Server Compact 3.5 release. For more information about the connectivity cross version compatibility scenarios

"Houston, we got some problem..." and "Houston, we got a problem..." - notice a difference?

So you have run into a problem - how to efficiently report this: System configuration: On a Desktop/Server, Run Winver from Start -> Run. On a Pocket PC, Start -> Settings -> About On a Smart Phone, a bit more steps - start -> Settings ->
Posted by SQLCEBLOG | 1 Comments
Filed under: ,

Can’t find P/Invoke DLL sqlcemeNN.dll

I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me for blogging about this error very lately. Better late than never and here it goes. What are the actual errors? 1) Can't find P/Invoke DLL sqlceme30.dll
Posted by SQLCEBLOG | 10 Comments
Filed under:

Troubleshooting: Can’t load sqlce dll

SQL Server CE/Comapct uses Windows API LoadLibrary ( PlatformBuilder or WinCE or Win32 ) to load the DLLs. When LoadLibrary fails to load any SQL CE dll, we throw the error “Can’t load sqlce dll”. Now, let’s discuss more on why LoadLibrary can fail. 1)
Posted by SQLCEBLOG | 3 Comments
Filed under:
More Posts Next page »
 
Page view tracker