Pro SQL Database for Windows Azure

1. Front Matter

   Pages i-xxvii

   PDF

2. Getting Started with SQL Database

   • Scott Klein, Herve Roggero

   Pages 1-22

3. Design Considerations

   • Scott Klein, Herve Roggero

   Pages 23-43

4. Security

   • Scott Klein, Herve Roggero

   Pages 45-66

5. Data Migration and Backup Strategies

   • Scott Klein, Herve Roggero

   Pages 67-98

6. Programming with SQL Database

   • Scott Klein, Herve Roggero

   Pages 99-123

7. SQL Reporting

   • Scott Klein, Herve Roggero

   Pages 125-142

8. SQL Data Sync

   • Scott Klein, Herve Roggero

   Pages 143-164

9. Windows Azure and ASP.NET

   • Scott Klein, Herve Roggero

   Pages 165-181

10. Designing for High Performance

    • Scott Klein, Herve Roggero

    Pages 183-206

11. Federations

    • Scott Klein, Herve Roggero

    Pages 207-218

12. Performance Tuning

    • Scott Klein, Herve Roggero

    Pages 219-240

13. Windows Azure Mobile Services

    • Scott Klein, Herve Roggero

    Pages 241-255

14. Back Matter

    Pages 257-290

    PDF

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft’s worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime.

SQL Azure is ideally suited for startups, who can benefit from instant access to a robust and secure web-accessible database platform for use in rapidly deploying new products to market. SQL Azure is also ideal for small and mid-sized businesses, giving them the same ability to deploy SQL Server as any large enterprise, but without the management overhead. Even large enterprises find SQL Azure useful in creating failover environments, development environments, extra capacity to handle surges in demand, and more.

Pro SQL Database for Windows Azure covers the very latest in Microsoft’s fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You’ll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You’ll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You’ll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton.

• Shows how to use SQL Azure from classic Windows applications, ASP.NET and Windows Communication Foundation
• Covers management, performance, scalability, and troubleshooting
• Addresses the all-important issue of securing your data
• Helps you properly design for high-performance in a cloud environment
• Helps you adopt the new Federations feature in SQL Azure

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.

Policies and ethics