Title : | Professional SQL Server 2005 administration |
Material Type: | printed text |
Authors: | Brian Knight, Author ; Ketan Patel, Author |
Publisher: | Indianapolis, IN : Wiley Pub. Inc |
Publication Date: | 2007 |
Pagination: | xxvi, 735 p. |
Size: | 24 cm |
ISBN (or other code): | 978-0-470-05520-5 |
General note: | Includes index (p. [707]-735) |
Languages : | English (eng) Original Language : English (eng) |
Descriptors: | Database management SQL server
|
Class number: | 005.7585 |
Abstract: | SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. |
Contents note: | SQL Server 2005 Architecture; SQL Server 2005 Installation Best Practices; SQL Server 2005 Upgrade Best Practices; Managing and Troubleshooting the Database Engine; Automating SQL Server; Integration Services Administration and Performance Tuning; Analysis Services Administration and Performance Tuning; Administering SQL Server Development Features; Securing SQL Server; Change Management in SQL Server; Configuring the Server for Optimal Performance; Optimizing SQL Server; Monitoring SQL Server; Performance Tuning T-SQL; Indexing Your Database; Replication; Database Mirroring; Backup and Recovery; Log Shipping; Clustering SQL Server; |
Record link: | https://library.seeu.edu.mk/index.php?lvl=notice_display&id=17517 |