Newbie basic questions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Kryten
    #1

    Newbie basic questions

    Hi,
    I'm developing some Powershell applications that will need to pull
    data out of some sort of container.
    I've been playing around and had some success getting this working
    with MS Access. But for various I'm keen to explore other options for
    this database.

    I'm only going to need at most 12 tables, each with no more than 50
    records and 6 fields. Can this be set up visually in SQL, like in MS
    Access?

    What would I need to get started with this?

    If so, what would be the best book to buy to cover the basics?

    Thanks,
    Stuart





    Tags: None
    • Erland Sommarskog
      #2
      Re: Newbie basic questions

      Kryten (Kryten68@googl email.com) writes:
      I'm only going to need at most 12 tables, each with no more than 50
      records and 6 fields. Can this be set up visually in SQL, like in MS
      Access?
      You can do database diagrams in SQL Server Management Studio, but it's
      quite much of a toy feature. It's seriously broken when it comes to changing
      existing tables. Then again, it's probably designed for small-scale
      databases like yours, so you should be fine.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        Previous template Next
        Working...