Start reading Tribal SQL on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books even without a Kindle device-with the FREE Kindle app for smartphones and tablets.
Tribal SQL
 
 

Tribal SQL [Kindle Edition]

Tony Davis , Jen McCown , Kat Hicks
5.0 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: 19.99
Kindle Price: 6.28 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: 13.71 (69%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition 6.28  
Paperback 15.99  
Kid's and Teen books from £0.99 on Kindle
Browse our selection of top children's and teen title in our one week sale, with top titles from only £0.99.Browse the sale here


Product Description

Product Description

A database administrator's core responsibilities are constant. A DBA must maintain and enforce security mechanisms on the data, prepare effectively for disaster recovery, ensure the performance and availability of all the databases in their care. Tribal SQL is a reflection of how a DBA’s core and long-standing responsibilities sit alongside new thinking and fresh ideas about where the DBA role is going, and what it means to be a DBA in today’s businesses.

Product details

  • Format: Kindle Edition
  • File Size: 7761 KB
  • Print Length: 491 pages
  • Publisher: Red Gate Books (23 Sep 2013)
  • Sold by: Amazon Media EU S. r.l.
  • Language: English
  • ASIN: B00H3JP4R0
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #346,588 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
Format:Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review follow:

The book’s introduction says "This is a book for [SQL Server] DBAs, for things you think they really ought to know…", so how does it fare?

This book is a diverse collection of SQL Server related articles by 15 experienced, but previously unpublished authors. It stems from a collaboration between Midnight DBA, who hatched the idea to collect the tribal knowledge of its community of DBAs and Red Gate Publishing who teamed up with them to produce it. The topics covered range from compression and page-level data content, through to Agile Development and Project Management for DBAs.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 SQL Server Storage Internals 101
This chapter provides an introduction to the physical storage internals within SQL Server. The premise being you should be able to take advantage of this internals knowledge to delivery more optimal solutions.

The chapter starts with a look at rows, discussing the fixedvar format - a structure that details the layout of each record. Next, page layout is examined in terms of the header, body and record offset array. The content of the physical page is described using the DBCC PAGE command.

Heaps and indexes are discussed in relation to what they are, and how they change as their data changes. The problems of fragmentation and forwarded records are described. B-trees are discussed in detail. There’s some useful SQL code for obtaining the number of forwarded rows.

The author uses the information discussed to get a storage capacity estimate.
Read more ›
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Good book, covering lots of DBA areas 24 Nov 2013
Format:Paperback|Verified Purchase
I enjoyed reading this book, and would highly recommend it for others.

Tribal SQL has 15 chapters covering various topics relevant to DBA's. Each of the chapters has been written by a previously unpublished author, and all are based on their experiences. There are chapters covering most topics from Internals Data Compression, Performance tuning, Auditing and SQL Injection, through to less technical areas such as Reporting and Database Mail. Additionally, there are sections on personal skills which include Communication Skills, Project Management and an Introduction to Agile Database Development.

While some of the sections don't go into as much detail as you'd hope, this isn't the point of this book(from my understanding). It covers each of the areas well, leaves you interested for more, and most of the chapters include links to various sources for further reading.

It's also good to see the authors of this book donated their royalties to charity (Computers for Africa). Well done!

My only criticism is that I'd like to see an eBook/Kindle version of it so I can have it in the eBook library I have on my Tablet.
Comment | 
Was this review helpful to you?
Format:Paperback|Verified Purchase
I got this book only a couple of days ago. But I have to say its probably one of the more immediately useful books I've come across. I had to set up DBMail on a SQL Server, the chapter in the book is an excellent step by step guide. I was also have some trouble with a couple of ETL packages that seemed to be login related. Rather than firing up profiler as usual I used Extended Events to figure out that the logins were badly configured, once again the chapter was pitched just where it was needed, meaningful but not too wordy or too deep. I also found the chapter on security very concise. Helped me give a very approachable high level overview of SQL Server security to someone who asked. So 3 chapters have proved useful within a week. I'm sure the rest will be flicked through in due course.

My only criticism? It would be better if I could put an ebook version on my Kindle along with the rest of my ref library, a lot more portable than the dead tree version and this is exactly the kind of useful ref book that's useful to have on tap when you need to do something you don't do every day.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  4 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Professional, yet entertaining. 3 Nov 2013
By Kevin M. Fries - Published on Amazon.com
Format:Paperback|Verified Purchase
Great book, this looks like a keeper on my shelf. Topics not covered elsewhere that even if you don't plan to use them directly still provide a worthwhile read for many reasons. It's also going towards a good cause.
I've seen books with chapters written by various writers and they usually are great as this tends to keep the writers motivated to do their best job. That's the case here.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great Book and well written 24 Mar 2014
By Norm - Published on Amazon.com
Format:Paperback
I have found the book to be a very good read. The chapters are very well written and informative. I would very much recommend this book due to the fact that there is something to be learn or refresh your memory in every chapter. I am also very looking forward to Tribal SQL becoming a series but once again Redgate has delivered. Bravo...
1 of 1 people found the following review helpful
5.0 out of 5 stars A fresh look at a diverse range of SQL Server related topics 14 Feb 2014
By Mr. Ian W. Stirk - Published on Amazon.com
Format:Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review follow:

The book’s introduction says "This is a book for [SQL Server] DBAs, for things you think they really ought to know…", so how does it fare?

This book is a diverse collection of SQL Server related articles by 15 experienced, but previously unpublished authors. It stems from a collaboration between Midnight DBA, who hatched the idea to collect the tribal knowledge of its community of DBAs and Red Gate Publishing who teamed up with them to produce it. The topics covered range from compression and page-level data content, through to Agile Development and Project Management for DBAs.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 SQL Server Storage Internals 101
This chapter provides an introduction to the physical storage internals within SQL Server. The premise being you should be able to take advantage of this internals knowledge to delivery more optimal solutions.

The chapter starts with a look at rows, discussing the fixedvar format - a structure that details the layout of each record. Next, page layout is examined in terms of the header, body and record offset array. The content of the physical page is described using the DBCC PAGE command.

Heaps and indexes are discussed in relation to what they are, and how they change as their data changes. The problems of fragmentation and forwarded records are described. B-trees are discussed in detail. There’s some useful SQL code for obtaining the number of forwarded rows.

The author uses the information discussed to get a storage capacity estimate. I do wonder if the calculation is a little too complex, since this is an estimate, and various factors could invalidate it (e.g. varying row size and number of rows).

The chapter contains an error using the DBCC IND command, there is no closing quote mark around Person.Person i.e. DBCC IND (AdventureWorks2008R2, ‘Person.Person, 1). Additionally, in investigating sys.database_files, rows are selected WHERE type = 0, but does not say what ‘type = 0’ means (it means files of type ‘row’).

Overall the chapter provides a useful introduction into the content of the rows and pages of a database. Additionally, the overview of heaps and indexes is useful together with the problems that changing data cause.
.
.
.
Conclusion
This is certainly an interesting book, covering a wide range of topics. All the chapters are well written, most are easy to read, and fresh. Some of the topics are offbeat, which itself adds to the book’s interest. Most chapters contain links to additional and deeper information, and many chapters have practical step-by-step examples.
You can download the first chapter of the book here: http://downloads DOT red-gate DOT com/ebooks/SQL/sql-server-storage-internals-101.pdf

The book contains a few basic code and English errors, but nothing too distracting. Cross-referencing between chapters is limited - some chapters end with a conclusion, others with summary, and others with nothing; some consistency would have been helpful. The book’s font was a little large, a more typical font would have reduced the book’s size from 466 pages to around 300 pages, making it more manageable.

I love the concept behind this book, get 15 previously unpublished authors to write about topics they find interesting. They may be new authors, but they are certainly experienced in their field.

The book’s authors have donated their royalties to the charity www DOT computers4africa DOT org DOT uk/, which collects, data-wipes, and refurbishes redundant IT hardware, and sends it to African schools, colleges and selected community projects. So buying the book has the added bonus of helping less-fortunate people.

I enjoyed reading the diverse range of topics in this book, indeed I hope there is a periodic release of this book with new authors talking about subject areas they enjoy.

If you want a fresh look at a diverse range of SQL Server related topics I can certainly recommend this book.
1 of 1 people found the following review helpful
5.0 out of 5 stars Buy it now! Great read and great people. 3 Feb 2014
By Jordan Martz - Published on Amazon.com
Format:Paperback
After looking at the SQL Server forums like SQLServerpedia, BIDM, and SQLServerCentral, I remember many long nights of introspection on my code, my ideas, and my philosophies regarding Database development. The Tribal SQL book really felt like a long-standing conversation with my peers. If you’re looking to get a cumulative and expansive view of the SQL Server community and product, look no further. It’s a fun read for the seasoned vet that has seen it before, and the wholly cow moment for the ones that haven’t.

I’ve been with every database and data warehouse for too long to remember. This has really been a validation opportunity to share with my peers, as well as, something look back and share the journey. Buy this book,…..now or very soon.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


ARRAY(0x9de93408)