- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
Already know your way around SQL Server? Why pay for information on creating new logins? Here’s what you do need: better security, performance, and scalability. Less downtime. Best practices for more efficient administration. That’s the focus of SQL Server 2000 for Experienced DBAs.
Take installation. Any fool can run a wizard. Brian Knight tells you what to do if something goes wrong. Once you’re running, Knight tells you which features to avoid (multiple instances) and which settings tend to crash servers (Boost SQL Server Priority on Windows). Next, you’ll learn how to lock down your SQL Server (it’s not just the notorious SA account you need to worry about).
Knight systematically shows how to improve your productivity as a DBA. He covers start-up stored procedures; the poorly documented SQL Mail; multiserver agents; DTS; baselining and monitoring; Query Analyzer; Administrative T-SQL; even OLE Automation (which has great DBA uses most nonprogrammers aren’t aware of). Is your network card misconfigured? Are there oddball registry conflicts? You’ll find out here. Have you tuned your database model? Knight offers ten specific tips.
The heart of the book is its coverage of enterprise environments. Knight starts with disaster recovery, then moves on to an in-depth discussion of scalability -- including coverage of linked servers, distributed partitioned views, and accessing more than 2G.
There’s thorough coverage of high availability using log shipping and clustering, as well as a full chapter on replication. There’s even an appendix full of undocumented DBCC commands. For experienced SQL Server DBAs, this book’s a gold mine. Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.