Books on SSRS

Any recommendations on best book(s) to get a quick start with SQL Reorting
Services ? and hopefully with some depth ?
Thanks ....Liz,
did you try to query Amazon ' I found some... unfortunatly I haven't found
the time to order and read one.... maybe this helps a bit...
Regards
/Martin
"Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> Any recommendations on best book(s) to get a quick start with SQL Reorting
> Services ? and hopefully with some depth ?
> Thanks ....
>|||Also take a look at
http://www.microsoft.com/sql/reporting/techinfo/books.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:Oah0Ol7hEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Liz,
> did you try to query Amazon ' I found some... unfortunatly I haven't
found
> the time to order and read one.... maybe this helps a bit...
> Regards
> /Martin
> "Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
> news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> >
> > Any recommendations on best book(s) to get a quick start with SQL
Reorting
> > Services ? and hopefully with some depth ?
> >
> > Thanks ....
> >
> >
>

Book recommendations?

I do software support for software that works with both Oracle and SQL
Server, so I mostly just write queries to look at the data related to
the software. When I first started, I bought a couple of books to learn
the basics, intentionally going with generic books that would help with
both types of databases. I've got the basics down, and now I'm looking
for a really detailed reference book that goes really indepth into
querying for SQL Server specifically. Currently, we only work with the
2000 version, but we'll be going to 2005 soon, so I think I'd rather go
with a book on 2005, although if you know one that covers the
differences between them, that would be great. Any recommendations?

Besides just writing queries, I'd also like to learn more about SQL
Server in general. DBA software support, so I'd like to head my
career in that direction. I was looking at Microsoft's new
certification path for SQL 2005. Given that my company won't pay to
send me for training, and I really don't want to have to put down
$2200+ to pay for a class, I was thinking that I might be able to learn
enough on my own to pass the first test and get the MCTS title. I
ordered the Training Kit from Microsoft Press for that, which comes
with a 180 day trial of SQL Server 2005 to play with, along with a huge
book. Does anyone have any other recommendations for resources to help
learn this stuff?

--Richardblueghost73@.yahoo.com (blueghost73@.yahoo.com) writes:

Quote:

Originally Posted by

I do software support for software that works with both Oracle and SQL
Server, so I mostly just write queries to look at the data related to
the software. When I first started, I bought a couple of books to learn
the basics, intentionally going with generic books that would help with
both types of databases. I've got the basics down, and now I'm looking
for a really detailed reference book that goes really indepth into
querying for SQL Server specifically. Currently, we only work with the
2000 version, but we'll be going to 2005 soon, so I think I'd rather go
with a book on 2005, although if you know one that covers the
differences between them, that would be great. Any recommendations?

The ultimate book on writing queries on SQL 2005 simply must be "Inside
T-SQL Querying" by Itzik Ben-Gan on Microsoft Press. If there is a problem
he can't write a query for, then there is simple is no query to write - or
the query is not worth writing. I'm just about to read the book myself,
so I cannot say how much he compares with SQL 2000.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||According to Amazon, Ken Henderson is not even planning to release a
book about 2005 yet. What a pity.|||Erland Sommarskog wrote:

Quote:

Originally Posted by

>
The ultimate book on writing queries on SQL 2005 simply must be "Inside
T-SQL Querying" by Itzik Ben-Gan on Microsoft Press.

Here's a link to the book:
http://www.microsoft.com/MSPress/books/9615.asp
and the actual title is:
"Inside Microsoft SQL Server 2005: T-SQL Querying"|||metaperl wrote:

Quote:

Originally Posted by

Erland Sommarskog wrote:
>

Quote:

Originally Posted by

The ultimate book on writing queries on SQL 2005 simply must be "Inside
T-SQL Querying" by Itzik Ben-Gan on Microsoft Press.

>
Here's a link to the book:
http://www.microsoft.com/MSPress/books/9615.asp
>
and the actual title is:
"Inside Microsoft SQL Server 2005: T-SQL Querying"

So apparently, there's a consensus that this is THE book for T-SQL.
That's just odd. I've been using Usenet for 15 years, and I've never
seen an agreement before. Where's the usual flame war? :P

In looking into this book, I noticed that the author posted some
comments on amazon.com that the rest of you might be interested in.
Here they are:

--
FAQ - what's the difference between the two books ("T-SQL Querying" and
"T-SQL Programming")?

I often get this question, so I'll use this opportunity to clarify
things.

The original intention was to cover T-SQL Querying and Programming in
one book, but we realized that it would end up with 1,200 - 1,300
pages. So we decided to split the content into two books. You can think
of T-SQL Querying as Volume 1 and of T-SQL Programming as Volume 2.

T-SQL Querying focuses on querying and query tuning/optimization.
T-SQL Programming focuses on programmatic constructs (T-SQL and CLR
routines, XML, Service Broker, Dynamic SQL, Cursors, etc.).

