Klein / Roggero Pro SQL Azure

1. ed
ISBN: 978-1-4302-2962-9
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 312 Seiten

SQL Azure represents Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name 'Oslo'). Pro SQL Azure introduces you to this new platform, showing you how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from Silverlight, ASP.NET, WinForms, and from SQL Reporting Services. You'll also understand how to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. Shows how to use SQL Azure from Silverlight, ASP.NET, and more Covers management, scalability, and troubleshooting Addresses the all-important issue of securing your data

Scott Klein is a Microsoft SQL Server 'Most Valuable Professional' and independent consultant specializing in SQL Server performance and business intelligence. Scott is the author of several books, including Professional SQL Server 2005 XML, Professional LINQ, and Pro ADO.NET 4.0 Entity Framework. He was a contributing author to Pro SQL Server 2008 Relational Database Design and Implementation, as well as to the Microsoft SQL Server 2008 Bible. Scott has written many articles for the SQL Server Standard magazine. He holds the MCDBA, MCSD, and MCSE certifications. He is heavily involved in the south Florida community, running two SQL Server user groups and the South Florida SQL Saturday events. Scott also speaks frequently at user groups across south Florida. Scott has nearly 20 years working with SQL Server and consulting in small to enterprise-size environments.

Autoren/Hrsg.

Klein, Scott

Roggero, Herve

Inhaltsverzeichnis

