SitePoint Sponsor

User Tag List

Results 1 to 21 of 21
  1. #1
    Drop em if you got em
    Join Date
    May 2003
    Location
    NY
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb SQL Server 2005 Express Preview

    MSDE is being given a rename and a bump up in features.

    I give you:
    SQL Server 2005 Express Edition
    Technical Preview


    The real question will be: Can this be a real alternative for people running dynamic websites who don't need all the power and features of SQL Server, yet already rely on things like stored procs that a db like mysql can't provide yet?
    (I'm currently reading the site in detail, but thought I'd post this before I'm finished)

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    yeah, that's pretty cool that they will upgrade MSDE

    too bad it still doesn't include DTS or Analysis Services
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Drop em if you got em
    Join Date
    May 2003
    Location
    NY
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I read my most important question answered - connection limit - which isn't a "connection limit" anymore, but a memory limit, 1GB.

  4. #4
    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 r937
    too bad it still doesn't include DTS or Analysis Services
    Whaddya mean? You can run DTSes on MSDE 7 and 2000 already!
    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!

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by MarcusJT
    Whaddya mean? You can run DTSes on MSDE 7 and 2000 already!
    you can run DTS if you have DTS, you don't get DTS with MSDE

    i happen to be one of those people who neither (a) owns a sql server license, nor (b) wishes to download the entire 800 gigabyte sql server install file just to pull the QA or DTS apps out of it, which is why i use WinSQL Lite instead of QA
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    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)
    Hmmm.... we have been running DTSes on remote MSDE 1.0/7 installations (via DTSRUN.EXE) for the last year, and they don't have anything other than the standard MSDE installation on them....?!
    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!

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    where did you get DTSRUN.EXE from?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  8. #8
    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)
    DTSRUN is certainly included in MSDE2000...
    http://www.microsoft.com/sql/msde/pr...o/features.asp

    And I'm pretty sure it was in MSDE1 too, but can't find any evidence on the web to support or contradict that...
    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!

  9. #9
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    that MSDE 2000 page says
    MSDE 2000 is capable of running Data Transformation Services (DTS) packages. However, it cannot design DTS packages, because it is not equipped with a DTS Designer.
    my point was, DTS doesn't come with MSDE

    just having DTSRUN.EXE in my Program Files folder doesn't do me a whole lotta good

    when i double-click it, i get a very brief flash of the DOS command shell window and then it shuts itself down

    thank goodness i'm not using MSDE for anything more sophisticated than testing sql server query syntax on small tables
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  10. #10
    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)
    r937, I'm really surprised at your posts this evening... are you an imposter?!
    Quote Originally Posted by r937
    that MSDE 2000 page says
    my point was, DTS doesn't come with MSDE
    What bit of DTS do you think MSDE doesn't come with? The DTS design GUI? That's part Enterprise Manager, which is merely the fronted app (similar to how Microsoft Access 2000 is the frontend for JET4 databases)!!

    My point is that all the functionality required to *run* DTSes is there, which is all you need on a production server that only needs to support a couple of clients.

    But of course if you want to use MSDE as a development platform, then yes, you will have to download EM (as part of the SQL2000 evaluation) in order to actually *create* DTSes.
    Quote Originally Posted by r937
    just having DTSRUN.EXE in my Program Files folder doesn't do me a whole lotta good

    when i double-click it, i get a very brief flash of the DOS command shell window and then it shuts itself down
    It's a console application! What do you expect it to do?!


    Shell out to the command prompt and run it to see what it outputs (if you haven't supplied command-line parameters then it will probably just spit out the syntax for its parameters)...

    Perhaps we're talking at cross-purposes here, because I can't believe that you don't already know this. If that is the case, then you must think me patronising, which is certainly unintentional, but I don't know how else to interpret and answer your comments!
    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!

  11. #11
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    look, i'm sorry, but all i did was try to make a point, and you keep wanting to steer me in other directions

    my point was, i don't have anything except MSDE

    so in order to run EM or QA or DTS, i need to download something else

    last time i looked, it was some humungous 400 meg sql server evaluation install (okay, so 800gigs was an exaggeration)

    furthermore, i have heard that after doing so, i would need to know how to pull EM or QA or DTS out of the file or folder or whatever gets downloaded, and given my experiences with microsoft installs, there is no way i'm going down that road, because i absolutely stink at installs

    heck, i needed help to install MSDE

    repeat: i absolutely stink at installs

    please go back to post #2, where i said "too bad it [MSDE] doesn't include DTS"

    don't get me wrong, i have used DTS before at work, it runs pretty well (although it's a b1tch to learn), but it's not so great that i would want to wrestle with the sql server evaluation install

    i'd rather have root canal than do installs

    installs are in the DBA's job description, and i am so not a DBA

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  12. #12
    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)
    Ok, cool.

    Just for the record, installing just the Enterprise Manager (and other GUI tools) is very easy once you have obtained the trial/full version. It's a fully-supported installation option, no jiggery-pokery required.

    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!

  13. #13
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by MarcusJT
    installing just the Enterprise Manager (and other GUI tools) is very easy once you have obtained the trial/full version. It's a fully-supported installation option, no jiggery-pokery required.
    thanks, i shall take your word for it, but shall nevertheless not attempt it

    you haven't seen me in action, but if you should ever find yourself in toronto canada, please look me up, i will invite you over to my place, where you can get free beer and in return offer me emotional and technical support as i flounder my way through the install

    meanwhile i have some other third-party tools which suit me just fine

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  14. #14
    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)
    Whatever lets you get the job done.


    PS - Cheers for the invite.
    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!

  15. #15
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by r937
    free beer
    Off Topic:

    Knock Knock

  16. #16
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    who's there?

    hey vinnie, how's the new job?

    i see you're getting pretty close to 10k...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  17. #17
    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)
    10K? Is that all they're paying you?
    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!

  18. #18
    Drop em if you got em
    Join Date
    May 2003
    Location
    NY
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'll confirm: after the chunky download, the install is pretty solid for EM. Just a couple of non-tricky options to set and then it's smooth sailing.

    I'm still waiting for the GUI they're developing for SQL Server Express. I know there aren't many people dying for this thing, but I am. I never wanted to drop the cash for my own SQL Server license, but MySQL just doesn't cut it for some of the things I'm doing (plus I already have so many nice stored procs written). This is the perfect in between for me, and if they can make a nice or even half-nice interface for it, I'm golden. Saving cash (the extra I pay for shared sql server hosting) and getting what I want

    Quote Originally Posted by MarcusJT
    10K? Is that all they're paying you?
    The rumor is Vinnie's not working for 10k, but 10k worth of twinkies and beer.

  19. #19
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    the reference was of course to vinnie's 10k posts

    hey vinnie, i see you just got married

    congrats
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  20. #20
    Drop em if you got em
    Join Date
    May 2003
    Location
    NY
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know I got it, I just do my best to work beer and twinkies into most conversations

  21. #21
    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 VodkaFish
    I know I got it
    Ditto. Just can't resist the opportunity for a lame joke when I see one!

    >>hangs head in shame<<
    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
  •