SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Express


SQL Server Express

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62428 Visits: 19102
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
My Blog: www.voiceofthedba.com
Brian Knight
Brian Knight
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: Moderators
Points: 2559 Visits: 235

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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62428 Visits: 19102

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
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search