Two years ago 59 SQL Server MVP's came together and helped make one of the best book on SQL Server out there. Each chapter was written by an MVP about a part of SQL Server they loved working with. This resulted in superb quality content and excellent ratings from the readers. To top it off all earnings went to a good cause, the War Child International organization. That book was SQL Server MVP Deep Dives.
This year 63 SQL Server MVPs, me included, decided it was time do repeat the success of the first book.
Let me introduce you the:
After about 6 months of work, the new book I've coauthored with Grant Fritchey (Blog|Twitter), Phil Factor (Blog|Twitter) and Alex Kuznetsov (Blog|Twitter) is out. They're all smart folks I talk to online and this book is packed with good ideas backed by years of experience. The book contains a good deal of information about things you need to think of when doing any kind of multi person database development. Although it's meant for SQL Server, the principles can be applied to any database platform out there. In the book you will find information on: writing readable code, documenting...
This book authored by Kalen Delaney whose Inside SQL Server books are compulsory reading for every DBA
hits the nail on the head with this one too.
The book goes into hardcore details of how the storage engine itself works.
Let's review what is covered in each chapter:
Chapter 1: Installing and Upgrading to SQL Server 2005
An overview of things to consider when migrating/upgrading to SQL Server 2005
Chapter 2: SQL Server 2005 Architecture
Hardcore stuff begins. talks about components of the engine and it's memory management.
Chapter 3: SQL Server 2005 Configuration
Covers Configuration Manager and general System Configuration
Chapter 4: Databases and Database Files
Covers pretty much...
This book is a sequel to T-SQL Querying. And it stands completly side by side it.
I can only recommend that you get it. The amount of new stuff to learn is amazing.
So lets see what each chapter covers:
Chapter 1: DataType Related problems, XML and CLR UDTs
Talks about DateTime problems, patterns matching , conversions, large objects, CLR and of course XML which is the biggest part of the chapter.
Chapter 2: Temporary tables and Table variables
A great explanation of how, why and what in the world of Temp.
Chapter 3: Cursors
Shows that although dreaded by many, they have their rightfull...
This is an AWSOME book!
Written by Itzik Ben-Gan and coauthored by Lubor Kolar and Dejan Sarka it's definitly worth it's money.
It starts with the chapter on logical query processing in which it explaines the basics of the full select statement and the order of processing it.
Just basic stuff.
Chapter 2 covers the phyisical query processing. Explaines what parsing, algebratization and executions plans are and how it's all tied together.
Chapter 3 covers the query tuning methodology and tools to use for it. In my opinion This chapter is one of the best in the book.
Chapter 4 introduces us to subqueries, CTE's and Rank...
Well in my knowledge brush up for 70-431 Exam I used this book backed up by BOL.
If you have previous SQL Server experience this book and BOL is all you really need to pass the Exam.
If you're a newbie who is just getting it's feet wet then first get some experience and comfortability with SQL server first.
The book is a very easy read and although it has some errors they're not huge so i didn't need errata (fixed errors) for it.
It nicly summarizes the topics that you need to know about and the chapters are just long enough.
Content fits very nicly with...