Home Page Icon
Home Page
Table of Contents for
Title
Close
Title
by Jason Strate, Gail Shaw, Chris Shaw, Herve Roggero, Mladen Prajdić, Kellyn Pot
Pro SQL Server 2012 Practices
Title
Dedication
Contents at a Glance
Contents
About the Authors
About the Technical Reviewers
Acknowledgments
Introduction
Chapter 1: Be Your Developer’s Best Friend
My Experience Working with SQL Server and Developers
Reconciling Different Viewpoints Within an Organization
Preparing to Work with Developers to Implement Changes to a System
Step 1: Map Your Environment
Step 2: Describe the New Environment
Step 3: Create a Clear Document
Step 4: Create System-Management Procedures
Step 5: Create Good Reporting
Ensuring Version Compatibility
Setting Limits
Next Steps
Chapter 2: Getting It Right: Designing the Database for Performance
Requirements
Table Structure
Design Testing
Conclusion
Chapter 3: Hidden Performance Gotchas
Predicates
Residuals
Spills
Conclusion
Chapter 4: Dynamic Management Views
Understanding the Basics
Common Performance-Tuning Queries
Physical Performance Queries
System Performance Tuning Queries
Conclusion
Chapter 5: From SQL Trace to Extended Events
SQL Trace
Event Notifications
Extended Events
Conclusion
Chapter 6: The Utility Database
Start with Checklists
Utility Database Layout
Gathering Data
Using the Data
Conclusion
Chapter 7: Indexing Outside the Bubble
The Environment Bubble
The Business Bubble
Conclusion
Chapter 8: Release Management
My Release Management Process
A Change Is Requested
Documents
Conclusion
Chapter 9: Compliance and Auditing
Compliance
New Auditing Features in SQL Server 2012
Auditing
Server Audit
Server Audit Specification
Database Audit Specification
Query the Audit File
Pro Tip: Alert on Audit Events
Conclusion
Chapter 10: Automating Administration
Tools for Automation
What to Automate
Conclusion
Chapter 11: The Fluid Dynamics of SQL Server Data Movement
Why the Need for Replicating Data?
SQL Server Solutions
Choosing the Right Deployment
Keeping the Data Consistent
Conclusion
Chapter 12: Windows Azure SQL Database for DBAs
SQL Database Architecture
Differences with SQL Server
Federations
Troubleshooting Performance Issues
Related Services
Cost of SQL Database
Conclusion
Chapter 13: I/O: The Untold Story
The Basics
Monitoring
Considerations
Tactical
Code or Disk?
Times Have Changed
Getting to the Data
Addressing a Query
Environmental Considerations
Conclusion
Chapter 14: Page and Row Compression
Before You Get Started
Row Compression
Page Compression
What Do You Compress?
Fragmentation and Logged Operations
Conclusion
Chapter 15: Selecting and Sizing the Server
Understanding Your Workload
SQL Server 2012 Enterprise Edition Consideration Factors
Server Vendor Selection
Server Form Factor Selection
Server Processor Count Selection
Dell 12th Generation Server Comparison
Processor Vendor Selection
Processor Model Selection
Memory Selection
Conclusion
Chapter 16: Backups and Restores Using Availability Groups
Setting Up an Availability Group
Enabling Backups on Availability Groups
Automating Backups on Availability Groups
Recovery on Availability Groups
Conclusion
Chapter 17: Big Data for the SQL Server DBA
Big Data Arrives with Hadoop
DBA As Data Architect
Big Data for Analytics
Using SQL Server with Hadoop
Big Data for the Rest of Us
Big Data in the Microsoft Future
Conclusion
Chapter 18: Tuning for Peak Load
Define the Peak Load
Determine Where You Are Today
Analyze the Data
Devise a Plan
Conclusion
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Pro SQL Server 2012 Practices
Next
Next Chapter
Pro SQL Server 2012 Practices
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset