What reference book should every DBA/Dev have?

Question

question

iamgoat asked Oct 22, '09

What reference book should every DBA/Dev have?

Can be a focused topic like tuning or cover all levels of SQL experience.

t-sql sql-server subjective documentation

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2009-10-22T03:55:52Z

Rob Farley answered Oct 22, '09

SQL Server 2008 Internals by Kalen Delaney

My review is at: http://msmvps.com/blogs/robfarley/archive/2009/06/13/a-review-sql-server-2008-internals.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2009-10-22T03:59:53Z

Rob Farley answered Oct 22, '09

SQL Server MVP Deep Dives. All the money goes to charity.

http://sqlservermvpdeepdives.com

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor ♦♦ commented · Jun 30, 2010 at 10:06 AM

This is a good book as a worth cause, but I have found the quality, and depth, of the articles to vary widely.

0 ·

Answer 3 · 2009-10-22T04:04:21Z

Rob Farley answered Oct 22, '09

Books on design by Louis Davidson are great.

http://www.amazon.com/Louis-Davidson/e/B001K80LFK

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2009-10-22T04:09:06Z

Rob Farley answered Oct 22, '09

You can't go past the late, great Ken Henderson

http://www.amazon.com/Ken-Henderson/e/B001IOFJL2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 5 · 2009-10-22T05:20:40Z

sp_lock answered Oct 22, '09

This book looks at how to do varios tasks and what the Best Prac's are

http://www.amazon.com/gp/product/193398872X?ie=UTF8&tag=sql08-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=193398872X

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 6 · 2009-10-22T08:07:34Z

Grant Fritchey answered Oct 22, '09

Inside T-SQL Querying by Itzik Ben Gan

http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server%C2%AE-2008/dp/0735626030/ref=sr_1_1?ie=UTF8&s=books&qid=1256209628&sr=8-1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 7 · 2009-10-22T08:09:30Z

Grant Fritchey answered Oct 22, '09

Microsoft SQL Server 2008 Management and Administration by Ross Mistry

http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X/ref=sr_1_1?ie=UTF8&s=books&qid=1256209715&sr=8-1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 8 · 2009-10-22T09:43:39Z

Jay Bonk answered Oct 22, '09

In addition to those already mentioned, I'd like to ad:

SQL Server 2008 Query Performance Tuning Distilled - Grant Fritchey

http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1256214893&sr=1-3

Microsoft SQL Server 2008 Integration Services Unleashed - Kirk Haselden

http://www.amazon.com/Microsoft-Server-Integration-Services-Unleashed/dp/0672330326/ref=ntt_at_ep_dpi_1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 9 · 2009-10-22T09:48:07Z

Kev Riley answered Oct 22, '09

William Stanek's Pocket Consultant books (you may need to get bigger pockets though...)

Amazon US
Amazon UK

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 10 · 2009-10-22T22:02:05Z

Mansour Shoari answered Oct 22, '09

MS SQL Server 2005 Administratores Poket Consultant William R. Stanek ISBN-13: 978-0-7356-2107-7

MS SQL Server 2008 Administratores Poket Consultant William R. Stanek ISBN-13: 978-0-7356-2589-1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question