Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Troubleshooting SQL Server - A Guide for the Accidental DBA

Buy
I've spent much of the last six years of my working life trying to help people solve SQL Server-related performance problems, either hands-on, at client sites in my capacity as a consultant, or on various online community forums, answering people's questions.

Over that time I've been exposed to a few weird and wonderful SQL Server issues but, mainly, have seen the same problems, and the same confusions, crop up time and again. It was only a matter of time before I leapt to the foolhardy conclusion that I ought to write a book to explain what the most common problems were, why they occurred, and to offer sensible, practical solutions, aimed squarely at removing the root cause of the issue, rather than simply "papering over the cracks."

It turned out to be a much more daunting task than I imagined, for a number of reasons. Firstly, this is, by its very nature, a fairly broad-ranging book, covering topics stretching from CPU issues, to memory management, to missing indexes, and full transaction logs. Secondly, it is amazing how complex some of the simplest topics become when you try to put them down in text. Thirdly, technology changes rapidly, and the troubleshooter, and the advice he or she offers, must adapt accordingly. There were several cases in the writing of this book, where either a technology change meant I had to go back and adapt my original advice, or where my own opinion of the content and troubleshooting methodologies had evolved to the point where certain sections had to be completely rewritten.

Despite the occasionally bumpy road, what I hope I've achieved is a book that covers clearly and concisely the most common problems associated with the currently supported versions of SQL Server, namely SQL Server 2005, 2008, and 2008 R2. The first chapter explains my basic approach to performance troubleshooting, and the tools I use. It stresses, in particular, how rare it is that a problem can be diagnosed by looking at just a single data point.
(HTML tags aren't allowed.)

SSH, the Secure Shell: The Definitive Guide
SSH, the Secure Shell: The Definitive Guide
Are you serious about network security? Then check out SSH, the Secure Shell, which provides key-based authentication and transparent encryption for your network connections. It's reliable, robust, and reasonably easy to use, and both free and commercial implementations are widely available for most operating systems. While it doesn't solve every...
Working with Microsoft Dynamics CRM 2011
Working with Microsoft Dynamics CRM 2011

We love Microsoft Dynamics CRM 2011, and we hope that by the time you finish reading this book, you will love Microsoft Dynamics CRM, too. We understand that you might be skeptical about the possibility of falling for a piece of software, but we want you to know right up front that our goal is to show you all of the wonderful and...

Core Java, Vol. 2: Advanced Features, 8th Edition
Core Java, Vol. 2: Advanced Features, 8th Edition
The book you have in your hands is the second volume of the eighth edition of Core Java™, fully updated for Java SE 6. The first volume covers the essential features of the language; this volume covers the advanced topics that a programmer will need to know for professional software development. Thus, as with...

Effective Succession Planning: Ensuring Leadership Continuity and Building Talent from Within
Effective Succession Planning: Ensuring Leadership Continuity and Building Talent from Within

Organizations that don't take steps to plan for future talent needs at all levels, will face certain disruptions, and even disasters, when key employees leave. Still the most comprehensive and authoritative book on the subject, this new edition of Effective Succession Planning presents strategies for creating a complete, systematic...

Text Atlas of Podiatric Dermatology
Text Atlas of Podiatric Dermatology
For many years there has been a very positive link between podiatry and clinical dermatology, but unfortunately they largely remain apart in most medical cultures, both in training and in practice. Where they have begun to overlap in the clinical treatment of foot dermatological problems the benefits rapidly become obvious to those...
Acquired Long QT Syndrome
Acquired Long QT Syndrome

In recent years there has been considerable interest in the diagnosis and understanding of ventricular repolarisation, particularly the QT interval prolongation and abnormal T and T/U wave morphology associated with torsades de pointes. Advances in ion channel cloning have greatly improved our understanding of the role of ionic channels in...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy