Microsoft® Azure™ SQL Database Step by Step

Book description

Your hands-on guide to Azure SQL Database fundamentals

Expand your expertise—and teach yourself the fundamentals of Microsoft Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques.

Discover how to:

  • Perform Azure setup and configuration

  • Explore design and security considerations

  • Use programming and reporting services

  • Migrate data

  • Backup and sync data

  • Work with scalability and high performance

  • Understand the differences between SQL Server and Microsoft Azure SQL Database

  • 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

    Product information

    • Title: Microsoft® Azure™ SQL Database Step by Step
    • Author(s): Leonard G. Lobel, Eric D. Boyd
    • Release date: July 2014
    • Publisher(s): Microsoft Press
    • ISBN: 9780133989380