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.)

Microsoft Excel 2013 Plain & Simple
Microsoft Excel 2013 Plain & Simple

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.

...

Sams Teach Yourself iTunes 10 in 10 Minutes (Sams Teach Yourself -- Minutes)
Sams Teach Yourself iTunes 10 in 10 Minutes (Sams Teach Yourself -- Minutes)

A clear, super quick, easy-to-understand guide to the brand-new iTunes 10 

Fast access to instructions for every common task, plus reliable, concise answers to the most widely asked questions

Organized into lessons that distill the most crucial information on each iTunes topic - fully up to date...

Beginning XSLT and XPath: Transforming XML Documents and Data (Wrox Programmer to Programmer)
Beginning XSLT and XPath: Transforming XML Documents and Data (Wrox Programmer to Programmer)
Provides the basic education in the XSLT processing model that developers have requested

The growth of XML content management applications is boosting the demand for XSLT and XPath skills. This beginning Wrox book provides a firm foundation in the XSLT processing model, giving developers an important skillset.

...


Burp Suite Cookbook: Practical recipes to help you master web penetration testing with Burp Suite
Burp Suite Cookbook: Practical recipes to help you master web penetration testing with Burp Suite

Get hands-on experience of using Burp Suite to execute attacks and perform web assessments

Key Features

  • Use tools in Burp Suite to meet your web infrastructure security demands
  • Configure Burp to fine-tune the suite of tools specific to the target
  • Use Burp...
Advances in Lithium-Ion Batteries
Advances in Lithium-Ion Batteries

In the decade since the introduction of the first commercial lithium-ion battery research and development on virtually every aspect of the chemistry and engineering of these systems has proceeded at unprecedented levels. This book is a snapshot of the state-of-the-art and where the work is going in the near future. The book is intended not...

MariaDB Crash Course
MariaDB Crash Course

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines,...

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