• subscribe
September 15, 2009 12:00 AM

New Book – T-SQL Programming

SQL Server Pro
InstantDoc ID #102806

A couple of weeks ago my latest book – Inside Microsoft SQL Server 2008: T-SQL Programming was sent to the printers and should be available on the shelves as of September 16, 2009. The contributors to this book besides me are: Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah and Isaac Kunen who authored chapters, Steve Kass who did the technical editing and far beyond, and Lubor Kollar who wrote the foreword. I’m grateful for having had the opportunity to work with this group of knowledgeable people—both at the professional and personal levels.

For those who haven’t read the 2005 edition of the book and are not familiar with it at all, this book is the second volume of a two-part series about advanced T-SQL. The first is Inside Microsoft SQL Server 2008: T-SQL Querying, and should be read first. T-SQL Querying focuses on querying and query tuning. T-SQL Programming focuses on programmatic constructs and assumes you have solid knowledge of querying and query tuning. You can find details about both books here.

Note that both T-SQL Querying and T-SQL Programming are advanced books and are not intended for beginners. If you just started learning T-SQL, I’d recommended starting with Microsoft SQL Server 2008: T-SQL Fundamentals.

Back to T-SQL Programming, if you’ve read the 2005 edition of the book, you will find plenty of new stuff in the 2008 edition. Naturally existing chapters were enhanced to cover the new features in SQL Server 2008, plus several completely new chapters were added (see companion website for details).

I can’t tell you what a relief it is to have this book done; this is the third and last of three books I wrote about SQL Server 2008, and I’ve been writing nonstop since January 1st, 2008 till now. Finally, I can start doing some reading. ;)

BTW, on the morning of January 6th 2008 I stopped smoking, so I think of these three books as “smoke free” books. :)

Cheers, and happy programming!

BG



ARTICLE TOOLS

Comments
  • qiang
    3 years ago
    Oct 30, 2009

    "smoke free" books? :)

  • Khalid
    3 years ago
    Oct 22, 2009

    Itzik,

    I have read propbably just over half of T-SQL Querying 2005. 2 days ago I used your example of pivoting rows to columns to solve a problem at work - not a very complex problem I know - but it saved me time and gave me insight. I found your 2005 book superb, and am looking forward to the 2008 edition. I especially enjoyed the puzzles - I think they were a great addition to the book - I hope the new book contains an expanded section - I think they are most relevant, as our work is all about problem solving.

    Big congrats on your giving up smoking. Thats a major achievement and hard to do. Well done.

    Best regards

    Khalid

  • saurabh
    3 years ago
    Oct 08, 2009

    Well Done on Quitting Smoking; I had myself quit smoking on 6th April 2007 and have been smoke free since :)

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...