Books on T-SQL

Hi Can anyone suggest me a good book on T-SQL for SQL Server 2005? I preferably need both a Hardcopy and a softcopy (any link which covers in depth T-SQL for YUKON will do). Same for Hardcopy also.

Thanks in Advance

Shaun

I haven't actually read it, but the O'Reilly books are generally very good, and they have released on one SQL 2005:

http://www.oreilly.com/catalog/progsqlsvr/

Also, Microsoft has some good books and courses online:

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

HTH|||

For me Books OL is enough for all T-SQL questions and syntax issues.

I was looking for some good book for 2k5 but not many books are out yet.

|||? I don't think any are out yet. Itzik Ben-Gan and a couple of others have two books coming out in a few months, from Microsoft Press (part of the "Inside SQL Server" series). You might have to make due with BOL until that one is released. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Shaun Michael@.discussions.microsoft.com> wrote in message news:3049dd63-4c3c-42a8-9e31-57ee97c32f4e@.discussions.microsoft.com... Hi Can anyone suggest me a good book on T-SQL for SQL Server 2005? I preferably need both a Hardcopy and a softcopy (any link which covers in depth T-SQL for YUKON will do). Same for Hardcopy also. Thanks in Advance Shaun|||I've seen some books out, including the one in the link above. Some were out in Novemeber, but not official ones.|||? I'm not sure what you mean by "official". The only official documentation is Books Online. I don't recommend the book in my signature because the coverage of T-SQL isn't all that deep -- we covered the new features only. Aside from the four books targetted at the beta editions (Beauchemin et al, Otey, DeBetta, and Scalability Experts), all of the other books currently on the market are targetted at RTM, as far as I'm aware. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Shughes@.discussions.microsoft.com> wrote in message news:879be8bc-3533-4242-a45d-fc56a35ec105@.discussions.microsoft.com...I've seen some books out, including the one in the link above. Some were out in Novemeber, but not official ones.

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 clustering

Can someone recommend a good book that covers SQL clustering? And maybe even
SQL Mirroring?
I'm going to install my first SQL Cluster and I want to be as prepared as
possible.
All your help is much appreciated. Thanks.
We offer training www.clusterhelp.com. Hop on a plane and join me in NYC
this Monday. I think we have one open seat
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:C61760E4-C690-4FB5-BDE7-D2E2163CC55A@.microsoft.com...
> Can someone recommend a good book that covers SQL clustering? And maybe
> even
> SQL Mirroring?
> I'm going to install my first SQL Cluster and I want to be as prepared as
> possible.
> All your help is much appreciated. Thanks.
|||The High Availability series is pretty good:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
Which has also been compiled into book form:
http://www.microsoft.com/MSPress/books/6515.aspx
SQL Server 2005 also has available reference material:
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
http://www.apress.com/book/bookDisplay.html?bID=10226
You should also read through the Failover Clustering documents:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Finally, your education would not be complete without understanding
Clustering at the OS level:
http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx
Best of luck.
Sincerely,
Anthony Thomas

"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:C61760E4-C690-4FB5-BDE7-D2E2163CC55A@.microsoft.com...
> Can someone recommend a good book that covers SQL clustering? And maybe
even
> SQL Mirroring?
> I'm going to install my first SQL Cluster and I want to be as prepared as
> possible.
> All your help is much appreciated. Thanks.
|||Hey, Rod!
My colleague, Syed, will be there on Monday. :-)
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:e$OdaokUHHA.5068@.TK2MSFTNGP03.phx.gbl...
We offer training www.clusterhelp.com. Hop on a plane and join me in NYC
this Monday. I think we have one open seat
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:C61760E4-C690-4FB5-BDE7-D2E2163CC55A@.microsoft.com...
> Can someone recommend a good book that covers SQL clustering? And maybe
> even
> SQL Mirroring?
> I'm going to install my first SQL Cluster and I want to be as prepared as
> possible.
> All your help is much appreciated. Thanks.
|||Back when I did my first cluster, I went through Microsoft's white paper
(find it on Microsoft's site) on High Availability and one on Clustering. It
got me through.
"Rodney R. Fournier [MVP]" wrote:

> We offer training www.clusterhelp.com. Hop on a plane and join me in NYC
> this Monday. I think we have one open seat
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
> news:C61760E4-C690-4FB5-BDE7-D2E2163CC55A@.microsoft.com...
>
>
|||Allan Hirt's Microsoft SQL Server 2000 High Availability is excellent for
high availability in general and pretty good on clustering. He is writing a
volume on SQL 2005 HA to be published soon by apress.
Clusterhelp.com's training courses are well received.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:C61760E4-C690-4FB5-BDE7-D2E2163CC55A@.microsoft.com...
> Can someone recommend a good book that covers SQL clustering? And maybe
> even
> SQL Mirroring?
> I'm going to install my first SQL Cluster and I want to be as prepared as
> possible.
> All your help is much appreciated. Thanks.
|||Thank you all very much for your responses. I'd love to hop on a plane to
NYC, but it's not in the 'Budget'
"Himanshu" wrote:

> Can someone recommend a good book that covers SQL clustering? And maybe even
> SQL Mirroring?
> I'm going to install my first SQL Cluster and I want to be as prepared as
> possible.
> All your help is much appreciated. Thanks.
|||"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:248AD1BE-B154-4954-9CFC-B95B00E480F6@.microsoft.com...
> Thank you all very much for your responses. I'd love to hop on a plane to
> NYC, but it's not in the 'Budget'
This is one business truth that always bugs me. How can a company invest so
much money in hardware and software for HA, but not spend a dime on properly
training the administrators?
Without properly trained administrators, it is impossible to achieve HA.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
NYC starting Feb 19th
London starting March 6th
|||After months of searching I'm glad nobody else has found a book I missed!
But why isnt there more literature on HA or failover clustering or better
still SQL2005 failover clustering?!! Hopefully Allan Hurt's SQL 2005 book
will fill the gap
"Russ Kaufmann [MVP]" <russ@.clusterhlep.com> wrote in message
news:AB61770C-7912-4F48-B4C1-6D32B37FE0A2@.microsoft.com...[vbcol=seagreen]
> "Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
> news:248AD1BE-B154-4954-9CFC-B95B00E480F6@.microsoft.com...
to
> This is one business truth that always bugs me. How can a company invest
so
> much money in hardware and software for HA, but not spend a dime on
properly
> training the administrators?
> Without properly trained administrators, it is impossible to achieve HA.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> NYC starting Feb 19th
> London starting March 6th
>
|||> This is one business truth that always bugs me. How can a company invest so
> much money in hardware and software for HA, but not spend a dime on properly
> training the administrators?
> Without properly trained administrators, it is impossible to achieve HA.
Very true Russ. It'll be a cold day in hell before my boss pays for training
and it's unfortunate that so many companies think training is something the
employee should do on their own time. The "you are paid to work, not study"
speech.
[There's probably an appropriate Dilbert cartoon somewhere.]
Well, everything I've learnt has been through books, online articles, and
on-the-job, but I'm realising that the technology is getting away from me due
to lack of proper intensive training. Lack of knowledge is not something
either myself or my company can afford.
Don't suppose you do training in Tokyo? :-)