Make sure you read T-SQL Querying before T-SQL Programming.

Here's the TOC for T-SQL Querying:
Chapter 01 - Logical Query Processing
Chapter 02 - Physical Query Processing
Chapter 03 - Query Tuning
Chapter 04 - Subqueries, Table Expressions and Ranking Functions
Chapter 05 - Joins and Set Operations
Chapter 06 - Aggregating and Pivoting Data
Chapter 07 - TOP and APPLY
Chapter 08 - Data Modification
Chapter 09 - Graphs, Trees, Hierarchies and Recursive Queries
Appendix A - Logic Puzzles

And here's the TOC for T-SQL Programming:
Chapter 01 - Datatype Related Problems, XML, and CLR UDTs
Chapter 02 - Temporary Tables and Table Variables
Chapter 03 - Cursors
Chapter 04 - Dynamic SQL
Chapter 05 - Views

T-SQL and CLR Routines:
Chapter 06 - User Defined Functions
Chapter 07 - Stored Procedures
Chapter 08 - Triggers

Chapter 09 - Transactions
Chapter 10 - Exception Handling
Chapter 11 - Service Broker
Appendix A - Companion to CLR Routines

Let me know if you have any questions.

Itzik
--
Hi all,

You can find detailed info about the book at www.insidetsql.com
including: TOC, Sample Chapters (just uploaded), Source Code, Links to
Related Resources, Corrections, Letter to the Reader, Author BIOs.
Please let me know if the organization of the website is convenient for
you or if you think that some things should be changed/added. Also, I'd
be glad to get any comments/questions regarding the book. You can
contact me through the website or through
itzik@.solidqualitylearning.com.

Cheers,
Itzik
--sql

book recommendations: ETL

Could any one please recommend some good books on sql server 2000 ETL best
practices '
I am trying to learn some best practices regarding this subject so any white
papers, articles, web sites, books would be greatly appreciated.
TIA...sqlster,
Check out:
http://www.sqldts.com/
and
http://www.sqldts.com/default.aspx?400
HTH
Jerry
"sqlster" <nospam@.nospam.com> wrote in message
news:FF107389-91B8-4397-ABA2-903C89EEAB30@.microsoft.com...
> Could any one please recommend some good books on sql server 2000 ETL best
> practices '
> I am trying to learn some best practices regarding this subject so any
> white
> papers, articles, web sites, books would be greatly appreciated.
> TIA...|||TechNet and MSDN have articles on the subject:
SQL Server 2000 Administrator's Pocket Consultant: Importing and Exporting
Data with DTS and BCP
http://www.microsoft.com/technet/pr...s/c07ppcsq.mspx
Of course, you can find a slew of books on the technical aspects of using
SQL Server DTS specifically. However, if you are wanting to learn more about
best practices and ETL in general, then go to Barnes&Noble or Borders this
wend and browse through these.
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting,
Cleaning, Conforming, and Delivering Data
by Ralph Kimball, Joe Caserta
Building the Data Warehouse
by W. H. Inmon
"sqlster" <nospam@.nospam.com> wrote in message
news:FF107389-91B8-4397-ABA2-903C89EEAB30@.microsoft.com...
> Could any one please recommend some good books on sql server 2000 ETL best
> practices '
> I am trying to learn some best practices regarding this subject so any
> white
> papers, articles, web sites, books would be greatly appreciated.
> TIA...

Book Recommendations Needed

I am looking for a book that discusses query tuning, index tuning, execution
plans, etc. Can anyone recommend something?

--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com"BenignVanilla" <bv@.tibetanbeefgarden.com> wrote in message
news:-Pqdna74lMVGzVKiRVn-tw@.giganews.com...
> I am looking for a book that discusses query tuning, index tuning,
execution
> plans, etc. Can anyone recommend something?

Inside SQL Server 2000 by Kalen Delany

>
> --
> BV.
> WebPorgmaster - www.IHeartMyPond.com
> Work at Home, Save the Environment - www.amothersdream.com

Book recommendations for an all encompassing SQL Server 2005 Reporting Services

Out of all the books for SQL 2000 Reporting Services, I found Peter
Blackburns book most helpful. Since he is not writing a Sql 2005 Reporting
Services equivalent, can any make any recommendations for an RS 2005 book?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1yes. i have the same question.
What books are recommended for SQL 2005 Reporting Services? (Last time
I checked most of the books seem to be in print)
Paul M via SQLMonster.com wrote:
> Out of all the books for SQL 2000 Reporting Services, I found Peter
> Blackburns book most helpful. Since he is not writing a Sql 2005 Reporting
> Services equivalent, can any make any recommendations for an RS 2005 book?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1

Book Recommendations

