sql server new users: I am self taught in Access using the Jet database, and am now looking at
upsizing my databases to SQL. I know enough to be dangerous, but not enough
to probably do the job correctly or get the most functionality out of SQL. I
am looking for any training suggestions that you may have. I am using SQL

How about:
Books:
The Guru's Guide to Transact-SQL

by Ken Henderson

http://www.amazon.com/exec/obidos/tg/detail/-/0201615762/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

Professional SQL Server 2000 Programming

by Robert Vieira

http://www.amazon.com/exec/obidos/tg/detail/-/0764543792/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

Inside Microsoft SQL Server 2000

by Kalen Delaney

http://www.amazon.com/exec/obidos/tg/detail/-/0735609985/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

Microsoft SQL Server 2000 Unleashed (2nd Edition)

by Ray Rankins, Paul Jensen, Paul Bertucci

http://www.amazon.com/exec/obidos/tg/detail/-/0672324679/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

Microsoft SQL Server 2000 Bible

by Paul Nielsen

http://www.amazon.com/exec/obidos/tg/detail/-/0764549359/102-4703055-5891314?v=glance

For absolute beginners, also consider:

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days

by Richard Waymire

http://www.amazon.com/exec/obidos/tg/detail/-/0672319691/qid=1128979097/sr=8-2/
ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books&n=507846

Database Design for Mere Mortals

by Michael Hernandez

http://www.amazon.com/exec/obidos/tg/detail/-/0201752840/qid=1128979174/sr=8-1/
ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books&n=507846

Joe Celko's SQL for Smarties (2005 Ed)

by Joe Celko

http://www.amazon.com/exec/obidos/tg/detail/-/0123693799/qid=1130172532/sr=1-1/
ref=ase_sql08-20/102-7073629-0803315?v=glance&s=books

Websites:

Microsoft SQL Server

http://www.microsoft.com/sql/default.mspx

SQL Server TechNet

http://www.microsoft.com/technet/prodtechnol/sql/default.mspx

SQL Server MSDN

http://msdn.microsoft.com/sql/default.aspx

SQL Server Community (awesome resources here)

http://www.microsoft.com/sql/community/relcommunities.mspx

Magazines:

SQL Server Magazine

http://www.windowsitpro.com/SQLServer/

Organizations:

PASS

http://www.sqlpass.org/

SSWUG

http://www.sswug.org/

------------------------------------------------------------------------------------------
"I sense many useless updates in you... Useless updates lead to
fragmentation... Fragmentation leads to downtime...Downtime leads to
suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG
and DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/

For upsizing specifically, check out:

http://www.apress.com/book/bookDisplay.html?bID=74

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
I am self taught in Access using the Jet database, and am now looking at
upsizing my databases to SQL. I know enough to be dangerous, but not enough
to probably do the job correctly or get the most functionality out of SQL.
I
am looking for any training suggestions that you may have. I am using SQL
Server 2000.