Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Express Expand / Collapse
Author
Message
Posted Tuesday, June 29, 2004 4:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:43 PM
Points: 31,036, Visits: 15,462
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/sqlserver






Follow me on Twitter:
@way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #123745
Posted Friday, July 2, 2004 4:03 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234

Good article Steve. I disagree with the statement that MSDE and now SQL Express is not a production system. I always classified MSDE as a big version of Access. I see vendor product after vendor product ship with it due to the licensing being so generous. The products typically just use it as a configuration database vs and INI file since they're a bit more complex. Alteris for example stores what computers need to be scanned in MSDE and in my huge environment is only 50 MB. In these cases it fits great for people that don't need an Enterprise database but need something. Is it just me or has Access bit the dust in these cases in replacement for this?

It also does make an excellent learning system like you said for attaching Visual Studio to and whipping out a new app for a prototype.

 



Brian Knight
Free SQL Server Training Webinars
Post #124423
Posted Friday, July 2, 2004 7:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:43 PM
Points: 31,036, Visits: 15,462

That's true, in places MSDE and Express will probably make good systems, more like embedded systems. I still think of production as a system used by multiple people. Too often I've seen people try to showhorn Access or MSDE into a place that it didn't belong and when it grows they wonder why it doesn't perform.

The FAQs for express say that it's an evaluation and testing and learning tool right now. I was leaning more on that informaiton when I was writing.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #124490
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse