Anyone know of a good T-Sql Reference Code book?

Hi does anyone know of a good book that has all the t-sql keywords and functions in?? Or a webiste that has a printable version with explanations. I knows its on msdn but its very hard to print it all off.

I need something by my side so I can refer too and use in helping me build statements and sp,s etc.

Thanksfirst up, books online has the entire thing, though you can't print the lot at once.

secondly, MS Press has a complete reference called the SQL Server 2000 Reference Library. I'm not sure if it's available separately, but book 5 of the 6-book set is the complete T-SQL language reference. It's a tad expensive for the whole thing, and a web developer probably doesn't need the OLAP and warehousing books, but well worthwhile if you intend working heavily with SQL 2000. and it looks impressive on your bookshelf too.|||I would also think that the SQL Books Online are a very good resource (though oerhaps you might need to know the keyword to find information). Search for "Reserved Keywords" in Books Online (limit it to in Subject only) and you will get a good list of reserved words you can then search for details.|||Checkout something I made some time ago,
(the second page can B useful sometimes)

SQL.doc

Any MySQL book recommendations for newbie?

I just bought the book, Build Your Own Database Driven Website, by
Kevin Yank, and I'll start working on a database soon. Any other
books, etc., you can think of that a know-nothing newbie should read?
Is the book above a good one?

Thanks!
Steve HThis is a Microsoft SQL Server group so if you are looking for
recommendations on MySQL books you will probably get more help elsewhere.

Some book lists and other resources for SQLServer (not MySQL):

http://vyaskn.tripod.com/sqlbooks.htm
http://www.aspfaq.com/2423

--
David Portas
SQL Server MVP
--

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?
Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Lec...an/sqltut.html
|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:

>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource.c...mal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
Hugo Kornelis, SQL Server MVP
|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Le...man/sqltut.html|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:

>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource...rmal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
Hugo Kornelis, SQL Server MVP|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:
>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource.com/normal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
--
Hugo Kornelis, SQL Server MVP|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

Any good books on Microsoft Reporting Services for a Visual Studio developer?

I'm starting to useMicrosoft Reporting Services and coming from a Crystal background. I'm wondering if anyone is aware of a good book that addresses development of Microsoft reports within the Visual Studio context.

Thanks!

BCB

I just ordered Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson through amazon this morning. It is supposed to be here tomorrow sometime. I can let you know if it is any good. It did get good reviews on the amazon site and I also found amazon to be the cheapest.

I am having problems with my reporting deployment to the server. It keeps telling me that the ASPNET account does not have sufficient privileges to perform the operation.

|||I have been using Brian Larson's book (SQL Server 2005 Reporting Services) for several months and it is wonderful. It reminds me of a good Wrox book in the sense that it uses cumulative examples where a report that was developed earlier may be used as the basis for demonstrating a new feature. (Don't get me wrong - there are a bunch of report types in the book including Web Services.) You can work through the examples yourself or there is downloadable source code. The book covers both the design and administration side of Reporting Services. The book is less than 600 pages (not counting the appendices) and it has many screen shots that make explicit what the author has just described in words. I like that. The examples really work and files that he references are present in the folders where he states they will be found. I like that even more. Larson isn't just a technical guy who knows a lot about this product; he's an accomplished writer as well. I found that the book was a fairly quick read that managed to leave a lot of knowledge behind after I put it down for the final time. Did I mention that I recommend it?|||Hey guyin kalamazoo,

I just recently went through this learning curve. You have to add permissions for ASPNET to the database that the datasource is trying to access. Unless you store the credentials in the datasource, then it will use those credentials to access the database.

Anyway, look into the permissions for ASPNET on the machine with the database, and make sure you have the proper roles setup on the reporting server.

I hope this helps, as I am still relatively new to SSRS2005.

Anthony

Any Good Book Recommendations?

I know basic SQL and have passed two Oracle Exams, SQL and PL/SQL Programming. Ironically, my first (and only job unfortunately) was in MS SQL Server 2000. I want to know of a good overall SQL Book that is beyond beginner level. Something that answers questions like "How do you get rid of duplicate records in a table?", etc and other practical, real world issues. Is there such a text? It can be Oracle or MS or whatever as long as the theory is sound. Thanks.

ddaveWhile not a book, here are some good SQL sites:

Introduction to Structured Query Language
http://w3.one.net/~jhoffman/sqltut.htm
"Comprehensive SQL tutorial."

SQL Intrepreter & Tutorial With Live Practice Database
http://www.sqlcourse.com

SQL Tutorial
http://www.w3schools.com/sql/

aboutSQL by John Ashenfelter
http://www.oreillynet.com/pub/ct/19
"Provides information on SQL keywords, functions, tricks, and hacks"

