book

Pro SQL Azure

Name: Pro SQL Azure
ISBN: 9781430229612

by Scott Klein, Herve Roggero

October 2010

Intermediate to advanced

308 pages

6h 59m

English

Apress

Read now

Unlock full access

Copyright
About the Authors
About the Technical Reviewer
Acknowledgments
1. Getting Started with SQL Azure
1.1. Introduction to Cloud Computing1.1.1. Who Is Doing What in the Cloud?1.1.2. Typical Cloud Services1.2. Discovering the Microsoft Azure Platform1.2.1. Why Microsoft Azure?1.2.2. About Geographic Locations1.2.3. Storing Data in Azure1.3. SQL Azure Primer1.3.1. Registering for Azure1.3.2. Creating a Database in SQL Azure1.3.2.1. Using the SQL Azure Portal1.3.2.2. Using a T-SQL Command1.3.3. Configuring the Firewall1.3.4. Connecting with SQL Server Management Studio1.3.5. Creating Logins and Users1.3.5.1. Creating a New Login1.3.5.2. Creating a New User1.3.6. Assigning Access Rights1.3.7. Understanding Billing for SQL Azure1.4. Limitations in SQL Azure1.4.1. Security1.4.2. Backups1.4.3. Objects1.4.4. Miscellaneous1.4.5. Drivers and Protocols1.5. Conclusion
2. Design Considerations
2.1. Design Factors2.1.1. Offsite Storage2.1.2. High Availability2.1.3. Performance2.1.3.1. Throttling2.1.3.2. Application Design Considerations2.1.4. SQL Data Sync Framework2.1.5. Direct vs. Serviced Connections2.1.6. Pricing2.1.7. Security2.1.8. Review of Design Factors2.2. Design Patterns2.2.1. Direct Connection2.2.2. Smart Branching2.2.3. Transparent Branching2.2.4. Sharding2.2.4.1. Shard Concepts and Methods2.2.4.2. Read-Only Shards2.2.4.3. Read-Write Shards2.2.5. Offloading2.2.6. Aggregation2.2.7. Mirroring2.3. Combining Patterns2.3.1. Transparent Branching + RWS2.3.2. Cascading Aggregation2.4. Sample Design: Application SLA Monitoring2.4.1. Pre-Azure Application Architecture2.4.2. Azure Implementation2.5. Other Considerations2.5.1. Blob Data Stores2.5.2. Edge Data Caching2.5.3. Data Encryption2.6. Conclusion
3. Setting Up and Configuring
3.1. Creating Your Azure Account3.2. Managing Your Azure Projects3.3. Azure Server Administration3.3.1. Server Information3.3.2. Firewall Settings3.3.3. Databases3.4. Creating Databases, Logins, and Users3.4.1. Databases3.4.2. Logins and Users3.4.2.1. Logins3.4.2.2. Users3.5. Connecting to a SQL Azure Database3.5.1. Connecting Using ADO.NET3.5.2. Connecting from the Entity Framework3.6. Conclusion
4. Security
4.1. Overview4.1.1. Confidentiality4.1.2. Integrity4.1.3. Availability4.2. Securing Your Data4.2.1. Encryption4.2.2. Hashing4.2.3. Certificates4.3. Access Control4.3.1. Authentication (AUTHN)4.3.2. Authorization (AUTHZ)4.3.2.1. Creating Logins and Users4.3.2.2. Schemas4.3.3. Firewall4.4. Compliance4.5. Conclusion
5. Data Migration and Backup Strategies
5.1. Migrating Databases and Data to SQL Azure5.1.1. Generate and Publish Scripts Wizard5.1.1.1. Starting the Wizard5.1.1.2. Choosing Target Objects5.1.1.3. Setting Advanced Options5.1.1.4. Saving and Publishing5.1.1.5. Reviewing the Generated Script5.1.1.6. Fixing the Script5.1.1.7. Executing the Script Against an Azure Database5.1.2. SQL Server Integration Services5.1.2.1. Creating an Integration Services Project5.1.2.2. Clearing Any Preexisting Data5.1.2.3. Building a Migration Package5.1.2.4. Executing Your Migration Package5.1.2.5. Verifying the Migration5.1.2.6. Other Cases to Consider5.1.3. Bcp5.1.3.1. Invoking BCP5.1.3.2. Exporting the Data5.1.3.3. Importing the Data5.1.3.4. Putting the Export and Import Together5.2. SQL Azure Backup Strategies5.2.1. Copying a Database5.2.2. Knowing When a Copy Is Complete5.2.3. Automating a Database Copy5.2.4. Maintaining a Backup History5.3. Conclusion
6. Programming with SQL Azure
6.1. Application Deployment Factors6.1.1. On-Premise Application6.1.2. Azure-Hosted Application6.1.3. Which to Choose?6.2. Connecting to SQL Azure6.2.1. ADO.NET6.2.1.1. Making the Connection6.2.1.2. Using a Data Reader6.2.1.3. Using a Dataset6.2.2. ODBC6.2.3. Sqlcmd6.3. WCF Data Services6.3.1. Creating a Data Service6.3.2. Connecting the Service to the Model6.3.3. Creating the Client Application6.3.4. Creating the User Interface6.3.5. Running the Application6.4. Record Navigation in WCF Data Services6.4.1. Disabling Internet Explorer's Feed Reading View6.4.2. Viewing the Final Results6.5. Azure Programming Considerations6.6. Conclusion

