Kategorien
E-Books
-
Wirtschaft
- Bitcoin
- Geschäftsfrau
- Coaching
- Controlling
- E-Business
- Ökonomie
- Finanzen
- Börse und Investitionen
- Persönliche Kompetenzen
- Computer im Büro
- Kommunikation und Verhandlungen
- Kleines Unternehmen
- Marketing
- Motivation
- Multimedia-Training
- Immobilien
- Überzeugung und NLP
- Steuern
- Sozialpolitik
- Handbȕcher
- Präsentationen
- Führung
- Public Relation
- Berichte, Analysen
- Geheimnis
- Social Media
- Verkauf
- Start-up
- Ihre Karriere
- Management
- Projektmanagement
- Personal (HR)
-
Für Kinder
-
Für Jugendliche
-
Bildung
-
Enzyklopädien, Wörterbücher
-
E-Presse
- Architektura i wnętrza
- Biznes i Ekonomia
- Haus und Garten
- E-Business
- Finanzen
- Persönliche Finanzen
- Unternehmen
- Fotografie
- Informatik
- HR und Gehaltsabrechnung
- Computer, Excel
- Buchhaltung
- Kultur und Literatur
- Wissenschaftlich und akademisch
- Umweltschutz
- meinungsbildend
- Bildung
- Steuern
- Reisen
- Psychologie
- Religion
- Landwirtschaft
- Buch- und Pressemarkt
- Transport und Spedition
- Gesundheit und Schönheit
-
Geschichte
-
Informatik
- Office-Programme
- Datenbank
- Bioinformatik
- IT Branche
- CAD/CAM
- Digital Lifestyle
- DTP
- Elektronik
- Digitale Fotografie
- Computergrafik
- Spiele
- Hacking
- Hardware
- IT w ekonomii
- Wissenschaftliche Pakete
- Schulbücher
- Computergrundlagen
- Programmierung
- Mobile-Programmierung
- Internet-Server
- Computernetzwerke
- Start-up
- Betriebssysteme
- Künstliche Inteligenz
- Technik für Kinder
- Webmaster
-
Andere
-
Fremdsprachen lernen
-
Kultur und Kunst
-
Lektüre
-
Literatur
- Anthologien
- Ballade
- Biografien und Autobiografien
- Für Erwachsene
- Drama
- Tagebücher, Memoiren, Briefe
- Epos
- Essay
- Science Fiction
- Felietonys
- Fiktion
- Humor, Satire
- Andere
- Klassisch
- Krimi
- Sachbücher
- Belletristik
- Mity i legendy
- Nobelpreisträger
- Kurzgeschichten
- Gesellschaftlich
- Okultyzm i magia
- Erzählung
- Erinnerungen
- Reisen
- Gedicht
- Poesie
- Politik
- Populärwissenschaftlich
- Roman
- Historischer Roman
- Prosa
- Abenteuer
- Journalismus
- Reportage
- Romans i literatura obyczajowa
- Sensation
- Thriller, Horror
- Interviews und Erinnerungen
-
Naturwissenschaften
-
Sozialwissenschaften
-
Schulbücher
-
Populärwissenschaft und akademisch
- Archäologie
- Bibliotekoznawstwo
- Filmwissenschaft
- Philologie
- Polnische Philologie
- Philosophie
- Finanse i bankowość
- Erdkunde
- Wirtschaft
- Handel. Weltwirtschaft
- Geschichte und Archäologie
- Kunst- und Architekturgeschichte
- Kulturwissenschaft
- Linguistik
- Literaturwissenschaft
- Logistik
- Mathematik
- Medizin
- Geisteswissenschaften
- Pädagogik
- Lehrmittel
- Populärwissenschaftlich
- Andere
- Psychologie
- Soziologie
- Theatrologie
- Teologie
- Theorien und Wirtschaftswissenschaften
- Transport i spedycja
- Sportunterricht
- Zarządzanie i marketing
-
Handbȕcher
-
Spielanleitungen
-
Professioneller und fachkundige Leitfaden
-
Jura
- Sicherheit und Gesundheit am Arbeitsplatz
- Geschichte
- Verkehrsregeln. Führerschein
- Rechtswissenschaften
- Gesundheitswesen
- Allgemeines. Wissenskompendium
- akademische Bücher
- Andere
- Bau- und Wohnungsrecht
- Zivilrecht
- Finanzrecht
- Wirtschaftsrecht
- Wirtschafts- und Handelsrecht
- Strafrecht
- Strafrecht. Kriminelle Taten. Kriminologie
- Internationales Recht
- Internationales und ausländisches Recht
- Gesundheitsschutzgesetz
- Bildungsrecht
- Steuerrecht
- Arbeits- und Sozialversicherungsrecht
- Öffentliches, Verfassungs- und Verwaltungsrecht
- Familien- und Vormundschaftsrecht
- Agrarrecht
- Sozialrecht, Arbeitsrecht
- EU-Recht
- Industrie
- Agrar- und Umweltschutz
- Wörterbücher und Enzyklopädien
- Öffentliche Auftragsvergabe
- Management
-
Führer und Reisen
- Afrika
- Alben
- Südamerika
- Mittel- und Nordamerika
- Australien, Neuseeland, Ozeanien
- Österreich
- Asien
- Balkan
- Naher Osten
- Bulgarien
- China
- Kroatien
- Tschechische Republik
- Dänemark
- Ägypten
- Estland
- Europa
- Frankreich
- Berge
- Griechenland
- Spanien
- Niederlande
- Island
- Litauen
- Lettland
- Mapy, Plany miast, Atlasy
- Miniführer
- Deutschland
- Norwegen
- Aktive Reisen
- Polen
- Portugal
- Andere
- Russland
- Rumänien
- Slowakei
- Slowenien
- Schweiz
- Schweden
- Welt
- Türkei
- Ukraine
- Ungarn
- Großbritannien
- Italien
-
Psychologie
- Lebensphilosophien
- Kompetencje psychospołeczne
- zwischenmenschliche Kommunikation
- Mindfulness
- Allgemeines
- Überzeugung und NLP
- Akademische Psychologie
- Psychologie von Seele und Geist
- Arbeitspsychologie
- Relacje i związki
- Elternschafts- und Kinderpsychologie
- Problemlösung
- Intellektuelle Entwicklung
- Geheimnis
- Sexualität
- Verführung
- Aussehen ind Image
- Lebensphilosophien
-
Religion
-
Sport, Fitness, Diäten
-
Technik und Mechanik
Hörbücher
-
Wirtschaft
- Bitcoin
- Geschäftsfrau
- Coaching
- Controlling
- E-Business
- Ökonomie
- Finanzen
- Börse und Investitionen
- Persönliche Kompetenzen
- Kommunikation und Verhandlungen
- Kleines Unternehmen
- Marketing
- Motivation
- Immobilien
- Überzeugung und NLP
- Steuern
- Handbȕcher
- Präsentationen
- Führung
- Public Relation
- Geheimnis
- Social Media
- Verkauf
- Start-up
- Ihre Karriere
- Management
- Projektmanagement
- Personal (HR)
-
Für Kinder
-
Für Jugendliche
-
Bildung
-
Enzyklopädien, Wörterbücher
-
Geschichte
-
Informatik
-
Andere
-
Fremdsprachen lernen
-
Kultur und Kunst
-
Lektüre
-
Literatur
- Anthologien
- Ballade
- Biografien und Autobiografien
- Für Erwachsene
- Drama
- Tagebücher, Memoiren, Briefe
- Epos
- Essay
- Science Fiction
- Felietonys
- Fiktion
- Humor, Satire
- Andere
- Klassisch
- Krimi
- Sachbücher
- Belletristik
- Mity i legendy
- Nobelpreisträger
- Kurzgeschichten
- Gesellschaftlich
- Okultyzm i magia
- Erzählung
- Erinnerungen
- Reisen
- Poesie
- Politik
- Populärwissenschaftlich
- Roman
- Historischer Roman
- Prosa
- Abenteuer
- Journalismus
- Reportage
- Romans i literatura obyczajowa
- Sensation
- Thriller, Horror
- Interviews und Erinnerungen
-
Naturwissenschaften
-
Sozialwissenschaften
-
Populärwissenschaft und akademisch
- Archäologie
- Philosophie
- Wirtschaft
- Handel. Weltwirtschaft
- Geschichte und Archäologie
- Kunst- und Architekturgeschichte
- Kulturwissenschaft
- Literaturwissenschaft
- Mathematik
- Medizin
- Geisteswissenschaften
- Pädagogik
- Lehrmittel
- Populärwissenschaftlich
- Andere
- Psychologie
- Soziologie
- Teologie
- Zarządzanie i marketing
-
Handbȕcher
-
Professioneller und fachkundige Leitfaden
-
Jura
-
Führer und Reisen
-
Psychologie
- Lebensphilosophien
- zwischenmenschliche Kommunikation
- Mindfulness
- Allgemeines
- Überzeugung und NLP
- Akademische Psychologie
- Psychologie von Seele und Geist
- Arbeitspsychologie
- Relacje i związki
- Elternschafts- und Kinderpsychologie
- Problemlösung
- Intellektuelle Entwicklung
- Geheimnis
- Sexualität
- Verführung
- Aussehen ind Image
- Lebensphilosophien
-
Religion
-
Sport, Fitness, Diäten
-
Technik und Mechanik
Videokurse
-
Datenbank
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersicherheit
-
Data Science
-
DevOps
-
Für Kinder
-
Elektronik
-
Grafik / Video / CAX
-
Spiele
-
Microsoft Office
-
Entwicklungstools
-
Programmierung
-
Persönliche Entwicklung
-
Computernetzwerke
-
Betriebssysteme
-
Softwaretest
-
Mobile Geräte
-
UX/UI
-
Web development
-
Management
Podcasts
- E-Books
- Informatik
- Internet-Server
- Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and
Details zum E-Book
Einloggen, wenn Sie am Inhalt des Artikels interessiert sind.
Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and
E-book
- Microsoft SQL Server 2008 R2 Administration Cookbook
- Table of Contents
- Microsoft SQL Server 2008 R2 Administration Cookbook
- Credits
- Foreword
- About the Author
- Acknowledgment
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- SQL Server 2008 R2 Prologue
- SQL Server 2008 R2 new enhancements
- SQL Server 2008 R2 DataCenter
- SQL Server 2008 R2 Parallel Data Warehouse
- SQL Server 2008 R2 Core Editions Enhancements
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Getting Started with SQL Server 2008 R2
- Introduction
- Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
- Getting Ready
- How to do it...
- How it works...
- Theres more...
- Designing a best practice approach to upgrading to SQL Server 2008 R2
- Getting Ready
- How to do it...
- How it works...
- Backward CompatibilityDeprecate & Discontinued features
- There's more.
- Working with Data-Tier applications
- Getting ready
- How to do it...
- How it works...
- There's more...
- Designing and adopting SQL Server 2008 R2 solutions
- Getting ready
- How to do it...
- How it works...
- There's more...
- Designing applications to use federated servers
- Getting ready
- How to do it...
- How it works...
- 2. Administrating the Core Database Engine
- Introduction
- Designing automated administration practices
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Implementing Security feature enhancements
- Getting ready
- How to do it...
- How it works...
- See Also
- Implementing Availability feature enhancements
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Implementing, Monitoring, and Tuning for performance
- Getting ready
- How to do it...
- How it works...
- Administering SQL Server workloads with Resource Governor
- Getting ready
- How to do it...
- How it works...
- There's more...
- Designing SQL Server Agent scheduled jobs for ETL processes
- Getting ready
- How to do it...
- How it works...
- There's more
- Troubleshooting multi-server instances with utility administration
- Getting ready
- How to do it...
- How it works...
- Administering SQL Server Replication processes
- Getting ready
- How to do it...
- How it works...
- See Also
- 3. Managing the Core Database Engine
- Introduction
- Implementing Central Management feature enhancements
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Designing Multi-server management from SQL Server 2008 R2
- Getting ready
- How to do it...
- How it works...
- Managing the Utility Control Point data warehouse database
- How to do it...
- How it works...
- Implementing Utility & Non-utility collection sets
- Getting ready
- How to do it...
- How it works...
- Designing and refreshing a Scalable Shared database
- Getting ready
- How to do it...
- How it works...
- There's more
- Managing SQL Server Replication processes
- How to do it...
- How it works
- Implementing security for SQL Server Agent jobs management
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Multiserver Management Using Utility Explorer
- Getting ready
- How to do it...
- How it works...
- 4. Administering Core Business Intelligence Services
- Introduction
- Preparing and installing SQL Server Analysis Services
- Getting ready
- How to do it...
- How it works...
- There's more
- Implementing Scale-Out of SQL Server Analysis Services
- Getting ready
- How to do it...
- How it works...
- Administering SQL Server Reporting Services
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Implementing Scale-Out deployment of SQL Server Reporting Services
- Getting ready
- How to do it...
- How it works...
- There's more
- See Also
- Preparing and installing SQL Server Integration Services
- Getting ready
- How to do it...
- How it works...
- Managing the ETL process efficiently
- How to do it...
- How it works...
- 5. Managing Core SQL Server 2008 R2 Technologies
- Introduction
- Planning and implementing Self-Service Business Intelligence services
- Getting ready
- How to do it...
- How it works...
- There's more
- Implementing Microsoft StreamInsight Technologies Platform
- Getting ready
- How to do it...
- How it works...
- Implementing SQL Azure connectivity features
- Getting ready
- How to do it...
- How it works...
- There's more
- Installing and configuring a Master Data Services Solution
- Getting ready
- How to do it...
- How it works...
- Designing and deploying framework to use Master Data Services
- Getting ready
- How to do it...
- How it works...
- 6. Improving Availability and enhancing Programmability
- Introduction
- Preparing new Failover Cluster features
- Getting ready
- How to do it...
- How it works...
- Installing and configuring Failover Cluster Services
- Getting ready
- How to do it...
- How it works...
- Recovering and troubleshooting Failover Cluster Failure
- Getting ready
- How to do it...
- How it works...
- See also
- Implementing Database Mirroring features and performance enhancements
- Getting ready
- How to do it...
- How it works...
- See also
- Managing Database Mirroring in a Failover Cluster environment
- Getting ready
- How to do it...
- How it works...
- Managing Log Shipping scenarios in a Database Mirroring environment
- Getting ready
- How to do it...
- How it works...
- Improving Replication scalability at multiple sites
- Getting ready
- How to do it...
- How it works...
- Implementing compressed storage features for tables and indexes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Designing a storage solution for unstructured data and new collations
- Getting ready
- How to do it...
- How it works...
- There's more...
- Designing data partitioning solutions for tables and indexes
- Getting ready
- How to do it...
- How it works...
- Implementing sparse columns and wide table features
- Getting ready
- How to do it...
- How it works...
- Designing spatial data storage methods
- Getting ready
- How to do it...
- How it works...
- Deploying and managing data-tier applications
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 7. Implementing New Manageability Features and Practices
- Introduction
- Implementing auditing and service level security features
- Getting ready
- How to do it...
- How it works...
- Managing server-level securable and database-level permissions
- Getting ready
- How to do it...
- How it works...
- Implementing backup compression for a VLDB environment
- Getting ready
- How to do it...
- How it works...
- Designing change tracking methodology
- Getting ready
- How to do it...
- How it works...
- Implementing Policy-Based Management features
- Getting ready
- How to do it...
- How it works...
- There's more...
- Implementing and running PowerShell for SQL Server features
- Getting ready
- How to do it...
- How it works...
- There's more...
- Implementing the SQL Server Best Practices Analyzer
- Getting ready
- How to do it...
- How it works...
- Designing Transparent Data Encryption features
- Getting ready
- How to do it...
- How it works...
- There's more...
- 8. Maintenance and Monitoring
- Introduction
- Implementing performance baseline practices
- Getting ready
- How to do it
- How it works...
- There's more.
- See Also
- Monitoring resource usage with Extended Events
- Getting ready
- How to do it...
- How it works...
- There's more
- Implementing Management Data Warehouse features
- Getting ready
- How to do it
- How it works...
- There's more...
- Designing maintenance tasks on a mission-critical environment
- Getting ready
- How to do it...
- How it works.
- Implementing Piecemeal restore strategies
- Getting ready
- How to do it...
- How it works...
- There's more...
- Getting ready
- Planning and designing of a Disaster Recovery environment
- Getting ready
- How to do it...
- How it works...
- Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
- Getting ready
- How to do it...
- How it works...
- Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
- Getting ready
- How to do it...
- How it works...
- Configuring a server storage system for scalability
- Getting ready
- How to do it...
- How it works...
- Configuring SQL server storage architecture for quick recovery
- Getting ready
- How to do it...
- How it works...
- Managing a storage system for analyzing bottlenecks
- Getting ready
- How to do it...
- How it works...
- 9. Troubleshooting
- Introduction
- Implementing systematized monitoring methods for data platform optimization
- Getting ready
- How to do it...
- How it works...
- Designing a filtered indexes and statistics feature
- Getting ready
- How to do it...
- How it works...
- Implementing table hints for advanced query tuning performance
- How to do it...
- How it works...
- Implementing query hints for optimized performance
- How to do it...
- How it works...
- Designing sustainable locking methods to improve concurrency
- How to do it...
- How it works...
- Implementing parallel query processing methods
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Implementing the plan guide to enhance compile-time and run-time execution plans
- How to do it...
- How it works...
- There's more...
- Configuring and managing storage systems for optimized defragmentation processes
- Getting ready
- How to do it...
- How it works...
- Building best usage processes of Dynamic Management Views
- How to do it...
- How it works...
- Implementing a benchmarking framework on multiple instances
- Getting ready
- How to do it...
- How it works...
- There's more...
- 10. Learning the Tricks of the Trade
- Introduction
- Automated administration across an enterprise
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Administrating resource health policies
- Getting ready
- How to do it...
- How it works...
- Administrating multiple Analysis Services using Tools
- How to do it...
- How it works...
- Managing events capture to troubleshoot problems
- How to do it...
- How it works...
- See also
- A. More DBA Manageability Best Practices
- Index
- Titel: Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and
- Autor: Satya Shyam K Jayanty
- Originaler Titel: Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook
- ISBN: 9781849681452, 9781849681452
- Veröffentlichungsdatum: 2011-05-24
- Format: E-book
- Artikelkennung: e_3bj8
- Verleger: Packt Publishing