Steve Lasker's Web Log - www.SteveLasker.com/Blog

On April 6, 2006 Paul Flessner announced SQL Server Everywhere Edition, know known as SQL Server Compact Edition. http://www.microsoft.com/sql/letter.mspx SQL Server Compact Edition a new SKU in the Microsoft product platform. Paul announced that we would...

In most cases you'll want to create your database and it's schema as part of your applications first deployment. Depending on the scenario, you may create it on the client, or create it on the server, do the initial sync, then stream the file down to...

SQL Server Everywhere gets a new name...

Not surprisingly we've been get a lot of great questions about specific features and scenarios for our new Sync Services for ADO.NET (OCS). Rafik has been fielding most of these on the Sync Services forums . Since the Q&A for SQLce seemed popular...

Recently I’ve been giving some presentations on our upcoming sync framework. This new sync framework is designed to fill the void between the simplicity of RDA (Remote Data Access), full featured, but complex, Merge Replication, and raw components of...

We've started to get a number of request whether SQL Server Compact will support 64bit. The answer is absolutely YES! Ok, but when? We'll, that part we're working on. Up until recently, we haven't really seen a big need as the number of clients that have...

I'm happy to announce the release of SQL Server Compact - SP1 This release includes several key features and bug fixes following up on the asks of our customers. The new features in SQL Server Compact 3.5 SP1 are: ADO.NET Entity Framework...

Today we launched the public CTP of the Sync Services for ADO.NET. This is the current name of features we've been referring to as Occasionally Connected Systems (OCS). The SQL Server Compact Edition and Sync Platform teams have been working feverishly...

In part 1 , I used the Visual Studio Orcas Sync Designer to configure and synchronize 3 lookup tables to be cached locally in SQL Server Compact Edition using the Sync Services for ADO.NET CTP. In part 2 of this screen cast, I take the cached lookup tables...

A number of people have been a bit confused how to get SQL Server 2005 Compact Edition (also known as version 3.1) working with Visual Studio 2005. The fact that we enabled a new product mid-steam within a Visual Studio ship cycle was quite an accomplishment...

Completely acknowledging the lack of an integrated local database story with Silverlight, there are many solutions out there. Curious what you use, what you like, and what’s missing from your favorite solution. Since various solutions cover various...

We’ve been getting a number of questions regarding Doc/blob storage and the current 4gb limit. For doc storage, I’m hearing two concerns. Perf when SQLce is used for blob storage. Removing the 4gb limit so that you can store more docs in the...

SQL Server Everywhere CTP is here......

On Wednesday, Jan 16 th '08 from 9am-10am PST time, I'll be doing an MSDN Live webcast covering an introduction to SQL Server Compact 3.5. This will be my first public presentation of SQL Server Compact since we've shipped last November. Working at...

Here's part 1 of the new Sync Designer. In this screen cast I walk through how to cache lookup tables locally. In this screencast I use the 2 tier sync, starting simple. In the next screencast I'll show how to take the same designer, and split it across...

Release UPDATE: We've since shipped SQL Server Compact, so these B2 links are no longer valid. There were some good comments on the blog, so keeping with blog tradition, I don't want to kill this post. To get the final, released, RTM product, please...

We just published a whitepaper comparing Express and Compact Edition. The reality is the paper tends to focus less on a direct comparison of the products, but rather an evaluation of what’s needed in a local data store. Express edition is our Data Service...

We routinely get requests, complaints, or sometimes even threats, (If you don’t enable it, I’ll use product X), regarding usage of SQLce and ASP.net. Here’s a little background on the positioning. Technology, or specifically software, is one of those...

When privately deploying SQL Server Compact you will need to take a few extra steps if you wish to use the ADO.NET Entity Model. Here's some info on how to do it. Why the extra steps? The ADO.NET Entity model was designed as a mid-tier solution. In...

Much has been debated about the need for stored procedures within SQL Server Compact. We often hear customers say, "Without stored procedures, how can you call yourself a real database". Followed by: "Is this just a temporary situation, or will SQLce...

As developers start architecting their apps with Sync Services for ADO.NET they're starting to ask questions about the holes we didn't get complete in this 1.0 release. One such topic is how can I send changes from the server to the client, without the...

On November 14th, from 9-10am PST, I'll be giving a web cast covering our new Sync Services runtime. The abstract discusses existing technologies, including RDA and Merge, but based on customer feedback, it seems developers really want to see the new...

Some demo videos of various features and components that enable Occasionally Connected Applications I’ll continue to add links to videos of demos for various scenarios. Visual Studio 2005 (Whidbey) Features Using SQL Server Mobile w/Visual Studio...

Well, after several name changes, power outages, the holidays, and crippling winter storms, we've released SQL Server Compact Edition 3.1. http://www.microsoft.com/sql/compact While not required to use SQLce 3.1, you can get the benefit of the new ClickOnce...

At Tech Ed EMEA today SQL Server Compact Edition RC1, formerly known as Everywhere edition, was announced for general availability. The direct download page is at: http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang...