About the eBook

15 chapters from 15 new authors, brought to you by Redgate & MidnightDBA

Buy from Amazon.com
Buy from Amazon.co.uk

Sample chapter: SQL Server Storage Internals 101 (254kb PDF)

15 first-time authors answer the question: what makes you passionate about working with SQL Server?

MidnightDBA and Redgate partnered to produce a book filled with community – tribal – knowledge on SQL Server. The resulting book is a series of chapters on lessons learned, perhaps the hard way, which you won’t find in traditional training or technical guidance material.

As contributors to a truly community-driven book, the authors are all generously donating 100% of their royalties to the charity Computers 4 Africa.

A DBA’s core responsibilities are constant. A DBA must have the hard skills necessary to 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.

Side by side with these, our authors have also recognized the importance of communication skills to the business and their careers. We have chapters on the importance to a DBA of communicating clearly with their co-workers and business leaders, presenting data as useful information that the business can use to make decisions, and sound project management skills.

The resulting book, Tribal SQL, is a reflection of how a DBA’s core and long-standing responsibilities and what it means to be a DBA in today’s businesses.

Contents

1. Windows Functions in SQL Server 2012 – Dave Ballantyne
2. Using Database Mail to E-Mail enable your SQL Server – John Barnett
3. SQL Server Security 101 – Diana Dee
4. SQL Injection: How it Works and How to Thwart it – Kevin Feasel
5. Performance Tuning with SQL Trace and Extended Events – Tara Kizer
6. Taming Transactional Replication – Chuck Lathrope
7. Building Better Reports – Stephanie Locke
8. What changed? Auditing solutions in SQL Server – Colleen Morrow
9. Agile Database Development – Dev Nambi
10. SQL Server Data Compression – Bob Pusateri
11. SQL Server Storage Internals 101 – Mark S Rasmussen
12. Nine Habits to Secure a Stellar Performance Review – Wil Sisney
13. Verifying backups using statistical sampling – Shaun J Stuart
14. Guerrilla Project Management for DBAs – David Tate
15. Communication isn’t Soft – Matt Velic

Share