Pro SQL Database for Windows Azure

Authors: Scott Klein and Herve Roggero
Publisher: Apress, 2012
Pages: 290
ISBN: 978-1430243953
Aimed at: Developers wanting to work with Azure SQL database
Rating: 4.5
Reviewed by: Kay Ewbank

Writing a good app that uses a database is hard enough; doing the same thing in the cloud adds even more complexity and things to go wrong.

Pro SQL Database for Windows Azure is a good guide to making the move from Microsoft SQL Server to the SQL database that Microsoft makes available on its cloud platform.

The book opens with an introduction to cloud computing in general and Azure in particular, working through setting up your Azure account, creating an instance, configuring the firewall, and the other steps necessary to get you up and running. This type of material is normally a waste of space, but the combination of database and cloud makes it worth including. There’s a good little section on what you don’t get in an Azure SQL database, and other limitations.

 

Banner

 

Moving on, Klein and Roggero look at design considerations such as how high availability is managed, how throttling affects your app’s performance, and how to synchronize your data. This is a really good chapter, covering aspects of design you’re not likely to have encountered when working on a ‘normal’ database server.

Chapter 3 introduces security, and is the first place code appears in the book, with C# code showing how to encrypt string values, how to use hashing to check encrypted data has remained secure, and how to create and use a security certificate. Access control, authorization and the SQL database firewall take up the rest of the chapter. Chapter 4 looks at data migration and backup, and how to migrate your databases and data to Azure.

 

 

From Chapter 5 onward the book moves from admin tasks to everyday developer work, starting with a chapter on programming with SQL Database. This chapter still has a feel of admin type concerns, with code showing how to use ADO.NET to make connections to Azure databases, then how to use a data reader and a dataset. ODBC and sqlcmd get the same treatment before Klein and Roggero move on to more in-depth coverage of using WCF Data Services (what used to be called ADO.NET Data Services).

SQL Reporting gets its own chapter, covering the differences and similarities between SQL Reporting for Azure and SQL Server Reporting Services running on a local server, and showing how to use the cloud-based option from provisioning the server to creating and deploying reports . SQL Data Sync also gets a chapter, with good explanations of its role in bidirectional synchronization. The techniques of writing ASP.NET applications that use SQL Azure are next on the list, with code to create an ASP.NET app that runs in the cloud. There’s an interesting chapter on designing for high performance, looking at how you build a shard library and use it, with sections on multitenant systems and vertical partition shards, all done using standard techniques. Federations, which are SQL Azure’s specific implementation of the concepts behind sharding, are covered next, with good descriptions of how they deal with sharding, their advantages, and code for creating and using them. I thought these two chapters were the most useful in the book. Chapters on performance tuning and Azure Mobile Services round off the book.

This is a good introduction to the nuts and bolts of using SQL Database for Azure. If you know how to use SQL Server, you will soon be able to get up and running with its cloud-based cousin and have a good understanding of doing it well.

 

Banner


Pro Windows Phone 7 Development

Author: Rob Cameron
Publisher: Apress
Pages: 464
ISBN: 978-1430232193
Aimed at: "Pro" WP7 developers
Rating: 3
Pros: Some interesting material covered
Cons: Poor organisation, overlong examples, level varies
Reviewed by: Ian Elliot

 

What do you expect a book called "Pro" to tell you about?



Professional Node.js

Author: Pedro Teixeira
Publisher: Wrox
Pages: 408
ISBN: 978-1118185469
Audience: Intermediate JavaScript programmers
Rating: 3.5
Reviewer: Ian Elliot

Node.js seems to be growing in importance and we need some good book to tell us what it is all about. Is Professional Node.js the one you need?


More Reviews

Last Updated ( Tuesday, 14 May 2013 )
 
 

   
RSS feed of book reviews only
I Programmer Book Reviews
RSS feed of all content
I Programmer Book Reviews
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.