Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Server for Dummies (2000)

    A few weeks ago, in another thread, I asked about the best SQL books.

    Today, I installed VSTO, which includes an SQL Server 2000 Developer Edition.
    I had no clue about which options to choose, so I selected most defaults and now have SQL Server running.

    There's an icon in the system tray.

    It seems to me that I should use the SQL Server Service Manager to Stop the server and deselect the option to start the server when I reboot.
    I ASSuME that I can always restart the server when I need to play with SQL

    Does the above seem like the right strategy?

    Also, in addition to an SQL book, I likely (and more immediately) need an SQL Server 2000 book.
    Any recommendations other than the Mike Murach book mentioned in the thread in which I asked about SQL books?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SQL Server for Dummies (2000)

    Welcome to the world of SQL Server! Your strategy seems quite reasonable, as you don't really need the Database Engine running unless you are working with a database, and it does consume resources on your PC. I would recommend that you turn off the option that starts it automatically when you reboot.

    As to books, the SQL book previously recommended won't help much with the administrative side of things, as it focuses mostly on the syntax of Structured Query Language. What you are looking for is something that describes the administrative side - I would consider the "Microsoft SQL Server 2000 for Dummies" as a place to get started. For a (much) more detailed exploration of SQL Server, I like the Wrox books "Professional SQL Server 2000 Database Design" and "Professional SQL Server 2000 Programming" - but there is also the administrative side of SQL Server if you are looking to deploy a solution. For that you might consider "Microsoft SQL Server 2000 DBA Survival Guide, Second Edition" - it has lots of practical advice on keeping SQL Server databases humming along.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server for Dummies (2000)

    I decided to purchase:

    Programming MSFT SQL Server 2000 with MSFT VB .NET (ISBN: 0735615357)
    Portable DBA: SQL Server (ISBN: 0072230169)
    The Programmer's Guide to SQL (ISBN: 1590592182)

Posting Permissions

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