7. OData with SQL Azure
7.1. OData Overview7.1.1. OData Producers7.1.2. OData Consumers7.2. Enabling OData on an Azure Database7.2.1. Getting Started at SQL Azure Labs7.2.2. Understanding Anonymous Access7.2.3. Understanding the Access Control Service7.2.4. Implementing Security Best Practices7.3. Viewing OData-Enabled SQL Azure Data7.4. Viewing Data through an OData Consumer7.5. Building Two OData Consumer Applications7.5.1. Simple Demo App7.5.2. Windows Mobile 7 Application7.6. Conclusion
8. Reporting Services with SQL Azure
8.1. Starting a SQL Azure–Based Report8.2. Creating the SQL Azure Data Source8.3. Creating the Report Design8.4. Deploying the Report8.5. Creating a Subreport8.5.1. Adding the Subreport to the Main Report8.6. Conclusion
9. Windows Azure and ASP.NET
9.1. Creating a Windows Azure Service9.2. Creating a Windows Azure Project9.2.1. Configuring Your Development Environment9.2.2. Creating Your First Visual Studio Cloud Project9.2.3. Connecting a GridView to SQL Azure9.3. Deploying an ASP.NET Application in Windows Azure9.4. Conclusion
10. Designing for High Performance
10.1. General Performance Concepts10.1.1. Chatty vs. Chunky10.1.2. Lazy Loading10.1.3. Caching10.1.4. Asynchronous User Interface10.1.5. Parallel Processing10.1.6. Shards10.1.7. Coding Strategies Summary10.2. Building a Shard10.2.1. Designing the Shard Library Object10.2.2. Managing Database Connections10.2.3. Reading Using the Shard10.2.4. Caching10.2.5. Updating and Deleting Records in the Shard10.2.6. Adding Records to the Shard10.3. Managing a Shard10.3.1. Managing Exceptions10.3.2. Managing Performance10.3.3. Working with Partial Shards10.3.4. Managing Transaction Consistency10.3.5. Managing Foreign Key Constraints10.4. Creating Vertical Partition Shards10.5. Conclusion
11. SQL Azure Data Sync Services
11.1. Understanding the Data Sync Service11.1.1. Why the Need?11.1.2. The Basic Scenario11.2. Configuring Synchronization11.2.1. Agreeing to the Terms of Service11.2.2. Creating a Sync Group11.2.3. Defining the Hub and Member Databases11.2.4. Selecting Tables to be Synchronized11.2.5. Modifying a Sync Group11.3. Manually Synchronizing11.3.1. Looking at the Database Changes11.3.2. Looking at the Synchronized Data11.4. Scheduling Data Synchronization11.5. Synching an On-Premises Database with SQL Azure11.6. Data Sync Best Practices11.7. Conclusion
12. Performance Tuning
12.1. What's Different with SQL Azure12.1.1. Methods and Tools12.1.2. Coding Implications12.2. Tuning Techniques12.2.1. Dynamic Management Views12.2.2. Connection Pooling12.2.3. Execution Plans12.2.4. Indexing12.2.5. Indexed Views12.2.6. Stored Procedures12.2.7. Provider Statistics12.2.8. Application Design12.3. Conclusion
A. Houston
A.1. Launching HoustonA.2. Using Houston
B. SQL Azure Quick Reference
B.1. Supported T-SQLB.2. Partially Supported T-SQLB.3. Unsupported T-SQLB.4. Supported Data Types

Content preview from Pro SQL Azure

Chapter 12. Performance Tuning

Designing for high performance is becoming more important when using a database running in the cloud because development objectives tend to minimize roundtrips and the amount of data being returned. This chapter provides an overview of some of the most common tuning and troubleshooting techniques available in SQL Azure. Keep in mind that performance tuning is a very complex topic; as a result, this chapter can introduce only selected techniques.

The techniques presented are similar to the ones available in SQL Server, although some of the tools aren't supported in SQL Azure. Along the way, you walk through a few examples of how to improve the performance of a SQL statement and the steps required to tune it.

What's ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781430229612Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Pro SQL Azure

by Scott Klein, Herve Roggero

Chapter 12. Performance Tuning

What's ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.