SitePoint Sponsor

User Tag List

Results 1 to 18 of 18
  1. #1
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question SQL Server Developer Edition

    http://www.microsoft.com/sql/howtobuy/development.asp

    MS is lowering the price on this version to $49. I'm assuming that it should have EM included but can't tell for sure. Anyone know what exactly this version is and what is included? If EM is included, it would be well worth the price...

  2. #2
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    received a reply on the MS newsgroups. here is what he said, "The USD $49 figure is correct. The Developer Edition has all of the features of the full-blown Enterprise Edition. The difference is in licensing."

    sounds cool, now just to wait for aug 1...

  3. #3
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its free on MSDN...

  4. #4
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i don't have msdn...

  5. #5
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Now thats a crying shame
    I have MSDN on DVD at work, I think we have just about all the software ever produced by microsoft, whch we use to make programs for customers.

  6. #6
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah. well the company i work for doesn't have it and i can't afford at the moment. maybe when i'm not spending all my money on school (this december!! woo hoo!) i can spring for it.

  7. #7
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    MSDN subscriptions are like the most expensive things you can buy, EVER!
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  8. #8
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by M. Johansson
    MSDN subscriptions are like the most expensive things you can buy, EVER!
    ain't that the truth. actually, the student discount on that is pretty good. i'll have to maybe grab it before i graduate...

  9. #9
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    $49 seems quite reasonable, and is the "official" way to learn and develop on MSSQL. If it comes with supporting CDROMs and manuals, you should probably go for the deal.

    However, if it's just a CDROM and a license, then you're much better off installing MSDE 2000 (obtained from an Office XP CD, but also from a few other MS and / or 3rd party application CDs), then downloading the SQL Server 2000 trial and installing the Enterprise tools only - that'll give you a virtually identical setup (to the "Developer Edition") for free!! Same tools, same engine, same help files, same everything.

    That's what I and countless others use for local development, and it's as good as the real thing, *apart* from having a restricted number of concurrent users (which is fine for development).
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  10. #10
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Warning - MSDE does NOT contain full-text searching. If that is something your app will need, you'll need the full developer edition.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  11. #11
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That's true, MJ! Not something I've ever needed to use, so didn't think of it...
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  12. #12
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i have msde installed. but what i'm wanting is the Enterprise Manager. that's what i'm hoping is included in the developer edition.

  13. #13
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by bbolte
    i have msde installed. but what i'm wanting is the Enterprise Manager. that's what i'm hoping is included in the developer edition.
    Order the MSSQL trial edition from Microsoft. The enterprise manager and other tools doesn't expire.

    http://www.microsoft.com/sql/evaluation/trial/
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  14. #14
    SitePoint Wizard Mike Borozdin's Avatar
    Join Date
    Oct 2002
    Location
    Edinburgh, UK
    Posts
    1,743
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I use a trial edition of MS SQL that I obtained with some SQL book. It's written that it expires after 120 days but it hasn't expired for me

  15. #15
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by M. Johansson
    Order the MSSQL trial edition from Microsoft. The enterprise manager and other tools doesn't expire.

    http://www.microsoft.com/sql/evaluation/trial/
    i've downloaded the trial version. maybe i'll try istalling that first.

  16. #16
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The license expires, not the software.
    And you do want to use licenced software, don't you?

  17. #17
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MSDE doesn't do Indexed views, I recall. Also, maximum DB size of 2 GB and it throttles the number of threads used. Also, no chance of using fibers or paralell query execution. Also cant act as a transactional replication publisher, just a subscriber (bbut it can publish snapshot & megre replicas).

    But apart from that, MSDE is by far the best desktop redistributable DB I have ever seen. It has an unbeaten value for money ration, in my opinion!

  18. #18
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by bbolte
    i've downloaded the trial version. maybe i'll try istalling that first.
    Yes, as I said earlier!


    The order doesn't actually matter, but it will give you the enterprise tools, which is why I said what I said!
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •