SQL Server Express - Initial thoughts (by yag)

Published 29 June 04 03:35 AM

Man, blogging is addictive. I'm supposed to be paying attention in this session... <g> Anyway, wanted to note a few things about SQL Express because I haven't seen a lot about this online yet - though I expect that to change.

First - some of the capabilities:

  • Support for XCopy style deployment
  • No workload governor
  • Support for databases up to 4Gb in size
  • Support for up to 50 instances
  • Only supports 1 processor
  • Only supports 512 Mb of RAM

So - what we have here is a version of SQL Server that runs on your local machine - growing up to 4 gig. The XCopy deployment is also awesome. Instead of attaching/detaching the MDF, you'll be able to XCOPY the database to a new machine that has SSE running, and then just attach via the file path. Very easy deployment. Hooking that in with the new Click Once stuff in VS2005 is awesome. Deploy your winforms app securely and simply - including its database.

 

 

by vsdata
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Brian A. Randell said on June 29, 2004 3:54 AM:
Hey man!

You stole my list! ;-)

Cheers,

Brian
# yag said on June 29, 2004 3:59 AM:
Yeah, yeah, yeah, Brian. <g> I noticed that your entry is almost an hour before we opened up the info. <g>

For those who may not realize this - Brian and I are sitting side by side here in Amsterdam, typing blog comments at each other. <g> Pretty hopeless...
# Brian A. Randell said on June 29, 2004 7:02 AM:
Isn't WiFi Great?
# Brian A. Randell said on June 29, 2004 4:05 AM:
Server clock is wrong! I was framed! I was framed. ;-)
# David Hayden - Sarasota Web Design Development - F said on June 29, 2004 7:16 AM:
# Scott Galloway said on June 29, 2004 4:52 AM:
When you say 'Only supports 512 Mb of RAM' do you mean it only installs on machines with 512mb or less or that it only uses 512mb for itself (I assume the latter)
# Greg Collver said on June 29, 2004 8:13 AM:
http://lab.msdn.microsoft.com/express/sql/
# Lance Delano said on June 29, 2004 8:14 AM:
He means that it only uses 512 mb for itself.
# Ron Green said on June 29, 2004 8:24 AM:
Developer Center says it supports 1G of RAM.
# Alex Kazovic said on June 29, 2004 8:57 AM:
Does this mean that MS Access will in the next version use this instead of Jet?
# Sam Gentile's Blog said on June 29, 2004 3:18 PM:
# Deep Thoughts... said on June 29, 2004 4:24 PM:
# Di .NET e di altre amenit said on August 27, 2004 6:05 AM:

Leave a Comment

(required) 
(optional)
(required) 
Page view tracker