About the Book

Senior DBAs have to know more than just SQL Server - they have to know storage, memory, operating systems, and more. This book gathers everything you need to know in one place, and each chapter is written by a SQL Server expert with extensive experience.

You'll learn about topics like latching, locking, memory architecture, extended events, and more.

New review by @PinalDave!

MVP and noted blogger Pinal Dave posted a review of Professional SQL Server 2008 Internals and Troubleshooting, and we’re absolutely honored by what he had to say.  He starts by saying:

“Having a book on internal and associating that with real life is “almost” an impossible task. The reason for using the [...]

Great Book Reviews of Professional SQL Server 2008 Internals and Troubleshooting

Over at Amazon UK, the European readers are starting to chime in with great reviews:

Jorge Segarra with Professional SQL Server 2008 Internals and Troubleshooting

Mark Anderson writes:

“The guys on this book really do know their stuff and they have managed to make the book interesting, engaging and above all… [...]

Book Now Available as a DRM-Free PDF!

Want to buy a DRM-free version of Professional SQL Server 2008 Internals and Troubleshooting in PDF format?

The good news is that you can buy the PDF version now from Wiley!

The bad news is that it costs $59.99, although if you use the discount code NODRM during checkout, you’ll get 20% off, bringing [...]

Up to #2 in Amazon Bestsellers!

In the Relational Databases category at Amazon, we’ve moved up to #2 – just behind Ben Forta’s “Teach Yourself SQL in 10 Minutes.”  While we can’t claim to teach you that quickly, we’re glad that people are still buying the book anyway.

On the Amazon Bestsellers List!

Amazon’s sales rankings change hourly, [...]

Featured in the PASS Connector Newsletter

Would you look at that!

Featured Book in the PASS Connector

The nice folks at the Professional Association for SQL Server (PASS) featured our book in the monthly PASS Connector email newsletter sent out to all their members.  If you’d like to stay up to date on SQL Server news, you can join [...]

Ugliest Job Description Contest

We got an email this morning from a company that wanted a DBA with experience managing >200TB databases.  The salary started at $60,000.  That provoked a series of laughs on Twitter, and it got us thinking – what would be the worst SQL Server job description out there?

Dig back into your past, and [...]

Interview with Author James Rowland-Jones

We sat down with James Rowland-Jones to learn a little more about him and why he took on the project.

Tell me a little bit about yourself – what’s a typical day like for you?

JRJ. I like to start the day with a hot shower. I do like baths too (I am British [...]

Book Shipments Arriving Now!

Professional SQL Server 2008 Internals and Troubleshooting

Great news – the book is shipping out to database administrators everywhere! We’ve heard from DBAs in America and Europe that they’ve received their copies, and bloggers have been sent copies for review as well.

Borders Books has started stocking the book in local bookstores. You [...]

SQL Server 2008 Internals and Troubleshooting Now Available on Amazon!

The book is now in-stock at Amazon, and the initial reviews are in!  So far, we’ve got two five-star reviews!

Granted, the reviews are from Brent’s sister and a friend, and both of them are more funny than accurate.  If you like funny Amazon reviews, check out the reviews for Tuscan Milk.  Clearly, some [...]

Download Chapter 1 Free!

You can download Chapter 1 of Professional SQL Server 2008 Internals and Troubleshooting now for free!  Go to Wiley’s web page for the book, and click on Read Excerpt 1.

Chapter 1 covers SQL Server Architecture, and addresses:

Understanding database transactions and the ACID properties Architectural components used to fulfill a read request Architectural [...]