Any good webcasts for sql server 2005 reporting services {Developer perspective}

Can any body please point me to Any good webcasts for sql server 2005 reporting services {Developer perspective}

Also Please recommend me any good book for using and creating SSRS.

Thanks

Hello Kamii,

Here is a link to some of the webcasts on Microsoft's site, there is a section for Reporting Services.

http://www.microsoft.com/events/series/sqlserverbi.mspx

And here is a book on Reporting Services, it got pretty good reviews.

http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0072262397/ref=pd_bbs_sr_2/103-3827006-9073459?ie=UTF8&s=books&qid=1174049936&sr=8-2

Hope this helps.

Jarret

any good conferences or training coming up..

I would like to attend a good sql server training conference here in USA. What would you recommend? My areas of interest are:
OLTP, SSIS, SSAS, Data warehousing etc..

I googled for some excellent training or conference events but could not find one.

There are two big conference providers that I know of -

SQL Server User Group - PASS (http://www.sqlpass.org/)

SQL Server Magazine Connections (http://www.devconnections.com/shows/sql/default.asp?s=0)

There are no doubt loads of training providers out there, but it depends on what you want, public course, private on-site, MOC courses. Discalimer, I work with these people - Solid Quality Learning (http://www.sqlu.com/)

Rather than have lots of commercial links in the forums, as some people get very upset, I've started a Wiki page so feel free to add your favourite provider there as well, I've started with the top search hits-

Training Courses
(http://wiki.sqlis.com/default.aspx/SQLISWiki/TrainingCourses.html)

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 free reporting tool you recommend?

dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill....MS Access?
MS Excel?|||How about Reporting Services on SQL Server 2005

Regards
Kris Zywczyk|||yah, still trying out to set up the report server in SQL 2005, initial trial on the BI visio studio failed, dunno why.

Is the reporting services included in SQL 2005 express?|||What do you mean you want this for your users?

"are those rocks up ahead?"

"I don't know, but if they are, we all be dead"

OK, what movie.|||"No more rhymes now. I mean it!"

"Does anyone want a peanut?"|||"aaaaaaaaarrrrrrrrrrrrrgggggggggggggghhhhhhhhhh"

"What are you doing?"

"I think someone is following us"

"That would be inconcceivable"|||I personally love it when non-developers write production sql. I have project managers who do it for word merges. i have report writers who do not understand group by. It gives me plenty of things to fix and server slow downs to diagnose.|||"I'm not left-handed either."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."
Great !! :D