Microsoft® Azure™ SQL Database Step by Step

Table of contents

1. Title Page
2. Copyright Page
3. Dedication Page
4. Contents at a glance
5. Contents
6. Introduction
   1. Who should read this book
   2. This book might not be for you if...
   3. Organization of this book
   4. Conventions and features in this book
   5. System requirements
   6. Downloads: SQL Server Express Edition
   7. Downloads: Code samples on the book’s companion website
   8. Acknowledgments
   9. Errata, updates, & book support
   10. We want to hear from you
   11. Stay in touch
7. Chapter 1. Getting started with Microsoft Azure SQL Database
   1. Cloud computing: The concept
   2. Getting signed up for SQL Database
   3. Creating a server
   4. Creating a SQL Database instance
   5. Summary
8. Chapter 2. Configuration and pricing
   1. Using the Microsoft Azure platform management portal
   2. Using SQL Server Management Studio
   3. Using PowerShell
   4. Budgeting for SQL Database
   5. Summary
9. Chapter 3. Differences between SQL Server and Microsoft Azure SQL Database
   1. Size limitations
   2. Connection limitations
   3. Unsupported features
   4. Summary
10. Chapter 4. Migrating databases
    1. Making the case for data migration
    2. Migrating data using Transact-SQL scripts
    3. SQL Data-Tier Applications
    4. SQL Server Bulk Copy (bcp)
    5. SQL Database Migration Wizard
    6. Summary
11. Chapter 5. Security and backup
    1. Addressing major cloud concerns
    2. Securing SQL Database
    3. Backing up SQL Database
    4. Summary
12. Chapter 6. Cloud reporting
    1. Creating a SQL Server Reporting services virtual machine
    2. Creating the sample database
    3. Using Report Builder
    4. Using Visual Studio Report Server projects
    5. Implementing report security
    6. Shutting down the SSRS virtual machine
    7. Summary
13. Chapter 7. Microsoft Azure SQL Data Sync
    1. Getting to know SQL Data Sync
    2. Creating the SQL Database
    3. Working with SQL Data Sync
    4. Pitfalls and best practices
    5. Summary
14. Chapter 8. Designing and tuning for scalability and high performance
    1. Achieving high performance in the cloud
    2. Creating a RESTful web API
    3. Managing SQL Database connections
    4. Reducing network latency
    5. Effectively using SQL Database
    6. Optimizing queries
    7. Scaling up SQL Database
    8. Partitioning data
    9. Summary
15. Chapter 9. Monitoring and management
    1. Creating the sample database
    2. Monitoring
    3. Programming the Service Management REST API
    4. Summary
16. Chapter 10. Building cloud solutions
    1. Creating the SQL Database
    2. Extending the SQL Database
    3. Creating the data access layer
    4. Creating the website
    5. Creating the ASP.NET Web API services
    6. Creating the Windows Phone application
    7. Summary
17. Index
18. About the authors
19. Inside Back Cover