Home Page Icon
Home Page
Table of Contents for
About the Authors
Close
About the Authors
by Herve Roggero, Scott Klein
Pro SQL Azure
Copyright
About the Authors
About the Technical Reviewer
Acknowledgments
1. Getting Started with SQL Azure
1.1. Introduction to Cloud Computing
1.1.1. Who Is Doing What in the Cloud?
1.1.2. Typical Cloud Services
1.2. Discovering the Microsoft Azure Platform
1.2.1. Why Microsoft Azure?
1.2.2. About Geographic Locations
1.2.3. Storing Data in Azure
1.3. SQL Azure Primer
1.3.1. Registering for Azure
1.3.2. Creating a Database in SQL Azure
1.3.2.1. Using the SQL Azure Portal
1.3.2.2. Using a T-SQL Command
1.3.3. Configuring the Firewall
1.3.4. Connecting with SQL Server Management Studio
1.3.5. Creating Logins and Users
1.3.5.1. Creating a New Login
1.3.5.2. Creating a New User
1.3.6. Assigning Access Rights
1.3.7. Understanding Billing for SQL Azure
1.4. Limitations in SQL Azure
1.4.1. Security
1.4.2. Backups
1.4.3. Objects
1.4.4. Miscellaneous
1.4.5. Drivers and Protocols
1.5. Conclusion
2. Design Considerations
2.1. Design Factors
2.1.1. Offsite Storage
2.1.2. High Availability
2.1.3. Performance
2.1.3.1. Throttling
2.1.3.2. Application Design Considerations
2.1.4. SQL Data Sync Framework
2.1.5. Direct vs. Serviced Connections
2.1.6. Pricing
2.1.7. Security
2.1.8. Review of Design Factors
2.2. Design Patterns
2.2.1. Direct Connection
2.2.2. Smart Branching
2.2.3. Transparent Branching
2.2.4. Sharding
2.2.4.1. Shard Concepts and Methods
2.2.4.2. Read-Only Shards
2.2.4.3. Read-Write Shards
2.2.5. Offloading
2.2.6. Aggregation
2.2.7. Mirroring
2.3. Combining Patterns
2.3.1. Transparent Branching + RWS
2.3.2. Cascading Aggregation
2.4. Sample Design: Application SLA Monitoring
2.4.1. Pre-Azure Application Architecture
2.4.2. Azure Implementation
2.5. Other Considerations
2.5.1. Blob Data Stores
2.5.2. Edge Data Caching
2.5.3. Data Encryption
2.6. Conclusion
3. Setting Up and Configuring
3.1. Creating Your Azure Account
3.2. Managing Your Azure Projects
3.3. Azure Server Administration
3.3.1. Server Information
3.3.2. Firewall Settings
3.3.3. Databases
3.4. Creating Databases, Logins, and Users
3.4.1. Databases
3.4.2. Logins and Users
3.4.2.1. Logins
3.4.2.2. Users
3.5. Connecting to a SQL Azure Database
3.5.1. Connecting Using ADO.NET
3.5.2. Connecting from the Entity Framework
3.6. Conclusion
4. Security
4.1. Overview
4.1.1. Confidentiality
4.1.2. Integrity
4.1.3. Availability
4.2. Securing Your Data
4.2.1. Encryption
4.2.2. Hashing
4.2.3. Certificates
4.3. Access Control
4.3.1. Authentication (AUTHN)
4.3.2. Authorization (AUTHZ)
4.3.2.1. Creating Logins and Users
4.3.2.2. Schemas
4.3.3. Firewall
4.4. Compliance
4.5. Conclusion
5. Data Migration and Backup Strategies
5.1. Migrating Databases and Data to SQL Azure
5.1.1. Generate and Publish Scripts Wizard
5.1.1.1. Starting the Wizard
5.1.1.2. Choosing Target Objects
5.1.1.3. Setting Advanced Options
5.1.1.4. Saving and Publishing
5.1.1.5. Reviewing the Generated Script
5.1.1.6. Fixing the Script
5.1.1.7. Executing the Script Against an Azure Database
5.1.2. SQL Server Integration Services
5.1.2.1. Creating an Integration Services Project
5.1.2.2. Clearing Any Preexisting Data
5.1.2.3. Building a Migration Package
5.1.2.4. Executing Your Migration Package
5.1.2.5. Verifying the Migration
5.1.2.6. Other Cases to Consider
5.1.3. Bcp
5.1.3.1. Invoking BCP
5.1.3.2. Exporting the Data
5.1.3.3. Importing the Data
5.1.3.4. Putting the Export and Import Together
5.2. SQL Azure Backup Strategies
5.2.1. Copying a Database
5.2.2. Knowing When a Copy Is Complete
5.2.3. Automating a Database Copy
5.2.4. Maintaining a Backup History
5.3. Conclusion
6. Programming with SQL Azure
6.1. Application Deployment Factors
6.1.1. On-Premise Application
6.1.2. Azure-Hosted Application
6.1.3. Which to Choose?
6.2. Connecting to SQL Azure
6.2.1. ADO.NET
6.2.1.1. Making the Connection
6.2.1.2. Using a Data Reader
6.2.1.3. Using a Dataset
6.2.2. ODBC
6.2.3. Sqlcmd
6.3. WCF Data Services
6.3.1. Creating a Data Service
6.3.2. Connecting the Service to the Model
6.3.3. Creating the Client Application
6.3.4. Creating the User Interface
6.3.5. Running the Application
6.4. Record Navigation in WCF Data Services
6.4.1. Disabling Internet Explorer's Feed Reading View
6.4.2. Viewing the Final Results
6.5. Azure Programming Considerations
6.6. Conclusion
7. OData with SQL Azure
7.1. OData Overview
7.1.1. OData Producers
7.1.2. OData Consumers
7.2. Enabling OData on an Azure Database
7.2.1. Getting Started at SQL Azure Labs
7.2.2. Understanding Anonymous Access
7.2.3. Understanding the Access Control Service
7.2.4. Implementing Security Best Practices
7.3. Viewing OData-Enabled SQL Azure Data
7.4. Viewing Data through an OData Consumer
7.5. Building Two OData Consumer Applications
7.5.1. Simple Demo App
7.5.2. Windows Mobile 7 Application
7.6. Conclusion
8. Reporting Services with SQL Azure
8.1. Starting a SQL Azure–Based Report
8.2. Creating the SQL Azure Data Source
8.3. Creating the Report Design
8.4. Deploying the Report
8.5. Creating a Subreport
8.5.1. Adding the Subreport to the Main Report
8.6. Conclusion
9. Windows Azure and ASP.NET
9.1. Creating a Windows Azure Service
9.2. Creating a Windows Azure Project
9.2.1. Configuring Your Development Environment
9.2.2. Creating Your First Visual Studio Cloud Project
9.2.3. Connecting a GridView to SQL Azure
9.3. Deploying an ASP.NET Application in Windows Azure
9.4. Conclusion
10. Designing for High Performance
10.1. General Performance Concepts
10.1.1. Chatty vs. Chunky
10.1.2. Lazy Loading
10.1.3. Caching
10.1.4. Asynchronous User Interface
10.1.5. Parallel Processing
10.1.6. Shards
10.1.7. Coding Strategies Summary
10.2. Building a Shard
10.2.1. Designing the Shard Library Object
10.2.2. Managing Database Connections
10.2.3. Reading Using the Shard
10.2.4. Caching
10.2.5. Updating and Deleting Records in the Shard
10.2.6. Adding Records to the Shard
10.3. Managing a Shard
10.3.1. Managing Exceptions
10.3.2. Managing Performance
10.3.3. Working with Partial Shards
10.3.4. Managing Transaction Consistency
10.3.5. Managing Foreign Key Constraints
10.4. Creating Vertical Partition Shards
10.5. Conclusion
11. SQL Azure Data Sync Services
11.1. Understanding the Data Sync Service
11.1.1. Why the Need?
11.1.2. The Basic Scenario
11.2. Configuring Synchronization
11.2.1. Agreeing to the Terms of Service
11.2.2. Creating a Sync Group
11.2.3. Defining the Hub and Member Databases
11.2.4. Selecting Tables to be Synchronized
11.2.5. Modifying a Sync Group
11.3. Manually Synchronizing
11.3.1. Looking at the Database Changes
11.3.2. Looking at the Synchronized Data
11.4. Scheduling Data Synchronization
11.5. Synching an On-Premises Database with SQL Azure
11.6. Data Sync Best Practices
11.7. Conclusion
12. Performance Tuning
12.1. What's Different with SQL Azure
12.1.1. Methods and Tools
12.1.2. Coding Implications
12.2. Tuning Techniques
12.2.1. Dynamic Management Views
12.2.2. Connection Pooling
12.2.3. Execution Plans
12.2.4. Indexing
12.2.5. Indexed Views
12.2.6. Stored Procedures
12.2.7. Provider Statistics
12.2.8. Application Design
12.3. Conclusion
A. Houston
A.1. Launching Houston
A.2. Using Houston
B. SQL Azure Quick Reference
B.1. Supported T-SQL
B.2. Partially Supported T-SQL
B.3. Unsupported T-SQL
B.4. Supported Data Types
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
Copyright
Next
Next Chapter
About the Technical Reviewer
About the Authors
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