Hello -
My background is networking and system administration. I know basic
programming constructs, and have done .bat, VBA, and *nix shell
scripting/programming. I am looking for, at most, two books that can
help me in my new role as DBA. Most of my SQL work will be bringing
in data that our database application's GUI can't deal with. An
example is to do Inserts Where IDs are In a list.
What recommendations do you have on books that will serve my purpose?
Thanks
-tomThe Guru's guide to Transact by SQL Ken Henderson
Inside SQL server 2000 by Kalen Delaney
http://sqlservercode.blogspot.com/
"tom" wrote:

> Hello -
> My background is networking and system administration. I know basic
> programming constructs, and have done .bat, VBA, and *nix shell
> scripting/programming. I am looking for, at most, two books that can
> help me in my new role as DBA. Most of my SQL work will be bringing
> in data that our database application's GUI can't deal with. An
> example is to do Inserts Where IDs are In a list.
> What recommendations do you have on books that will serve my purpose?
> Thanks
> -tom
>|||"The Guru's guide to Transact by SQL Ken Henderson" is a great book for SQL
programmers.
I would also recommend "Sams teach yourself MS SQL Server in 21 days" for
more dba related issues.
Archer
"SQL" wrote:
> The Guru's guide to Transact by SQL Ken Henderson
> Inside SQL server 2000 by Kalen Delaney
>
> http://sqlservercode.blogspot.com/
>
> "tom" wrote:
>|||Tom,
1. Inside SQL server 2000 by Kalen Delaney -- by far the most indepth and
the best
2. Microsoft SQL Server 2000 Unleashed by Ray Rankins
or
Microsoft SQL Server 2000 Bible by Paul Nielsen
Optional 3rd - for T-SQL programming:
3. Professional SQL Server 2000 Programming by Robert Vieira
HTH
Jerry
"tom" <tomfeldsten@.hotmail.com> wrote in message
news:1127404813.829779.198790@.z14g2000cwz.googlegroups.com...
> Hello -
> My background is networking and system administration. I know basic
> programming constructs, and have done .bat, VBA, and *nix shell
> scripting/programming. I am looking for, at most, two books that can
> help me in my new role as DBA. Most of my SQL work will be bringing
> in data that our database application's GUI can't deal with. An
> example is to do Inserts Where IDs are In a list.
> What recommendations do you have on books that will serve my purpose?
> Thanks
> -tom
>|||Get a book on RDBMS basics. SQL is a declarative, high level language
which is nothing like you have seen or used before. Once you have
foundations, then get some of my books. SQL FOR SMARTIES is a classic,
but you might want to start with SQL PROGRAMMING STYLE or DATA &
DATABASES.
.|||Tom,
SQL for Smarties is a fine book. I do not have a copy of the others but I'm
sure they are good as well.
Nice job by the way Joe.
Jerry
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1127415608.320083.296190@.g43g2000cwa.googlegroups.com...
> Get a book on RDBMS basics. SQL is a declarative, high level language
> which is nothing like you have seen or used before. Once you have
> foundations, then get some of my books. SQL FOR SMARTIES is a classic,
> but you might want to start with SQL PROGRAMMING STYLE or DATA &
> DATABASES.
> .
>|||>The Guru's guide to Transact by SQL Ken Henderson
in fact, all the books by Ken Henderson|||Joe Celko highly recommends The Guru's Guide to Transact SQL by Ken Henderso
n.
I have read SQL for Smarties and it's good, I really enjoyed SQL Puzzles and
Answers.
Joe do you intend to write an updated puzzle book any time soon?
If so let us know.
http://sqlservercode.blogspot.com/
"Jerry Spivey" wrote:

> Tom,
> SQL for Smarties is a fine book. I do not have a copy of the others but I
'm
> sure they are good as well.
> Nice job by the way Joe.
> Jerry
> "--CELKO--" <jcelko212@.earthlink.net> wrote in message
> news:1127415608.320083.296190@.g43g2000cwa.googlegroups.com...
>
>|||> but you might want to start with SQL PROGRAMMING STYLE
well I have ped insed, thanks to Amazon, and I'm a little bit
surprised
the recommendation to use stored procedures (p. 122) and not to use
functions (p. 123). is it really consistent?
you list "portabilty problems" as reason to avoid UDFs, but for
- T-SQL (MS SQL Server)
- PL/SQL (Oracle)
- SQL-PL (DB2)
SQL UDFs are just as portatble, or not portable, as stored procedures
I don't see any major difference in portability between stored
prodeures and UDFs. Could you please explain?|||also the statement on the same that udfs are not inline seems to be not
true, sometimes they are (MS SQL Server):
create table states(state char(2))
insert into states values('IL')
insert into states values('MI')
insert into states values('WI')
create table stateNames(state char(2), sname varchar(20))
insert into stateNames values('IL', 'Illinois')
insert into stateNames values('MI', 'Michigan')
insert into stateNames values('WI', 'Wisconsin')
CREATE FUNCTION getAllStateNames()
RETURNS TABLE
AS
RETURN ( select sname from stateNames )
now look at the execution plan of this statement:
select * from states,getAllStateNames()
obviously the UDF's body is compiled into it. the plan clearly
describes access to stateNames
AFAIK in Oracle the plan would not display what is accessed inside the
UDF, but Oracle is very different

