| Description |
1 online resource (xxvi, 574 pages) : illustrations |
| Series |
Wrox beginning guides |
|
Wrox beginning guides.
|
| Contents |
Beginning SQL Server 2005 Administration; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Introducing SQL Server 2005; What Is SQL Server 2005?; SQL Server 2005 Editions; SQL Server 2005 Architecture; SQL Server 2005 Database Objects; SQL Server 2005 Databases; SQL Server 2005 Database Storage; SQL Server Security; A (Very) Brief History of SQL Server; Summary; Chapter 2: Installing SQL Server 2005 |
|
SQL Server Installation PlanningSQL Server Setup Application; Installation Review; Summary; Chapter 3: SQL Server 2005 Tools; SQL Server Management Studio; Log File Viewer; SQL Server Business Intelligence Development Studio; SQL Server Profiler; Database Engine Tuning Advisor; SQL Server Configuration Manager; Reporting Services Configuration Manager; Command-Line Tools; Summary; Chapter 4: SQL Server 2005 Storage Architecture; The Resource Database; SQL Server Database Physical Structure; Summary; Chapter 5: SQL Server 2005 Databases; System Databases; User Databases; Database Planning |
|
Creating DatabasesDatabase Diagrams; Views; Synonyms; Programming Objects; Summary; Chapter 6: SQL Server 2005 Security; SQL Server Authentication Modes; Principals; Permissions; SQL Server Encryption; Best Practices; Summary; Exercises; Chapter 7: Configuring SQL Server Network Communication; SQL Server 2005 Network Protocols; SQL Native Client Configuration; SQL Server Endpoints; Summary; Chapter 8: Automating Administrative Tasks; Database Mail; Event Notifications; SQL Server Agent; Maintenance Plans; Best Practices; Summary; Exercises; Chapter 9: Disaster Prevention and Recovery |
|
Preparing the SmallWorks DatabaseDatabase Recovery Models; SQL Server 2005 Database Backup; SQL Server 2005 Backup Types; Backup Options; Backup Strategies; Restoring Databases; Database Snapshots; Summary; Chapter 10: Monitoring SQL Server for Performance; Monitoring and Optimization Overview; Tools and Techniques for Monitoring Performance; Monitoring Database Modifications; Summary; Chapter 11: SQL Server High Availability; Introduction to Availability; Failover Clustering; Log Shipping; Database Mirroring; Summary; Chapter 12: Administering SQL CLR Programming Objects |
|
Databases and ProgrammingIs the SQL Language a Relic?; .Net and the CLR; SQL Server CLR Objects; Code-Generation Features in Visual Studio; Programming Support; Security Options; Summary; Chapter 13: Introduction to SQL Server 2005 Integration Services; About SSIS; Importing and Exporting Data; Transforming Data with SSIS; Summary; Chapter 14: Introduction to SQL Server 2005 Notification Services; Overview; Introduction to the Notification Services Architecture; Installing a Notification Services Application; Summary; Chapter 15: Introduction to the Service Broker |
| Summary |
For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly ""administrative, "" duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator. Beginning with a foundation that features detailed coverage of typical administrative duties, the au |
| Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Database management.
|
|
Bases de données -- Gestion. |
|
Database management |
| Added Author |
Leiter, Chris, 1975-
|
|
Turley, Paul, 1962-
|
| Other Form: |
Print version: Wood, Dan, 1962- Beginning SQL server 2005 administration. Indianapolis, IN : Wrox-Wiley Pub., ©2007 0470047046 9780470047040 (DLC) 2006030328 (OCoLC)71322334 |
| ISBN |
9780470118863 (electronic bk.) |
|
0470118865 (electronic bk.) |
|
(paper/website) |
|
(paper/website) |
|
More Resources