Contents tagged with DBA

  • Getting the read/write ratio for a database

    EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below by adding extra columns to give the data more context and general advice when interpreting this type of data.

    Just a quick post this time. Recently I needed to find out the read/write ratio for some of our customer databases as part of a bigger project of understanding the workload and performance of the databases. The project actually through up a few surprises, where databases that I …

  • Microsoft SQL Server 2008 Implementation And Maintenance (Exam 70-432)

      DBA, Certification, Book

    Publisher: Microsoft Press

    Format: Hardback

    I find it hard to review Microsoft Press books as they are nearly always the same. At least you can't fault them for consistency!

    So, again, another typical exam book that gives you a broad brush across all of the objective areas with the odd error/typo thrown in for good measure. It is good if you are starting off and want to learn a number of new things fast, but you are often reaching for BOL to get that extra bit of information that the book seems to miss out on.

    Average book that covers …

  • SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond

      DBA, Certification, Book

    Publisher: Sybex

    Format: Kindle

    I purchased this book to help me through my MCITP but I wasn't entirely happy with it. This book appeals to you as it claims to cover both required exams of the MCITP DBA certification and that was the main selling point to me. However, it does skim through quite a number of areas very quickly, leaving you to go elsewhere to learn that aspect of the technology. There were also a small number of errors in the book, but on the whole it is a good read for what it is.

    If you are planning on taking …