1;Pro SQL Azure;1
2;Copyright Page;2
3;Dedication Page;3
4;Contents at a Glance;4
5;Contents;5
6;About the Authors;13
7;About the Technical Reviewer;14
8;Acknowledgments;15
9;CHAPTER 1 Getting Started with SQL Azure ;16
9.1;Introduction to Cloud Computing;16
9.1.1;Who Is Doing What in the Cloud?;16
9.1.2;Typical Cloud Services;17
9.2;Discovering the Microsoft Azure Platform;17
9.2.1;Why Microsoft Azure?;18
9.2.2;About Geographic Locations;19
9.2.3;Storing Data in Azure;20
9.3;SQL Azure Primer;21
9.3.1;Registering for Azure;22
9.3.2;Creating a Database in SQL Azure;23
9.3.3;Configuring the Firewall;24
9.3.4;Connecting with SQL Server Management Studio;26
9.3.5;Creating Logins and Users;30
9.3.6;Assigning Access Rights;32
9.3.7;Understanding Billing for SQL Azure;33
9.4;Limitations in SQL Azure;34
9.4.1;Security;34
9.4.2;Backups;35
9.4.3;Objects;35
9.4.4;Miscellaneous;36
9.4.5;Drivers and Protocols;36
9.5;Conclusion;37
10;CHAPTER 2 Design Considerations;38
10.1;Design Factors;38
10.1.1;Offsite Storage;38
10.1.2;High Availability;38
10.1.3;Performance;39
10.1.4;SQL Data Sync Framework;41
10.1.5;Direct vs. Serviced Connections;41
10.1.6;Pricing;42
10.1.7;Security;43
10.1.8;Review of Design Factors;43
10.2;Design Patterns;44
10.2.1;Direct Connection;44
10.2.2;Smart Branching;44
10.2.3;Transparent Branching;45
10.2.4;Sharding;45
10.2.5;Offloading;50
10.2.6;Aggregation;51
10.2.7;Mirroring;51
10.3;Combining Patterns;52
10.3.1;Transparent Branching + RWS;52
10.3.2;Cascading Aggregation;53
10.4;Sample Design: Application SLA Monitoring;54
10.4.1;Pre-Azure Application Architecture;54
10.4.2;Azure Implementation;55
10.5;Other Considerations;56
10.5.1;Blob Data Stores;56
10.5.2;Edge Data Caching;56
10.5.3;Data Encryption;57
10.6;Conclusion;58
11;CHAPTER 3 Setting Up and Configuring;59
11.1;Creating Your Azure Account;59
11.2;Managing Your Azure Projects;61
11.3;Azure Server Administration;62
11.3.1;Server Information;63
11.3.2;Firewall Settings;64
11.3.3;Databases;65
11.4;Creating Databases, Logins, and Users;68
11.4.1;Databases;69
11.4.2;Logins and Users;69
11.5;Connecting to a SQL Azure Database;70
11.5.1;Connecting Using ADO.NET;71
11.5.2;Connecting from the Entity Framework;72
11.6;Conclusion;77
12;CHAPTER 4 Security;79
12.1;Overview;79
12.1.1;Confidentiality;79
12.1.2;Integrity;80
12.1.3;Availability;80
12.2;Securing Your Data;82
12.2.1;Encryption;83
12.2.2;Hashing;85
12.2.3;Certificates;89
12.3;Access Control;93
12.3.1;Authentication (AUTHN);93
12.3.2;Authorization (AUTHZ);94
12.3.3;Firewall;98
12.4;Compliance;98
12.5;Conclusion;99
13;CHAPTER 5 Data Migration and Backup Strategies;100
13.1;Migrating Databases and Data to SQL Azure;100
13.1.1;Generate and Publish Scripts Wizard;101
13.1.2;SQL Server Integration Services;111
13.1.3;Bcp;122
13.2;SQL Azure Backup Strategies;126
13.2.1;Copying a Database;126
13.2.2;Knowing When a Copy Is Complete;127
13.2.3;Automating a Database Copy;127
13.2.4;Maintaining a Backup History;127
13.3;Conclusion;128
14;CHAPTER 6 Programming with SQL Azure;129
14.1;Application Deployment Factors;129
14.1.1;On-Premise Application;130
14.1.2;Azure-Hosted Application;130
14.1.3;Which to Choose?;131
14.2;Connecting to SQL Azure;131
14.2.1;ADO.NET;132
14.2.2;ODBC;136
14.2.3;Sqlcmd;138
14.3;WCF Data Services;144
14.3.1;Creating a Data Service;144
14.3.2;Connecting the Service to the Model;145
14.3.3;Creating the Client Application;147
14.3.4;Creating the User Interface;149
14.3.5;Running the Application;151
14.4;Record Navigation in WCF Data Services;152
14.4.1;Disabling Internet Explorer’s Feed Reading View;153
14.4.2;Viewing the Final Results;154
14.5;Azure Programming Considerations;157
14.6;Conclusion;158
15;CHAPTER 7 OData with SQL Azure;159
15.1;OData Overview;159
15.1.1;OData Producers;160
15.1.2;OData Consumers;163
15.2;Enabling OData on an Azure Database;164
15.2.1;Getting Started at SQL Azure Labs;164
15.2.2;Understanding Anonymous Access;166
15.2.3;Understanding the Access Control Service;166
15.2.4;Implementing Security Best Practices;167
15.3;Viewing OData-Enabled SQL Azure Data;167
15.4;Viewing Data through an OData Consumer;169
15.5;Building Two OData Consumer Applications;170
15.5.1;Simple Demo App;171
15.5.2;Windows Mobile 7 Application;172
15.6;Conclusion;178
16;CHAPTER 8 Reporting Services with SQL Azure;180
16.1;Starting a SQL Azure–Based Report;180
16.2;Creating the SQL Azure Data Source;182
16.3;Creating the Report Design;187
16.4;Deploying the Report;188
16.5;Creating a Subreport;189
16.5.1;Adding the Subreport to the Main Report;192
16.6;Conclusion;194
17;CHAPTER 9 Windows Azure and ASP.NET;195
17.1;Creating a Windows Azure Service;195
17.2;Creating a Windows Azure Project;200
17.2.1;Configuring Your Development Environment;200
17.2.2;Creating Your First Visual Studio Cloud Project;200
17.2.3;Connecting a GridView to SQL Azure;206
17.3;Deploying an ASP.NET Application in Windows Azure;208
17.4;Conclusion;214
18;CHAPTER 10 Designing for High Performance;215
18.1;General Performance Concepts;215
18.1.1;Chatty vs. Chunky;215
18.1.2;Lazy Loading;215
18.1.3;Caching;216
18.1.4;Asynchronous User Interface;216
18.1.5;Parallel Processing;217
18.1.6;Shards;217
18.1.7;Coding Strategies Summary;217
18.2;Building a Shard;218
18.2.1;Designing the Shard Library Object;219
18.2.2;Managing Database Connections;220
18.2.3;Reading Using the Shard;223
18.2.4;Caching;225
18.2.5;Updating and Deleting Records in the Shard;226
18.2.6;Adding Records to the Shard;228
18.3;Managing a Shard;230
18.3.1;Managing Exceptions;230
18.3.2;Managing Performance;232
18.3.3;Working with Partial Shards;235
18.3.4;Managing Transaction Consistency;236
18.3.5;Managing Foreign Key Constraints;236
18.4;Creating Vertical Partition Shards;237
18.5;Conclusion;238
19;CHAPTER 11 SQL Azure Data Sync Services;239
19.1;Understanding the Data Sync Service;239
19.1.1;Why the Need?;239
19.1.2;The Basic Scenario;240
19.2;Configuring Synchronization;241
19.2.1;Agreeing to the Terms of Service;241
19.2.2;Creating a Sync Group;241
19.2.3;Defining the Hub and Member Databases;244
19.2.4;Selecting Tables to be Synchronized;245
19.2.5;Modifying a Sync Group;246
19.3;Manually Synchronizing;246
19.3.1;Looking at the Database Changes;247
19.3.2;Looking at the Synchronized Data;249
19.4;Scheduling Data Synchronization;250
19.5;Synching an On-Premises Database with SQL Azure;250
19.6;Data Sync Best Practices;252
19.7;Conclusion;253
20;CHAPTER 12 Performance Tuning;254
20.1;What’s Different with SQL Azure;254
20.1.1;Methods and Tools;254
20.1.2;Coding Implications;255
20.2;Tuning Techniques;255
20.2.1;Dynamic Management Views;256
20.2.2;Connection Pooling;259
20.2.3;Execution Plans;259
20.2.4;Indexing;263
20.2.5;Indexed Views;267
20.2.6;Stored Procedures;268
20.2.7;Provider Statistics;269
20.2.8;Application Design;271
20.3;Conclusion;271
21;APPENDIX A Houston;272
21.1;Launching Houston;272
21.2;Using Houston;273
22;APPENDIX B SQL Azure Quick Reference;276
22.1;Supported T-SQL;276
22.2;Partially Supported T-SQL;278
22.3;Unsupported T-SQL;281
22.4;Supported Data Types;282
23;Index;285