SQL server 2000 for a VB.NET developer

Discussion in 'MCSD' started by Venkat, Dec 3, 2003.

  1. Venkat

    Venkat Guest

    Hey all,

    I have no prior experienc with SQL server 2000 but I
    develop web applications that interface with MS Access
    databases all the time.

    Do you know of any good books at the beginner level to
    learn more about SQL server 2000 from a VB.NET
    programmer's point of view?

    Thanks!
    Venkat
    Venkat, Dec 3, 2003
    #1
    1. Advertising

  2. Venkat

    Guest Guest

    If you are using ADO.NET, then there is little difference between selecting,
    inserting, updating a SQL Server database and a MS Access database. Are you
    basically wanting to learn T-SQL and stored procedures?


    "Venkat" <> wrote in message
    news:0cff01c3b9b4$cd210150$...
    > Hey all,
    >
    > I have no prior experienc with SQL server 2000 but I
    > develop web applications that interface with MS Access
    > databases all the time.
    >
    > Do you know of any good books at the beginner level to
    > learn more about SQL server 2000 from a VB.NET
    > programmer's point of view?
    >
    > Thanks!
    > Venkat
    >
    Guest, Dec 3, 2003
    #2
    1. Advertising

  3. Venkat

    Venkat Guest

    I am looking for something that will answer basic
    questions like:

    1. What is SQl server?
    2. How does it work?
    3. How is it different from MS access?
    4. Where can I get a free version of SQl server?
    5. How do I get it up and running on a standalone
    development machine?
    5. How do I develop databases with SQl server?
    6. How do I make those databases talk to VB.NET?

    Thanks!
    Venkat

    >-----Original Message-----
    >If you are using ADO.NET, then there is little difference

    between selecting,
    >inserting, updating a SQL Server database and a MS Access

    database. Are you
    >basically wanting to learn T-SQL and stored procedures?
    >
    >
    >"Venkat" <> wrote in message
    >news:0cff01c3b9b4$cd210150$...
    >> Hey all,
    >>
    >> I have no prior experienc with SQL server 2000 but I
    >> develop web applications that interface with MS Access
    >> databases all the time.
    >>
    >> Do you know of any good books at the beginner level to
    >> learn more about SQL server 2000 from a VB.NET
    >> programmer's point of view?
    >>
    >> Thanks!
    >> Venkat
    >>

    >
    >
    >.
    >
    Venkat, Dec 3, 2003
    #3
  4. Venkat

    Guest Guest

    There are a lot of good SQL Server FAQs on the web:
    http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm

    You can purchase SQL Server Developer Edition for about $100. It is almost
    identical to Enterprise Edition but does not accept external connections.

    Barnes & Noble is good place to browse tech books.


    "Venkat" <> wrote in message
    news:0c0f01c3b9bc$ef6e9da0$...
    > I am looking for something that will answer basic
    > questions like:
    >
    > 1. What is SQl server?
    > 2. How does it work?
    > 3. How is it different from MS access?
    > 4. Where can I get a free version of SQl server?
    > 5. How do I get it up and running on a standalone
    > development machine?
    > 5. How do I develop databases with SQl server?
    > 6. How do I make those databases talk to VB.NET?
    >
    > Thanks!
    > Venkat
    >
    > >-----Original Message-----
    > >If you are using ADO.NET, then there is little difference

    > between selecting,
    > >inserting, updating a SQL Server database and a MS Access

    > database. Are you
    > >basically wanting to learn T-SQL and stored procedures?
    > >
    > >
    > >"Venkat" <> wrote in message
    > >news:0cff01c3b9b4$cd210150$...
    > >> Hey all,
    > >>
    > >> I have no prior experienc with SQL server 2000 but I
    > >> develop web applications that interface with MS Access
    > >> databases all the time.
    > >>
    > >> Do you know of any good books at the beginner level to
    > >> learn more about SQL server 2000 from a VB.NET
    > >> programmer's point of view?
    > >>
    > >> Thanks!
    > >> Venkat
    > >>

    > >
    > >
    > >.
    > >
    Guest, Dec 3, 2003
    #4
  5. Venkat

    EC Guest

    Ms Access is a toddler and SQL Server is a grown-up. You can download the
    trial version, good for 120 days, at:
    http://www.microsoft.com/sql/evaluation/trial/default.asp

    When on the page, click on the "SQL Server 2000 Features" link to read what
    SQL Server is and how it works.

    Installing it on your standalone development machine , which is a straight
    forward task, and its Service Mager will be automatically run by default.

    Read the Books Online after the installation. The "Building SQL Server
    Application" section contains all information you are asking here.

    Microsoft ADO .NET Step by Step book should be good for a beginner level of
    both the VB .Net and C# .NET.

    "Venkat" <> wrote in message
    news:0c0f01c3b9bc$ef6e9da0$...
    > I am looking for something that will answer basic
    > questions like:
    >
    > 1. What is SQl server?
    > 2. How does it work?
    > 3. How is it different from MS access?
    > 4. Where can I get a free version of SQl server?
    > 5. How do I get it up and running on a standalone
    > development machine?
    > 5. How do I develop databases with SQl server?
    > 6. How do I make those databases talk to VB.NET?
    >
    > Thanks!
    > Venkat
    >
    > >-----Original Message-----
    > >If you are using ADO.NET, then there is little difference

    > between selecting,
    > >inserting, updating a SQL Server database and a MS Access

    > database. Are you
    > >basically wanting to learn T-SQL and stored procedures?
    > >
    > >
    > >"Venkat" <> wrote in message
    > >news:0cff01c3b9b4$cd210150$...
    > >> Hey all,
    > >>
    > >> I have no prior experienc with SQL server 2000 but I
    > >> develop web applications that interface with MS Access
    > >> databases all the time.
    > >>
    > >> Do you know of any good books at the beginner level to
    > >> learn more about SQL server 2000 from a VB.NET
    > >> programmer's point of view?
    > >>
    > >> Thanks!
    > >> Venkat
    > >>

    > >
    > >
    > >.
    > >
    EC, Dec 3, 2003
    #5
  6. Venkat

    Schfooge Guest

    <WKidd> wrote in message news:#...
    > There are a lot of good SQL Server FAQs on the web:
    > http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm
    >
    > You can purchase SQL Server Developer Edition for about $100. It is almost
    > identical to Enterprise Edition but does not accept external connections.


    Or you can start out with the SQL Server 2000 Desktop Engine
    (also known as the MS Data Engine (MSDE)). It's free and you
    can download it from microsoft at:
    http://www.microsoft.com/sql/msde/downloads/default.asp
    Schfooge, Dec 4, 2003
    #6
  7. Venkat

    Guest Guest

    MSDE is o.k. if and when it comes time to deploy a distributed database on
    the user's PC. However, he may want to become familiar with the standard GUI
    (EM, QA, etc.) if he wants to lean SQL Server for the exam.

    As far as I know, the only GUI for MSDE are provided by 3rd parties?

    "Schfooge" <> wrote in message
    news:hMBzb.136177$...
    > <WKidd> wrote in message news:#...
    > > There are a lot of good SQL Server FAQs on the web:
    > > http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm
    > >
    > > You can purchase SQL Server Developer Edition for about $100. It is

    almost
    > > identical to Enterprise Edition but does not accept external

    connections.
    >
    > Or you can start out with the SQL Server 2000 Desktop Engine
    > (also known as the MS Data Engine (MSDE)). It's free and you
    > can download it from microsoft at:
    > http://www.microsoft.com/sql/msde/downloads/default.asp
    >
    >
    Guest, Dec 4, 2003
    #7
  8. Venkat

    Kline Sphere Guest

    >As far as I know, the only GUI for MSDE are provided by 3rd parties?

    No big lose. Gives people the opportunity to learn how to write
    scrips.
    Kline Sphere, Dec 4, 2003
    #8
  9. Venkat

    Kline Sphere Guest

    > You can install the Enterprise Manager from a SQL
    >Server 2000 install disk:


    By doing so, may be illegal.
    Kline Sphere, Dec 4, 2003
    #9
  10. Venkat

    Schfooge Guest

    <WKidd> wrote in message news:...
    >
    > MSDE is o.k. if and when it comes time to deploy a distributed database on
    > the user's PC. However, he may want to become familiar with the standard

    GUI
    > (EM, QA, etc.) if he wants to lean SQL Server for the exam.
    >
    > As far as I know, the only GUI for MSDE are provided by 3rd parties?
    >


    What I was thinking was that he might want to play around with
    the MSDE first a bit before laying out money on a developer copy.


    And tecnically there is a Microsoft GUI you can use with the
    MSDE. You can install the Enterprise Manager from a SQL
    Server 2000 install disk:

    1. choose "SQL Server 2000 Components" from the startup screen.
    2. choose "Install database server"
    3. go throught the install process until you reach a screen offering
    you the option of: Client Tools Only
    Server And Client Tools
    Connectivity Only
    4. choose "Client Tools Only" and finish the installation.

    This installs the Enterprise Manager, and it works no problem
    with the MSDE. The only catch is that you have to own a
    license for the SQL Server 2000 disk for this to be legal.
    This setup is great for learning SQL Server on a single machine
    or a small home network.
    Schfooge, Dec 5, 2003
    #10
  11. Venkat

    Schfooge Guest

    "Kline Sphere" <.> wrote in message
    news:...
    > > You can install the Enterprise Manager from a SQL
    > >Server 2000 install disk:

    >
    > By doing so, may be illegal.


    As long as you own a license for the SQL Server 2000 install
    CD, this is legal.
    Schfooge, Dec 6, 2003
    #11
  12. Venkat

    Kline Sphere Guest

    >> By doing so, may be illegal.
    >
    >As long as you own a license for the SQL Server 2000 install
    >CD, this is legal.


    Hence why I said 'may be illegal'.
    Kline Sphere, Dec 6, 2003
    #12
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Whiting
    Replies:
    2
    Views:
    690
    Brian Whiting
    Dec 29, 2005
  2. Brunswick Lowe

    SQL Server 2000 Developer Edition

    Brunswick Lowe, Dec 17, 2003, in forum: MCSD
    Replies:
    12
    Views:
    777
    Cowboy \(Gregory A. Beamer\)
    Dec 24, 2003
  3. Ionizer
    Replies:
    1
    Views:
    1,529
  4. vvcd
    Replies:
    0
    Views:
    1,888
  5. TEL
    Replies:
    0
    Views:
    689
Loading...

Share This Page