OakLeaf Systems: “Cloud Computing with the Windows Azure Platform” Short-Form Table of Contents and SQL Azure Chapters

Sunday, November 01, 2009

“Cloud Computing with the Windows Azure Platform” Short-Form Table of Contents and SQL Azure Chapters

Updated 11/1/2009: Moved live sample projects from the Quincy, WA (US North West) to San Antonio (US South Central) data center, forthcoming .NET Services changes.

Updated 9/27/2009: Added “Live Windows Azure Demonstration Projects by Chapter” section

The Wiley/Wrox Web site’s page for my Cloud Computing with the Windows Azure Platform Title that released on 9/21/2008 offers a long-form table of contents (ToC) with all headings. If that’s more than you want to know about the book at this point, here’s the short-form TOC that has part and chapter titles only:

Part I: Introducing the Windows Azure Platform

Chapter 1: Surveying the Role of Cloud Computing, p. 3
Chapter 2: Understanding Windows Azure Platform Architecture, p. 19
Chapter 3: Analyzing the Windows Azure Operating System, p. 4
Chapter 4: Scaling Azure Table and Blob Storage, p. 63

Part II: Taking Advantage of Cloud Services in the Enterprise

Chapter 5: Minimizing Risk When Moving to Azure Cloud Services, p. 115
Chapter 6: Authenticating and Authorizing Service Users, p. 151
Chapter 7: Optimizing the Scalability and Performance of Azure Tables, p. 187
Chapter 8: Messaging with Azure Queues, p. 209

Part III: Tackling Advanced Azure Services Techniques

Chapter 9: Authenticating Users with .NET Access Control Services, p. 239
Chapter 10: Interconnecting Services with the .NET Service Bus, p. 273 *
Chapter 11: Exploring .NET Service Bus Queues and Routers*, p. 295 *

Update 11/1/2009: * Chapters 10 and 11 will be affected by the dramatic transmogrification of the .NET Service Bus Queues and Routers that will occur in the .NET Services November CTP. See The .NET Services November 2009 CTP Breaking Changes Announcement and Scheduled Maintenance post of 10/30/2009.

Part IV: Working with SQL Azure Services (Online Only)

Chapter 12: Managing SQL Azure Accounts, Databases, and DataHubs
Chapter 13: Exploiting SQL Azure Database’s Relational Features

Index

Live Windows Azure Demonstration Projects by Chapter

Instructions and sample code for creating and running the following live demonstration projects are contained in the chapter indicated:

Chapter 4: OakLeaf Systems Azure Table Services Sample Project *
Chapter 4: OakLeaf Systems Azure Blob Services Test Harness *
Chapter 5: OakLeaf Systems Azure Table Test Harness (Secure Sockets Layer, Personally Identifiable Data Encrypted with AES-128) *
Chapter 6: OakLeaf Systems Azure Table Test Harness: HTTPS, Encrypted, with ASP.NET Membership Provider
Chapter 7: OakLeaf Systems Azure Test Harness with Windows Live ID Authentication
Chapter 8: OakLeaf Systems: Photo Gallery Azure Queue Test Harness

Update 11/1/2009: * Moved from Quincy, WA to San Antonio, TX data center.

These sample projects will remain live as long as Microsoft continues to subsidize Windows Azure demonstration accounts. See my Lobbying Microsoft for Azure Compute, Storage and Bandwidth Billing Thresholds for Developers post of 9/8/2008.

Detailed TOCs for Online Chapters 12 and 13

Chapter 12: Managing SQL Azure Accounts, Databases, and DataHubs*

Tracking SSDS’s Migration to a Relational Database
Reviewing Current SQL Azure Database Documentation and Resources
Obtaining and Redeeming an Azure Invitation Token for an SADB CTP
Creating a User Database
Connecting to SADB Master and User Databases with SSMS 2008 [Express]
Using the sqlcmd Utility with SADB
Comparing SADB with SQL Server 2008 R2 Databases
Summary

* Details of and new code samples for synchronization and DataHubs will be updated on line when the .NET Services or Sync Framework team releases them.

Chapter 13: Exploiting SQL Azure Database’s Relational Features

Creating and Populating SADB Databases
Generating the Northwind Sample Database in SADB from the instnwind.sql Script
Using SSIS to Populate a local AdventureWorksLT2008 Database from SADB
Migrating Schemas and Data from the On-Premises AdventureWorksLT2008 Database to SQL Azure
- Using SSMS to Migrate Schemas and Data
- Creating and Populating tables with the SQL Azure Migration Wizard
Using the Bulk Copy Process to Populate SADB Tables*
Populating Tables with the INSERT … BULK Command*
Sharding Tables to Overcome Database Size Limits
Creating SADB Logins and Users, and Assigning Roles
[Querying Sharded SADB Data with SSMS]*
Summary

* Details for BCP, INSERT … BULK, and SELECT queries against sharded data will be updated when the SQL Azure team implements the features or patterns & practices provides “Best Practices” details for testing.

I’ll add a thread to the book’s Programmer-to-Programmer (P2P) forum when the online chapters are ready to download.

Chapters 12 and 13 PDF files should be available for downloading shortly. Chapter 13 sample code is included in the current sample code download. (Chapter 12’s examples use files from MSDN and the chapter doesn’t have sample code.)

Update 11/1/2009: Sample code in *.zip format and Chapters 12 and 13 can be downloaded as *.doc Office Word files from here now. They will be updated after PDC 2009 and chapters converted to *.pdc format.