Pro SQL Azure (Paperback, 1st ed.)

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