Looking to learn SQL

I was just wondering what's a good route to go to teach myself SQL. Like what books, projects, etc.
Thanks in advance,
AdamIntroduction to Structured Query Language Version 4.67 (http://riki-lb1.vet.ohio-state.edu/mqlin/computec/tutorials/SQLTutorial.htm)|||http://www.tutorialfind.com/tutorials/programming/sql/

and Teach Yourself SQL in 21 Days book available from http://lazurus.shacknet.nu:8000/

good luck.|||Thanks guys!|||Try this URL:

http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html

:cool:

Raymond|||thanks, raymond -- mine was only 4.67

:) :) :)

Looking for very good SQL Server DTS books

Hello, folks.

I'm searching for some good must-have books on SQL Server DTS. If you
are in the DTS business daily, you probably know which books are good
for DTS. I can browse some online book reviews but they are not all
trustworthy...I trust you better...hihi.

Please do me a favor.

Thanks.

TrentI listed a few DTS books at: http://vyaskn.tripod.com/sqlbooks.htm#dts

I personally haven't read any of them. But I did read, "SQL Server 2000 Fast
Answers for SQL Server DBAs and Developers". This is a good book, and
provides you with all the information you need, to get started on DTS:
http://vyaskn.tripod.com/sql_server...ast_answers.htm
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/

"Trent" <pineme@.yahoo.com> wrote in message
news:7ad7239b.0408181244.152a693d@.posting.google.c om...
> Hello, folks.
> I'm searching for some good must-have books on SQL Server DTS. If you
> are in the DTS business daily, you probably know which books are good
> for DTS. I can browse some online book reviews but they are not all
> trustworthy...I trust you better...hihi.
> Please do me a favor.
> Thanks.
> Trent

Looking for technical books

Hello everybody. I'm looking for book(s) that have very technical
information about MS SQL Server. For instance a book that has
information about that sysfiles queried in system stored procedures
always queries master. I can't find any books that have these kind of
details. Can anyone help?
DeboraIf you want information on internals then the book you need is:
http://www.insidesqlserver.com/book2000.html
David Portas
SQL Server MVP
--|||Hi
Another internals books that you should also check out in addition to
Kalen's is
"The Guru's guide to SQL Server Architecture and Internals" by Ken Henderson
ISBN 0-201-7004706 (you may want to get the whole boxed set!)
You may want to consider the articles that Kalen, Itzik and others do in SQL
Server Magazine
http://www.windowsitpro.com/SQLServer/
John
"Donck" <ddonck@.hotmail.com> wrote in message
news:1126163586.752794.246890@.g43g2000cwa.googlegroups.com...
> Hello everybody. I'm looking for book(s) that have very technical
> information about MS SQL Server. For instance a book that has
> information about that sysfiles queried in system stored procedures
> always queries master. I can't find any books that have these kind of
> details. Can anyone help?
> Debora
>

Looking for step by step guide/white paper to install MS SQL Clust

Hi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:

> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don DiegoHello,
I need to install a MS SQL 2000 Cluster server which will include 2 nodes
(setup as standard).
Where can I find a step by step documentation about that and
hardware/software requirements?
Thanks,
Don Diego|||Hi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:

> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don Diego

Looking for references for querying Active Directory (AD) through SQL Server

Does anyone know of any good references (books or web sites) that provide examples of querying AD from SQL Server? I have the database link setup and have done two very simple queries against AD but I would like to see more in-depth examples.

Thanks.

There are a lot of examples out there:

http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx
http://support.microsoft.com/kb/299410

http://blogs.msdn.com/ikovalenko/archive/2007/03/22/how-to-avoid-1000-rows-limitation-when-querying-active-directory-ad-from-sql-2005-with-using-custom-code.aspx

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Looking for information

I'm looking for books or information on command line configuration of settings for things like activating Remote Connections under the Service Area Configuration and setting a port for that connection.

What books would be good to get or where can I download papers on this?

Any help would be appreciated.

I'd say the best place to start would be SQL Books Online, http://msdn2.microsoft.com, or you can download them from the Microsoft Download Center, http://www.microsoft.com/downloads.

You can run command line configuration through the SACUtility, check out the BOL topic at http://msdn2.microsoft.com/en-us/library/ms162800.aspx.

I don't have any personal recomendations for books you can read, but a quick search gave me Microsoft SQL Server 2005 Administrator's Pocket Consultant from MS Press (http://www.microsoft.com/MSPress/books/6794.asp). Probably a bunch of interesting things in there. It mentions having a section on Install, configure and tune SQL Server.

Hope this helps.

Mike Wachal
SQL Express team