Pro SQL Azure
- 4h
- Herve Roggero, Scott Klein
- Apress
- 2010
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
What 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 cloud
About the Authors
Scott Klein is a Microsoft SQL Server MVP 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.
Herve Roggero is the founder of Pyn Logic, a company focusing on advanced SQL Server security and performance. Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. Over the last 15 years, Herve has worked in the Education, Financial, Health Care, Management Consulting and Database Security sectors. In his last full time position, Herve was a Director of Software Development at a health care company in Florida. He has been freelancing as a .NET and SQL Server Architect since 2007. Herve is a member of the ISSA. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He also holds an MBA from Indiana University. Herve is heavily involved with the South Florida SQL Server community, speaks at multiple venues, and runs SQL Saturday events in South Florida.
In this Book
-
Getting Started with SQL Azure
-
Design Considerations
-
Setting Up and Configuring
-
Security
-
Data Migration and Backup Strategies
-
Programming with SQL Azure
-
OData with SQL Azure
-
Reporting Services with SQL Azure
-
Windows Azure and ASP.NET
-
Designing for High Performance
-
SQL Azure Data Sync Services
-
Performance Tuning