Book Recommendations

Hi,
am after a book or two on TSQL and Stored Procedures, any
recommendations would be much appreciated.
CheersThe Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/t...=glance&s=books
Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Unleashed (2nd Edition)
by Ray Rankins, Paul Jensen, Paul Bertucci
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Bible
by Paul Nielsen
http://www.amazon.com/exec/obidos/t...=gla
nce
For absolute beginners, also consider:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/t...e.blogspot.com/|||Many thanks,
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1135176704.126957.11030@.o13g2000cwo.googlegroups.com...
> The Guru's Guide to Transact-SQL
> by Ken Henderson
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Professional SQL Server 2000 Programming
> by Robert Vieira
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Inside Microsoft SQL Server 2000
> by Kalen Delaney
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Microsoft SQL Server 2000 Unleashed (2nd Edition)
> by Ray Rankins, Paul Jensen, Paul Bertucci
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Microsoft SQL Server 2000 Bible
> by Paul Nielsen
> http://www.amazon.com/exec/obidos/t...=g
lance
> For absolute beginners, also consider:
> Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
> by Richard Waymire
> http://www.amazon.com/exec/obidos/t...e.blogspot.com/
>sql

Book recommendations

Hello...
My company is going to be writing some rather extensive reporting for our
software. I've got a fair ammount of experience with reporting services,
however I am looking for some book recommendations as there doesnt appear to
be a huge ammount of documentation online.
Anyone have recommendations for a book that will cover up to a fairly
advanced level of reporting services usage. (including permissions, custom
assemblies, tips and tricks, etc?
Thanks in advance
Weston WeemsI've had several books on RS, but the CodeFez Guide to Reporting Services is
the one I keep turning to. I got mine at a conference, but they're for sale
from www.codefez.com.
--
Floyd
"Weston Weems" <wweems@.NOSPAMno-span-gmail.com> wrote in message
news:%23A26WFDqFHA.3680@.TK2MSFTNGP15.phx.gbl...
> Hello...
> My company is going to be writing some rather extensive reporting for our
> software. I've got a fair ammount of experience with reporting services,
> however I am looking for some book recommendations as there doesnt appear
> to be a huge ammount of documentation online.
> Anyone have recommendations for a book that will cover up to a fairly
> advanced level of reporting services usage. (including permissions, custom
> assemblies, tips and tricks, etc?
> Thanks in advance
> Weston Weems
>|||HitchHikers Guide to SQL Server 2000 Reporting Services is a good
reference.
Teo Lachevs Microsoft Reporting Services in Action has some good stuff
in it too.
Chris
Floyd Burger wrote:
> I've had several books on RS, but the CodeFez Guide to Reporting
> Services is the one I keep turning to. I got mine at a conference,
> but they're for sale from www.codefez.com.

Book Recommendation for SRS2005 Designing Reports

Hi,
Does anyone have any book recommendations for designing Reports? I am
looking for a book that covers the basics but also moves onto more
advanced examples.
Thanks.I just picked up "Microsoft SQL Server 2005 Reporting Services 2005" by
Brian Larson (McGraw Hill). The ISBN is 0-07-226239-7. It was highly rated
on Amazon and it's turned out to be excellent.
"Gareth King" <QBVBKADUOIUJ@.spammotel.com> wrote in message
news:WtFKf.111376$AL5.53955@.fe01.news.easynews.com...
> Hi,
> Does anyone have any book recommendations for designing Reports? I am
> looking for a book that covers the basics but also moves onto more
> advanced examples.
> Thanks.

book on sql server to pass mcse exams

I would like to get recommendations for any book that will help me in
passing the SQL Server 2000 portion of MCSE. I would also like find a
reference book for writing queries in SQL Server 2000.
Daniel BrowerHi,
I don't know any books for passing the MCP tests. But I
went to some Microsoft courses, used Tranceders tests and
built a MS 2000 Network at home. Maybe it's overkill, but
I like to to see and use functions in reality...
Best reference so far that I know is MS SQL BOL..
or the Unlished books from SAMS publishing..
Good luck
//Ralph
>--Original Message--
>I would like to get recommendations for any book that
will help me in
>passing the SQL Server 2000 portion of MCSE. I would
also like find a
>reference book for writing queries in SQL Server 2000.
>Daniel Brower
>
>.
>