Step by step (Redmond, Wash.)

Includes index

ch. 1 Getting started with Microsoft Azure SQL Database -- Cloud computing: The concept -- Getting signed up for SQL Database -- Creating a server -- Creating a SQL Database instance -- Summary -- ch. 2 Configuration and pricing -- Using the Microsoft Azure platform management portal -- Using SQL Server Management Studio -- Using PowerShell -- Budgeting for SQL Database -- Summary -- ch. 3 Differences between SQL Server and Microsoft Azure SQL Database -- Size limitations -- Connection limitations -- Unsupported features -- Summary -- ch. 4 Migrating databases -- Making the case for data migration -- Migrating data using Transact-SQL scripts -- SQL Data-Tier Applications -- SQL Server Bulk Copy (bcp) -- SQL Database Migration Wizard -- Summary -- ch. 5 Security and backup -- Addressing major cloud concerns -- Securing SQL Database -- Backing up SQL Database -- Summary -- ch. 6 Cloud reporting -- Creating a SQL Server Reporting services virtual machine -- Creating the sample database -- Using Report Builder -- Using Visual Studio Report Server projects -- Implementing report security -- Shutting down the SSRS virtual machine -- Summary -- ch. 7 Microsoft-Azure SQL Data Sync -- Getting to know SQL Data Sync -- Creating the SQL Database -- Working with SQL Data Sync -- Pitfalls and best practices -- Summary -- ch. 8 Designing and tuning for scalability and high performance -- Achieving high performance in the cloud -- Creating a RESTful web API -- Managing SQL Database connections -- Reducing network latency -- Effectively using SQL Database -- Optimizing queries -- Scaling up SQL Database -- Partitioning data -- Summary -- ch. 9 Monitoring and management -- Creating the sample database -- Monitoring -- Programming the Service Management REST API -- Summary -- ch. 10 Building cloud solutions -- Creating the SQL Database -- Extending the SQL Database -- Creating the data access layer -- Creating the website -- Creating the ASP.NET Web API services -- Creating the Windows Phone application