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 What you'll learn * Create and manage SQL Database for Windows Azure databases * Access SQL Azure from WinForms, ASP.NET, Reporting Services, and more * Optimize database design for Azure's distributed cloud platform * Share data between databases using SQL Database's Data Synch Service * Secure data from intrusion and unauthorized access * Learn strategies for data migration and backup Who this book is for Pro SQL Database for Windows Azure, 2nd Edition is aimed at developers and database administrators desiring instant access to a fully-capable SQL Server database environment without the pain of sorting out and managing the physical infrastructure. Table of ContentsChapter 1: Getting Started with SQL Database Chapter 2: Design Considerations Chapter 3: Security Chapter 4: Data Migration and Backup Strategies Chapter 5: Programming with SQL Database Chapter 6: SQL Reporting Chapter 7: SQL Data Sync Chapter 8: Windows Azure and ASP.NET Chapter 9: Designing for High Performance Chapter 10: Federations Chapter 11: Performance Tuning Chapter 12: Windows Azure Mobile Services Appendix A: SQL Database Management Portal Appendix B: SQL Database Quick Reference

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 dataWhat you'll learn* Create and manage SQL Azure Databases* Access SQL Azure from Silverlight, WinForms, ASP.NET, Reporting Services, and more* Optimize your distributed database design for scalability and performance* Partition your databases and write multithreaded queries for parallel execution* Understand how to take advantage of Microsoft's S+S strategy to save money and increase agility with hybrid cloud computing* Use ADO.NET and LINQ in .NET 4 with Visual Studio 2010* Pinpoint where SQL Azure makes things simpler than running on-premise databases* Understand when to apply new technologies to optimize performance when running your database in the cloudWho this book is for Pro SQL Azure is for DBAs and developers who want to use SQL Server in the cloud, and especially for those who want to go deeper and learn important strategies and techniques for effective cloud computing. Table of Contents* Getting Started with SQL Azure* SQL Azure Design Considerations* Setting up and Configuring your SQL Azure Environment* Security* Data Migration and Backup Strategy* Programming SQL Azure* Reporting Services* Using Entity Framework, REST, and ADO.NET Data Services with SQL Azure* Windows Azure and ASP.NET* Designing for High Performance* Synchronization Services* Performance Tuning* Appendix A-Resources* Appendix B-Supported Features