Materials Needed

As I am seeing SQL is t-o-t-a-l-l-y different from Access.
Is it practical to use VBA, or does that not apply?
Does anyone have some great links or book references on learning SQL.
Hungry for Info
David WYes, it is.
Which version of SQL are you using? Things change between versions,
especially in the administrative tools area.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David W" <davidw@.mcintoshconstruction.net> wrote in message
news:eo7OYGwQGHA.196@.TK2MSFTNGP10.phx.gbl...
> As I am seeing SQL is t-o-t-a-l-l-y different from Access.
> Is it practical to use VBA, or does that not apply?
> Does anyone have some great links or book references on learning SQL.
> Hungry for Info
> David W
>|||SQL Server Version 8.00.194
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23Q47INwQGHA.1160@.TK2MSFTNGP09.phx.gbl...
> Yes, it is.
> Which version of SQL are you using? Things change between versions,
> especially in the administrative tools area.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "David W" <davidw@.mcintoshconstruction.net> wrote in message
> news:eo7OYGwQGHA.196@.TK2MSFTNGP10.phx.gbl...
>|||>> As I am seeing SQL is t-o-t-a-l-l-y different from Access.Is it practical
to use VBA, or does that not apply? <<
Does not apply; VB is a proprietary programming language and SQL is a
ANSI/ISO Standard database language.
I like my books, but Rick van der Lans has a good intro and if you read
French, Fredericx Berouard's book is great and a bit more current.|||What do you mean by "materials" and what do you mean by "use VBA"?
The MSDE 2000 or SSEE 2005 editions of SQL Server are available for free
download. There is also a version of It can even be used in a production
environment, if you consider the CPU, memory, database size, and licensing
limitations:
http://msdn.microsoft.com/vstudio/e...ql/default.aspx
SSEE 2005 Documentation and Samples:
http://www.microsoft.com/downloads/...&displaylang=en
The SQL Server Management Studio application does not come bundled with SSEE
2005, but it can be downloaded from here:
http://www.microsoft.com/downloads/...&displaylang=en
Using SSEE from Visual Basic 6:
http://msdn.microsoft.com/vbrun/vbf...singsqlexpress/
As far as leaning SQL; it's like learning French. I can't really point to
any comprehensive site on the web, and it would involve perhaps a year or
more of job related mentoring or perhaps taking some CIS classes.
"David W" <davidw@.mcintoshconstruction.net> wrote in message
news:eo7OYGwQGHA.196@.TK2MSFTNGP10.phx.gbl...
> As I am seeing SQL is t-o-t-a-l-l-y different from Access.
> Is it practical to use VBA, or does that not apply?
> Does anyone have some great links or book references on learning SQL.
> Hungry for Info
> David W
>|||That is the RTM version of SQL 2000. I suggest downloading SQL Service Pack
4. There are some major security fixes that you need to add.
http://www.microsoft.com/downloads/...&displaylang=en
While you are there, you can get the updated Books-On-Line:
http://www.microsoft.com/sql/prodin...ions/books.mspx
For SQL Server administration, "Inside SQL Server 2000" by Kalen Delaney is
the first book you should own. There are lots of other books that drill
deeper into specific administrative areas, but this is the best "total
picture" book out there.
Joe Celko does have a good SQL programming book, "SQL For Smarties". He has
a strong preference for ANSI standard SQL over Microsoft T-SQL but the book
still has a lot of good information for Microsoft SQL users.
If you are just starting out with SQL Server, you might want to look at SQL
Server 2005 instead of SQL Server 2000 as your learning platform.
VBA is a scripting language for applications. SQL is a database service,
which is an altogether different beast. You will use T-SQL scripts and SQL
administrative tools to manage the system. You will need to write your own
front-end application for user data presentation and interaction. Here is
the most valuable advice I can give you on that subject. Do not, no matter
how tempting it is, use Access as your SQL front end. Repeat, Do not use
Access as a SQL Server front-end application.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David W" <davidw@.mcintoshconstruction.net> wrote in message
news:OXDnS53QGHA.6008@.TK2MSFTNGP10.phx.gbl...
> SQL Server Version 8.00.194
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23Q47INwQGHA.1160@.TK2MSFTNGP09.phx.gbl...
>|||What are your thought about SQL Server Express?
We will only have 5 pcs sharing this database.
Is there limitation with Express, I could not find anything about
limits,liscences,etc.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yeKIv6QGHA.4792@.TK2MSFTNGP14.phx.gbl...
> That is the RTM version of SQL 2000. I suggest downloading SQL Service
> Pack 4. There are some major security fixes that you need to add.
> http://www.microsoft.com/downloads/...&displaylang=en
> While you are there, you can get the updated Books-On-Line:
> http://www.microsoft.com/sql/prodin...ions/books.mspx
> For SQL Server administration, "Inside SQL Server 2000" by Kalen Delaney
> is the first book you should own. There are lots of other books that
> drill deeper into specific administrative areas, but this is the best
> "total picture" book out there.
> Joe Celko does have a good SQL programming book, "SQL For Smarties". He
> has a strong preference for ANSI standard SQL over Microsoft T-SQL but the
> book still has a lot of good information for Microsoft SQL users.
> If you are just starting out with SQL Server, you might want to look at
> SQL Server 2005 instead of SQL Server 2000 as your learning platform.
> VBA is a scripting language for applications. SQL is a database service,
> which is an altogether different beast. You will use T-SQL scripts and
> SQL administrative tools to manage the system. You will need to write
> your own front-end application for user data presentation and interaction.
> Here is the most valuable advice I can give you on that subject. Do not,
> no matter how tempting it is, use Access as your SQL front end. Repeat,
> Do not use Access as a SQL Server front-end application.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "David W" <davidw@.mcintoshconstruction.net> wrote in message
> news:OXDnS53QGHA.6008@.TK2MSFTNGP10.phx.gbl...
>|||SQL Server Express is a good tool for embedded or small scale databases. It
is free, it has some performance and size restrictions and is a lot better
than MSDE, the comparable edition for SQL 2000. If your needs are within
these limitations, it is an excellent product. I would obtain a developer
edition of SQL 2005 for development purposes and deploy to Express.
Here is the product page for SQL Server 2005 Express Edition:
http://www.microsoft.com/sql/editio...ss/default.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David W" <davidw@.mcintoshconstruction.net> wrote in message
news:uEMDUAGRGHA.1160@.TK2MSFTNGP09.phx.gbl...
> What are your thought about SQL Server Express?
> We will only have 5 pcs sharing this database.
> Is there limitation with Express, I could not find anything about
> limits,liscences,etc.
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23yeKIv6QGHA.4792@.TK2MSFTNGP14.phx.gbl...
>