SQLTeam.com
http://www.sqlteam.com
Site is mostly about SQL Server and includes forums.|||paul, the jim hoffman tutorial used to be the only decent sql tutorial on the web

but jim hoffman disappeared, and so did his site, a couple years ago

you can still get it at archive.org (http://web.archive.org/), where the latest version is November 2001, 4.76 (http://web.archive.org/web/20011116021648/http://w3.one.net/~jhoffman/sqltut.htm)

ddave, you may find some more tutorials on my SQL Links (http://r937.com/sqllinks.cfm) page

Any good book for T-SQL ?

Dear all, does anyone can recommand me a good book clearly explaining T SQL
fro SQL 2005 ?
thnakswww.insidetsql.com
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"calderara" <calderara@.discussions.microsoft.com> wrote in message
news:C6A8FD64-7E7C-426E-A658-0A5BA358667E@.microsoft.com...
Dear all, does anyone can recommand me a good book clearly explaining T SQL
fro SQL 2005 ?
thnaks

Any book on SQL

Hi,
I am lookig for some good booktitles for improving query building
capabilities. Any one has any suggestion regarding book or any other materia
l
please reply.
NilkanthThe Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
Microsoft SQL Server 2000 Unleashed (2nd Edition)
by Ray Rankins, Paul Jensen, Paul Bertucci
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
by Ken Henderson
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
By the way these are all T_SQL specific books, if you are looking for ANSI
SQL get one of Joe Celko's SQL books
Joe Celko's SQL for Smarties
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
If you are a complete beginnner this is a good book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
by Michael J. Hernandez, John L. Viescas
http://www.amazon.com/exec/obidos/A...65
67355
That should do it
http://sqlservercode.blogspot.com/
"Nilkanth Desai" wrote:

> Hi,
> I am lookig for some good booktitles for improving query building
> capabilities. Any one has any suggestion regarding book or any other mater
ial
> please reply.
> Nilkanth|||Refer this also
http://vyaskn.tripod.com/sqlbooks.htm
Madhivanan|||Advanced Transact-SQL for SQL Server 2000
<http://www.amazon.com/exec/obidos/t...=books&n=507846>
by Itzik Ben-Gan & Tom Moreau is also an excellent book. And while
Inside Microsoft SQL Server 2000
<http://www.amazon.com/exec/obidos/t...711117?v=glance>
(Delaney) is perhaps the best book in its class (or perhaps tied with
Ken Henderson's Guru's Guide
<http://www.amazon.com/exec/obidos/t...g=UTF8&v=glance> ),
it's not really a "teach yourself T-SQL" type book but rather a "learn
everything there is to know about _SQL Server internals_".
Also, I came across this Amazon booklist by Fernando Guerrero
<http://www.solidqualitylearning.com...spx?source=S_FG> (SQL MVP &
one of the main SQL dudes at Solid Quality Learning) as I was looking up
the Amazon reference for Itzik & Tom's book:
Essential SQL Server Books
<http://www.amazon.com/exec/obidos/t...8387021-1711117>
*mike hodgson*
blog: http://sqlnerd.blogspot.com
SQL wrote:
>The Guru's Guide to Transact-SQL
>by Ken Henderson
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>Professional SQL Server 2000 Programming
>by Robert Vieira
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>Inside Microsoft SQL Server 2000
>by Kalen Delaney
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>Microsoft SQL Server 2000 Unleashed (2nd Edition)
>by Ray Rankins, Paul Jensen, Paul Bertucci
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
>by Ken Henderson
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>By the way these are all T_SQL specific books, if you are looking for ANSI
>SQL get one of Joe Celko's SQL books
>Joe Celko's SQL for Smarties
>http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
>
>If you are a complete beginnner this is a good book
>SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
>by Michael J. Hernandez, John L. Viescas
>http://www.amazon.com/exec/obidos/A...6
567355
>
>That should do it
>http://sqlservercode.blogspot.com/
>
>"Nilkanth Desai" wrote:
>
>

Any Book on MetaData Services ?

Looking for a good book on SQL Server metadata services user guide. Any
idea ?
Thanks
Mac
I don't know of any commercial books but there is a fair amount of
information right in BooksOnLine under "Meta data".
Andrew J. Kelly SQL MVP
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> Looking for a good book on SQL Server metadata services user guide. Any
> idea ?
> Thanks
> Mac
>
|||Good Day,
Our organization would like to make use of sql server repository meta data
for use in our CIM system (following DMTF standards).
I have created a repository database, imported an information model into it,
and am now trying to program using the Meta Data SDK API.
In my view the API is not well documented at all. The documentation
describes the API but offers very very little in the way of examples. Am i
missing something or is there very little in the way of examples to use this
technology.
I also have found virtually no books on the subject matter that can help us.
Any help in this area is greatly appreciatted as there are virtually no
examples on the net either. I wonder if we are on the right track or if this
is so new that nobody has put out information on how to use it.
Thanks in advance,
Mike
"Andrew J. Kelly" wrote:

> I don't know of any commercial books but there is a fair amount of
> information right in BooksOnLine under "Meta data".
> --
> Andrew J. Kelly SQL MVP
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
>
>
|||I can see why there is little docs. In all the years I have worked with SQL
Server I didn't even know it had a Meta Data SDK. I would have to assume
you are one of the few who chose to use it. That does not mean it is not
useful, just not popular. If you do a search on Google as this:
site:support.microsoft.com meta data sdk
you should see a number of related hits. The first that I see looks the most
promising:
http://support.microsoft.com/?kbid=238912
Andrew J. Kelly SQL MVP
"WestyManBC" <WestyManBC@.discussions.microsoft.com> wrote in message
news:A65BD6AC-D351-4A76-9235-623F94008FA6@.microsoft.com...[vbcol=seagreen]
> Good Day,
> Our organization would like to make use of sql server repository meta data
> for use in our CIM system (following DMTF standards).
> I have created a repository database, imported an information model into
> it,
> and am now trying to program using the Meta Data SDK API.
> In my view the API is not well documented at all. The documentation
> describes the API but offers very very little in the way of examples. Am i
> missing something or is there very little in the way of examples to use
> this
> technology.
> I also have found virtually no books on the subject matter that can help
> us.
> Any help in this area is greatly appreciatted as there are virtually no
> examples on the net either. I wonder if we are on the right track or if
> this
> is so new that nobody has put out information on how to use it.
> Thanks in advance,
> Mike
> "Andrew J. Kelly" wrote:

Any Book on MetaData Services ?

Looking for a good book on SQL Server metadata services user guide. Any
idea ?
Thanks
MacI don't know of any commercial books but there is a fair amount of
information right in BooksOnLine under "Meta data".
--
Andrew J. Kelly SQL MVP
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> Looking for a good book on SQL Server metadata services user guide. Any
> idea ?
> Thanks
> Mac
>|||Good Day,
Our organization would like to make use of sql server repository meta data
for use in our CIM system (following DMTF standards).
I have created a repository database, imported an information model into it,
and am now trying to program using the Meta Data SDK API.
In my view the API is not well documented at all. The documentation
describes the API but offers very very little in the way of examples. Am i
missing something or is there very little in the way of examples to use this
technology.
I also have found virtually no books on the subject matter that can help us.
Any help in this area is greatly appreciatted as there are virtually no
examples on the net either. I wonder if we are on the right track or if this
is so new that nobody has put out information on how to use it.
Thanks in advance,
Mike
"Andrew J. Kelly" wrote:
> I don't know of any commercial books but there is a fair amount of
> information right in BooksOnLine under "Meta data".
> --
> Andrew J. Kelly SQL MVP
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> > Looking for a good book on SQL Server metadata services user guide. Any
> > idea ?
> >
> > Thanks
> > Mac
> >
> >
>
>|||I can see why there is little docs. In all the years I have worked with SQL
Server I didn't even know it had a Meta Data SDK. I would have to assume
you are one of the few who chose to use it. That does not mean it is not
useful, just not popular. If you do a search on Google as this:
site:support.microsoft.com meta data sdk
you should see a number of related hits. The first that I see looks the most
promising:
http://support.microsoft.com/?kbid=238912
--
Andrew J. Kelly SQL MVP
"WestyManBC" <WestyManBC@.discussions.microsoft.com> wrote in message
news:A65BD6AC-D351-4A76-9235-623F94008FA6@.microsoft.com...
> Good Day,
> Our organization would like to make use of sql server repository meta data
> for use in our CIM system (following DMTF standards).
> I have created a repository database, imported an information model into
> it,
> and am now trying to program using the Meta Data SDK API.
> In my view the API is not well documented at all. The documentation
> describes the API but offers very very little in the way of examples. Am i
> missing something or is there very little in the way of examples to use
> this
> technology.
> I also have found virtually no books on the subject matter that can help
> us.
> Any help in this area is greatly appreciatted as there are virtually no
> examples on the net either. I wonder if we are on the right track or if
> this
> is so new that nobody has put out information on how to use it.
> Thanks in advance,
> Mike
> "Andrew J. Kelly" wrote:
>> I don't know of any commercial books but there is a fair amount of
>> information right in BooksOnLine under "Meta data".
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
>> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
>> > Looking for a good book on SQL Server metadata services user guide.
>> > Any
>> > idea ?
>> >
>> > Thanks
>> > Mac
>> >
>> >
>>