SQL Server Compact Edition under ASP.net and IIS

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 things that can have wide range of usage scenarios.  Often developers pick up a gadget and…

14

Bill Vaughn writes an eBook on SQL Server Compact Edition

Just as Bill was finishing his Hitchhikers Guide to Visual Studio and SQL Server, SQL Server Compact Edtiion was releasing.  Bill wasn’t able to incorporate SQLce into his printed book, so he want the fast path, and wrote an eBook.  To date, this is the only book I, or the team has reviewed, so I…

6

Tool for scripting out your SQL Server databases for hosting

Dan from SQL Server has been driving an effort to improve the shared hosting story for web applications that rely on a SQL Server database.  We’ve all heard the customer complaints “How do I move my SQL Server Express database to GoDaddy?” ….. Well the SQL Server team released the first CTP of a client…

1

Live From Redmond WebCast: Offline Data Synchronization and Caching for Smart Clients

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 sync framework, so I’ll be showing mostly code on how to use our upcoming…

12

Dr. Dobbs Article on SQL Server Compact Edition

Several weeks ago, when the product was still named SQL Server Everywhere Edition, Mark Jewett and I did an interview with Scott Swigart for Dr. Dobbs.  The article is titled, SQL Server Everywhere: Just Another Database?  Of course, SQL Server Compact Edition, isn’t yet another, but the same.  Anyway, here’s the article: http://www.ddj.com/dept/database/193402926 Steve

0

Doc storage in SQLce and the 4gb limit

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 database.  On devices, space was confined, so these just weren’t mainline scenarios. …

20

Comparing SQL Server Express and Compact Editions Whitepaper

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 entry point from single user to multi-user scenarios.  With the release…

15

SQL Server Compact Edition RC1 Released

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=en, but I encourage you to check out the main page for Compact Edition at: http://www.microsoft.com/sql/compact  The page will have links to a comparison between Compact and Express edition…

10

SQL Server Compact Edition RC1 Released

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=en, but I encourage you to check out the main page for Compact Edition at: http://www.microsoft.com/sql/compact  The page will have links to a comparison between Compact and Express edition…

0

SQL Server Compact Edition RC1 goes live

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=en, but I encourage you to check out the main page for Compact Edition at: http://www.microsoft.com/sql/compact  The page will have links to a comparison between Compact and Express edition…

0