Professional Microsoft SQL Server 2008 Administration

Häftad, Engelska, 2008

734 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer.This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.

Produktinformation

Utgivningsdatum:2008-11-03
Mått:188 x 234 x 51 mm
Vikt:1 365 g
Format:Häftad
Språk:Engelska
Antal sidor:912
Förlag:John Wiley & Sons Inc
ISBN:9780470247969

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

Brian Knight, SQL Server MVP, MCDBA is a database manager at Fidelity National Financial and a co-founder of SQLServerCentral.com. He has worked with SQL Server for 10 years and has written several SQL Server books, including Wrox' Professional SQL Server 2005 Integration Services.Ketan Patel is a Development Manager for the Business Intelligence Center of Excellence group at Microsoft. He has worked with SQL Server and other Microsoft technologies for more than 10 years, and has presented at TechEd.Ross LoForte is a SQL technology architect at the Microsoft Technology Center Chicago who specializes in Microsoft SQL Server solutions. He has more than 16 years experience developing, managing, and architecting SQL solutions on large, mission-critical database platforms. Ross presents at TechEd, SQL PASS, Gartner, TDWI, and other conferences.

Innehållsförteckning

Forward. Chapter 1. SQL Server 2005 Architecture.Chapter 2. SQL Server 2005 Installation Best Practices.Chapter 3. Upgrading SQL Server 2008 Best Practices.Chapter 4. Managing and Troubleshooting the Database Engine.Chapter 5. Automating SQL Server.Chapter 6. Integration Services Administration and Performance Tuning.Chapter 7. Analysis Services Administration and Performance Tuning.Chapter 8. Administering the Development Features.Chapter 9. Securing the Database Engine.Chapter 10. Change Management.Chapter 11. Configuring the Server for Optimal Performance.Chapter 12. Optimizing SQL Server 2005.Chapter 13. Monitoring Your SQL Server.Chapter 14. Performance Tuning T-SQL.Chapter 15. Indexing Your Database.Chapter 16. Replication.Chapter 17. Database Mirroring.Chapter 18. Backup and Recovery.Chapter 19. SQL Server 2005 Log Shipping.Chapter 20. Clustering SQL Server 2005.

Mer från samma författare

Calculus I

Brian Knight

Häftad, 1975

556 kr

Admin911 SQL Server 2000: A Survival Guide for System Administrators (2000)

Brian Knight

Häftad, 2001

507 kr

Professional Microsoft SQL Server 2008 Integration Services

Darren Herbold, Douglas Hinson, Grant Dickinson, Erik Veerman, Brian Knight

E-bok

2008

481 kr

Professional Microsoft SQL Server 2008 Administration

Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

E-bok

2008

647 kr

Professional Microsoft SQL Server 2008 Administration

Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

E-bok

2011

640 kr

Knight's Microsoft Business Intelligence 24-Hour Trainer

Mike Davis, Patrick LeBlanc, Adam Jorgensen, Devin Knight, Brian Knight

E-bok

2011

444 kr

Professional Microsoft SQL Server 2008 Integration Services

Darren Herbold, Douglas Hinson, Grant Dickinson, Erik Veerman, Brian Knight

E-bok

2011

481 kr

Professional Microsoft SQL Server 2012 Administration

Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight

Häftad, 2012

(1)

565 kr

Professional Microsoft SQL Server 2012 Integration Services

Chris Rock, Mike Davis, Jessica M. Moss, Erik Veerman, Brian Knight

E-bok

2012

476 kr

Professional Microsoft SQL Server 2012 Integration Services

Chris Rock, Mike Davis, Jessica M. Moss, Erik Veerman, Brian Knight

E-bok

2012

481 kr

Du kanske också är intresserad av

Pokémon Pokémon Mega Evolution 05 - Pitch Black Booster

Pokémon

79 kr

Professional Microsoft SQL Server 2008 Administration

Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

E-bok

2008

647 kr

Professional Microsoft SQL Server 2014 Administration

Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

E-bok

2014

524 kr

Professional Microsoft SQL Server 2014 Administration

Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

E-bok

2014

524 kr

Professional Microsoft SQL Server 2012 Administration

Brian Knight, Ross LoForte, Steven Wort, Adam Jorgensen

E-bok

2012

493 kr

Professional Microsoft SQL Server 2012 Administration

Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight

Häftad, 2012

(1)

565 kr

Professional Microsoft SQL Server 2012 Administration

Brian Knight, Ross LoForte, Steven Wort, Adam Jorgensen

E-bok

2012

493 kr

Professional Microsoft SQL Server 2008 Administration

Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

E-bok

2011

640 kr

Podstawy dotyczące chalkonu i powiązanej nowatorskiej syntezy

Ketan Patel, Rajarshi Patel, Jiten Patel

Häftad, 2025

499 kr

Nozioni di base sul chalcone e relative nuove sintesi

Ketan Patel, Rajarshi Patel, Jiten Patel

Häftad, 2025

499 kr

Professional Microsoft SQL Server 2008 Administration

AvBrian Knight,Ketan Patel

Häftad, Engelska, 2008

734 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

Produktinformation

Utgivningsdatum:2008-11-03
Mått:188 x 234 x 51 mm
Vikt:1 365 g
Format:Häftad
Språk:Engelska
Antal sidor:912
Förlag:John Wiley & Sons Inc
ISBN:9780470247969

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

Innehållsförteckning

Forward. Chapter 1. SQL Server 2005 Architecture.Chapter 2. SQL Server 2005 Installation Best Practices.Chapter 3. Upgrading SQL Server 2008 Best Practices.Chapter 4. Managing and Troubleshooting the Database Engine.Chapter 5. Automating SQL Server.Chapter 6. Integration Services Administration and Performance Tuning.Chapter 7. Analysis Services Administration and Performance Tuning.Chapter 8. Administering the Development Features.Chapter 9. Securing the Database Engine.Chapter 10. Change Management.Chapter 11. Configuring the Server for Optimal Performance.Chapter 12. Optimizing SQL Server 2005.Chapter 13. Monitoring Your SQL Server.Chapter 14. Performance Tuning T-SQL.Chapter 15. Indexing Your Database.Chapter 16. Replication.Chapter 17. Database Mirroring.Chapter 18. Backup and Recovery.Chapter 19. SQL Server 2005 Log Shipping.Chapter 20. Clustering SQL Server 2005.