• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

SQL Server MVP Deep Dives Volume 2 – My Review

December 13, 2011 by John Sansom 4 Comments

Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set high, how then would SQL Server MVP Deep Dives Volume 2 fair?

Finding time to keep up with awesome blog content can be tough. Let me make it easy for you! Join over 400 SQL Server Professionals who already enjoy my roundup of the very best SQL blog content each week, delivered direct to your Inbox or favourite RSS Reader.

Variety is The Spice of Life

For those new to the MVP Deep Dive titles, the books are a wonderful collection of individually themed chapters, each authored by a different Microsoft Most Valuable Professional (MVP) for SQL Server. The authors write on a specific theme of their own choosing, ensuring a delightfully diverse content range within the SQL Server subject space.

SQL Server MVP Deep Dives Volume 2 is split into 5 core parts:

  1. Architecture
  2. Database Administration
  3. Database Development
  4. Performance Tuning and Optimization
  5. Business Intelligence

As Data Professionals, we all know that the breadth of our subject domain is far too great for any one person to truly master. This book provides a unique perspective to learning about SQL Server by bringing together the chosen works of MVPs, who are each highly skilled in their own respective areas. The only rule set out was that it must not have been covered in the previous volume, so it’s all new content again this time!

With such a wealth of content on offer there really is something new and interesting to learn in this book for every Data Professional.

My Highlights

Regular readers of the blog will know that I’m a Database Administrator at heart and although I have dabbled in the dark arts of BI (on perhaps a few too many occasions for my liking), my preferred area of interest is with the former.

With such a rich variety of content to feast upon, here are just a few of the chapters that I particularly enjoyed:

  • Multi server management (Rodney Landrum) – An essential read for DBAs that work in large environments. Tips on how to make life easier, of course are always great to read!
  • Over Normalization ( Chris Shaw ) – This piqued my interest because I see it out in the field an awful lot and I’d often wondered how many data professionals actually take it into consideration.
  • Storage Design Considerations (Denny cherry) – The man needs no introduction and with such a wealth of enterprise scale experience, I’m always intrigued to read his work.
  • T-SQL Bad Habits to Kick – (Aaron Bertrand) – How many of these are you (sorry I mean your developers) guilty of?
  • Performance Tuning Tips for UDFS (Kevin Boles) – Again, something of a performance tuning essential is shared here as it’s something that I see on consulting engagements a lot.

My Verdict

Different authors obviously have different styles of writing and with 60 MVPs involved it’s certainly an eclectic mix. Jam packed full of SQL Server goodness and with something here to appeal to all tastes, I consider SQL Server MVP Deep Dives Volume 2 a must have title for Every DBAs Bookshelf.

Comment on Community

I honestly cannot express enough just how awesome our community is. You’ll often hear folks talking about it as a #sqlfamily because of the character, dynamic and phenomenal spirit found within. This book is another great example of what #sqlfamily is all about. Sixty sql community members coming together to share their knowledge and give back to the community by supporting the children of Operation Smile.

Those super nice folks over at Manning Publications generously sent me a copy of the book, that I may share my thoughts on it here with you. It only seemed fitting then to make a donation of my own to Operation Smile.

If you would like to find out more about Operation Smile or to make a donation please visit their website.

Filed Under: Reviews, SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy