Thank this author by sharing:
By Andy Warren,
I've been doing a lot of reading over the past few months trying to get my
SQL 2005 skills in shape and thought I'd share a few things about the books as
well as things I learned from them. I know book reviews aren't the most exciting
reading, so I'm going to combine a few in hopes of holding your interest. The
things listed aren't the only things I learned by far, but are just things I
tagged when I had an aha moment. Maybe if you find this format useful you'll let
me know so I can do another set, or even better, maybe you can write up some of
your own and send in.
This is the essentially the third edition,
following the editions dedicated to SQL 7 & SQL 2000. For SQL 2005 the book has
been split into four parts, covering the storage engine, query optimization,
TSQL programming, and TSQL querying. There's no doubt that SQL 2005 is a
significant release and has a lot of new features, but I kind of miss having one
book (for ease of use and buying one book instead of four). But as far as the
content goes, first class information as always. It contains a lot of low level
information (byte level schemes for pages for example) that will be of most use
to the very advanced DBA, but great reading for someone on the road to advancing
Some things I learned:
Paid for this one myself and it will stay on the shelf, but it's not the
first book I'd recommend you buy if you're a beginner to intermediate user.
Professional SQL Server 2005 Integration Services by Brian Knight & many others,
$35 at Amazon
Disclosure: Brian is my long time business partner, so I'm not an unbiased
reviewer, but I hope you'll still find my comments interesting.
This is a hard book to read cover to cover. Not because it's poorly written,
but rather it has a lot of detail and covers a wide range of subjects, ranging
from converting DTS packages to SSIS all the way through building custom tasks
for SSIS. I find it to be a good reference book and it's where I start when I
try something new in SSIS.
Things I learned:
Yep, paid for this one too and it also stays on the shelf. As a
beginner/intermediate user I find it to be a good reference, seems like it
addresses some more advanced scenarios that would be helpful to a real power
SQL Server Query Performance Tuning Distilled by Sajal Dam, $35 at Amazon
This book covers SQL 2000 and was published in 2004, somehow I missed it then
and only got around to looking at a copy late last year. I found the book to be
very approachable and my only complaint was that it didn't pay enough attention
(in my opinion of course) to data partitioning strategies. It's got very good
coverage of query tuning and index design.
I like the book and find it useful, so much so that we're now providing all
the students that attend our performance tuning class with a copy. I hope the
author publishes a new version for SQL 2005.
Example SCD type 2
Moving data from the stage to the main table
The second part of a great data warehousing series from Vincent Rainardi looks at the decision to st...
Staging table population
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent,...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.