Newbie basic questions

[Kryten]

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

[Erland Sommarskog]

Kryten (Kr******@googlemail.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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx