Quick Look: Run SQL Server at its Peak

Developers and administrators alike need this book.


Out of the box, SQL Server is a pretty fast product. But over time and with heavy use, it can slow down. Without regular maintenance and upkeep, querying SQL Server may be a great deal like watching paint dry: a slow and boring process. We all know what users do when something is slow and boring; they make less than amiable phone calls to the administrators and developers in an attempt to get faster access to their data. This book is designed to help you prevent those calls before they come pouring in.

Between these covers lies a great deal of technical information that you can use to accelerate your server's performance and keep it that way. There is something in here for everyone that uses SQL Server: how to measure hardware performance, what type of RAID to use (and how it works), how to index properly, how to write faster queries, and more. The only minor (very minor) drawback is that there is some light content tucked away in the book, such as chapter 5, which is all about some new features in SQL Server 2000. That aside, this book is fantastic. Whatever your role may be with SQL Server, you need this book.

About the Author

Joseph L. Jorden, MCSE, MCT, CCNA, CCDA is Chief Technical Officer for Dugger & Associates (www.Dugger-IT.com). He was one of the first 100 people to achieve the MCSE+I and one of the first 2,000 to become an MCSE under Windows 2000. Joseph frequently contributes to books from Sybex and various periodicals.

Featured

  • Microsoft Appoints Althoff as New CEO for Commercial Business

    Microsoft CEO and chairman Satya Nadella on Wednesday announced the promotion of Judson Althoff to CEO of the company's commercial business, presenting the move as a response to the dramatic industrywide shifts caused by AI.

  • Broadcom Revamps VMware Partner Program Again

    Broadcom recently announced a significant update regarding its VMware Cloud Service Provider (VCSP) program, coinciding with the release of VMware Cloud Foundation (VCF) 9.0, a key component in Broadcom’s private cloud strategy.

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.