SQL Server Programming Books

30 Jun 2009 7:38 PM

Scott

Hi Folks,

I'm looking for 2 books, or perhaps 1 that covers off both TSQL and stored
procedures. I've got the Inside SQL Server series, and these are great for
performance tuning, etc. I'd like a book(s) that teaches you from "just above
the ground up", with plenty of examples. It doesn't need to be interactive. I
have a programming background.

Thanks in advance.

30 Jun 2009 8:52 PM

Russell Fields

Scott,

You might find http://www.sql.co.il/books/tsqlfund2008/ useful. This is
Itzik Ben-Gan's book entitled "Microsoft SQL Server 2008: T-SQL
Fundamentals". (Despite the title, the author says, "The book is not
version-specific.")

It starts from "just above the ground", although stored procedures are only
overviewed in Chapter 10, along with other "Programmable Objects".

To go more deeply into stored procedures, you might find Ken Henderson's
"The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" an
valuable book.
http://www.amazon.com/Gurus-Guide-Server-Stored-Procedures/dp/0201700468
A sample chapter is here:
http://www.informit.com/articles/article.aspx?p=25288

FWIW,
RLF

Show quoteHide quote

"Scott" <Sc***@discussions.microsoft.com> wrote in message
news:59CE6240-BFD1-4894-A358-79B72FEDA8FD@microsoft.com...
> Hi Folks,
>
> I'm looking for 2 books, or perhaps 1 that covers off both TSQL and stored
> procedures. I've got the Inside SQL Server series, and these are great for
> performance tuning, etc. I'd like a book(s) that teaches you from "just
> above
> the ground up", with plenty of examples. It doesn't need to be
> interactive. I
> have a programming background.
>
> Thanks in advance.

30 Jun 2009 9:42 PM

Scott

Thanks Russell, I'll look into them.

I was/am considering Ken Henderson's book. I'm not a developer perse, and
that book seems (from the table of contents) to be very much geared to the
DLC. My objective is to strengthen my fundamental SQL skills as well as
applying them to writing solid SP's - more for administrative purposes.

I've heard that Ken's TSQL book - "The Guru's Guide to Transact-SQL" is a
very good how-to book.

I just found out that Ken passed away in January 2008, perhaps I'll just buy
them both - good addition to the library I'm sure.

Scott

Show quoteHide quote

"Russell Fields" wrote:

> Scott,
>
> You might find http://www.sql.co.il/books/tsqlfund2008/ useful. This is
> Itzik Ben-Gan's book entitled "Microsoft SQL Server 2008: T-SQL
> Fundamentals". (Despite the title, the author says, "The book is not
> version-specific.")
>
> It starts from "just above the ground", although stored procedures are only
> overviewed in Chapter 10, along with other "Programmable Objects".
>
> To go more deeply into stored procedures, you might find Ken Henderson's
> "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" an
> valuable book.
> http://www.amazon.com/Gurus-Guide-Server-Stored-Procedures/dp/0201700468
> A sample chapter is here:
> http://www.informit.com/articles/article.aspx?p=25288
>
> FWIW,
> RLF
>
>
>
> "Scott" <Sc***@discussions.microsoft.com> wrote in message
> news:59CE6240-BFD1-4894-A358-79B72FEDA8FD@microsoft.com...
> > Hi Folks,
> >
> > I'm looking for 2 books, or perhaps 1 that covers off both TSQL and stored
> > procedures. I've got the Inside SQL Server series, and these are great for
> > performance tuning, etc. I'd like a book(s) that teaches you from "just
> > above
> > the ground up", with plenty of examples. It doesn't need to be
> > interactive. I
> > have a programming background.
> >
> > Thanks in advance.
>
>

1 Jul 2009 7:02 AM

Uri Dimant

Scott
I would suggest you to take a look at two Itzik's books
http://www.sql.co.il/books/insidetsql2005/

Show quoteHide quote

"Scott" <Sc***@discussions.microsoft.com> wrote in message
news:59CE6240-BFD1-4894-A358-79B72FEDA8FD@microsoft.com...
> Hi Folks,
>
> I'm looking for 2 books, or perhaps 1 that covers off both TSQL and stored
> procedures. I've got the Inside SQL Server series, and these are great for
> performance tuning, etc. I'd like a book(s) that teaches you from "just
> above
> the ground up", with plenty of examples. It doesn't need to be
> interactive. I
> have a programming background.
>
> Thanks in advance.