Microsoft SQL Azure Enterprise Application Development

Microsoft SQL Azure Enterprise Application Development
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Develop large scale enterprise applications using Microsoft SQL Azure
  • Understand how to use the various third party programs such as DB Artisan, RedGate, ToadSoft etc developed for SQL Azure
  • Master the exhaustive Data migration and Data Synchronization aspects of SQL Azure.
  • Includes SQL Azure projects in incubation and more recent developments including all 2010 updates


Book Details

Language : English
Paperback : 420 pages [ 235mm x 191mm ]
Release Date : December 2010
ISBN : 1849680809
ISBN 13 : 9781849680806
Author(s) : Jayaram Krishnaswamy
Topics and Technologies : All Books, Application Development, Microsoft Servers, Cloud, Enterprise, Java, Microsoft, PHP, Microsoft SQL Server

Table of Contents

Chapter 1: Cloud Computing and Microsoft Azure Services Platform
Chapter 2: SQL Azure Services
Chapter 3: Working with SQL Azure Databases from Visual Studio 2008
Chapter 4: SQL Azure Tools
Chapter 5: Populating SQL Azure Databases
Chapter 6: SSIS and SSRS Applications Using SQL Azure
Chapter 7: Working with Windows Azure Hosting
Chapter 8: Database Applications on Windows Azure Platform Accessing SQL Server Databases
Chapter 9: Synchronizing SQL Azure
Chapter 10: Recent Developments
  • Chapter 1: Cloud Computing and Microsoft Azure Services Platform
    • What is cloud computing?
    • Why a business would like to move its business applications and data to the cloud
    • Types of cloud services
      • Infrastructure as a Service (IaaS)
      • Platform as a Service (PaaS)
      • Software as a Service (SaaS)
      • The hybrid cloud
    • How cloud computing is implemented with examples of some major cloud computing vendors
      • Amazon Web Services
      • Google
      • Microsoft
    • Windows Azure
      • Azure platform details
      • Platform components
        • Windows Azure
        • Compute: Windows Azure Hosting Service
        • Windows Azure storage
        • SQL Azure
        • Azure AppFabric
      • System requirements
      • Hardware and software required
    • Getting started with Azure Platform and accessing services
      • Exercise 1.1: Purchasing a subscription on Windows Azure Platform
        • Signing up for a Windows Live ID
        • Purchasing a subscription
        • Activating the service
      • Exercise 1.2: Accessing Windows Azure Portal
        • Verifying status of account and browsing to Windows Azure Portal
        • Creating an account and reviewing the portal
        • Creating a Windows Azure Service
    • Summary
    • Chapter 2: SQL Azure Services
      • Overview of SQL Azure Services
        • Infrastructure features
        • How different is SQL Azure from SQL Server?
        • SQL Azure provisioning
          • After accessing the portal
        • Server-level administration
          • Setting up firewall rules
        • Administering at the database level
          • Role of SQL Azure database administrator
          • SQL Azure databases
          • User administration and logins
        • Migrating databases to SQL Azure
        • Monitoring SQL Azure databases
        • Data synchronization and SQL Azure
        • Application access to SQL Azure
        • Troubleshooting
        • T-SQL support in SQL Azure
      • Accessing SQL Azure Services from the portal
        • First time access to SQL Azure from the portal
        • Creating a SQL Azure Server
        • Setting up a firewall
      • Creating a user database and setting up a firewall
        • Creating a user database in the portal
        • Setting up firewall rules
          • IP ranges of Microsoft Azure data centers
      • Connecting to SQL Azure from SQL Server Management Studio
        • Connecting to SQL Azure from SSMS
      • Working with SQL Azure from SQL Server Management Studio
        • Creating queries
        • General queries
          • Querying date and time
          • Create and display firewall rules
          • Find database usage and bandwidth usage
      • Basic administration of the database objects
        • Creating logins, users, and roles
        • Creating, altering, and dropping databases
        • Creating tables and indexes
        • Add, remove columns, and constraints
        • SQL Azure templates
      • Basic monitoring of the database
      • Summary
      • Chapter 3: Working with SQL Azure Databases from Visual Studio 2008
        • SQL Azure architecture
          • Application access to SQL Azure
          • TDS and SQL Azure
        • Microsoft data access technologies
          • Connecting to the database
            • Data providers
            • Connection string
            • Commands
            • Using connection string builders
          • Accessing SQL Azure data using the Server Management Objects (SMO)
          • Accessing SQL Azure from Visual Studio 2010 Express
        • The easy way to connect to SQL Azure using ADO.NET 3.5, ODBC, and OLE DB
          • Using ADO.NET to connect to the SQL Azure Database
          • Using ODBC to connect to the SQL Azure Database
          • Using OLE DB to connect to the SQL Azure Database
          • Using ADO.NET to connect to a SQL Azure Database in C#
        • Application using a SqlConnectionStringBuilder to connect to SQL Azure
          • Testing the effectiveness of SqlConnectionStringBuilder
          • Demo using an SqlConnectionStringBuilder to connect to SQL Azure in C#
        • Using SQL Server Management Objects (SMO) to connect to SQL Azure
          • SQL Server Management Objects (SMO) to connect to SQL Azure in C#
        • Creating database objects using ADO.NET
          • Using connection string information in application settings
            • Inserting connection string information to the application settings file
            • Connect to the database on the server using the settings
          • Create a test database and drop it
          • Connect to the master database and get the Session ID
          • Create a table if it does not exist and populate the table
        • Creating database objects with SQL Server API
        • Summary
        • Chapter 4: SQL Azure Tools
          • Microsoft tools
            • Visual Studio related
              • VS2008
              • VS2010
              • Entity Framework Provider
            • SQL Server related
              • SQL Server Management Studio
              • Import/Export Wizard
              • SyncFramework and SQL Azure
              • MySQL to SQL Azure Migration
              • Scripting support for SQL Azure
              • SQLCMD
              • BCP Utility
            • IIS7 Database Manager
            • OData and SQL Azure
          • Brand new tools
          • Third-party tools
            • SQL Azure Migration Wizard
              • Installing the SQL Azure Migration Wizard
            • SQL Azure Explorer
              • Installing the SQLAzure2010 Add-in
              • Exploring the SQL Azure in VS2010
              • Running a query in VS2010
            • SQL Azure Manager à la community
            • Installing and running the SQL Azure Manager
            • Cerebrata©
            • DBArtisan©
              • Explore SQL Azure with DBArtisan
            • Red Gate (SQL Compare©)
            • ToadSoft©
          • SQL Azure and OpenOffice
          • Summary
          • Chapter 5: Populating SQL Azure Databases
            • Sample databases used in this chapter
            • Using SQL Server Management Studio with scripts
              • Creating a script for the Northwind database
              • Running the scripted query in SQL Azure
              • Using the SQL Server Import and Export Wizard
              • Populating a table
              • Using the Import and Export Wizard
            • Using the SQL Server Migration wizard
            • Migration from MySQL to SQL Azure using SQL Server Migration Assistant 2008 for MySQL
            • Using SqlBulkCopy
              • Create a table in the destination server
              • Create a console application in VS2010
            • Summary
            • Chapter 6: SSIS and SSRS Applications Using SQL Azure
              • Merging sharded data
                • Splitting the data and uploading to SQL Azure
                • Merging data and loading an Access database
                • Merging columns from SQL Azure and SQL Server
                  • Sorting the outputs of the sources
                  • Porting output data from Merge Join to an MS Access database
              • Moving a MySQL database to SQL Azure database
                • Creating the package
                • Creating the source and destination connections
                • Creating the package
              • Creating a report using SQL Azure as data source
              • Accessing SQL Azure from Report Builder 3.0
              • Summary
              • Chapter 7: Working with Windows Azure Hosting
                • Tools needed to develop and host Cloud Service applications
                • Create and deploy an ASP.NET application
                  • Create a cloud project in Visual Studio 2008 SP1
                  • Test and debug in the development fabric
                  • Deploy the application to the cloud from the portal
                • Windows Azure ASP.NET site with forms authentication
                  • Create Windows Azure Cloud Service Project in Visual Studio 2008
                    • Add a Login control to the login.aspx page
                    • Add a control to login.aspx for new users to register
                    • Configure authentication mode
                    • Create Membership database in SQL Azure
                    • Configure the connection string
                    • Modify system.web to access the Membership Provider
                    • Modify the Default.aspx page
                  • Test and verify application authentication
                    • Register users
                    • Test authentication of registered users
                • Summary
                • Chapter 8: Database Applications on Windows Azure Platform Accessing SQL Server Databases
                  • Ground-to-Cloud access
                    • Using Linq to retrieve data from SQL Azure
                      • Create an ASP.NET web application project
                      • Creating a data context
                      • Create a new data connection
                      • Linq to SQL mapping
                      • Add a LinqDataSource control
                      • Display data with a GridView control
                      • Swap connection to SQL Azure
                  • Cloud-to-Cloud access
                    • Default template Cloud Service Project
                    • Displaying data from SQL Azure
                    • Deploying the application to the hosting site
                  • Cloud-to-Ground access
                    • Create a console project in Visual Studio
                    • Add an Entity Model Template and bind it to the database
                    • Configure the WCF Data Service
                    • WCF Data Service to use Windows Azure AppFabric
                      • Windows Azure AppFabric
                    • Hosting a ASP.NET application client for the above service
                  • Summary
                  • Chapter 9: Synchronizing SQL Azure
                    • Using SQL Azure Data Sync Tool
                      • Provisioning the database
                      • Running SQL Server Agent in SSMS
                      • Verifying bi-directional synchronization
                      • Conflict resolution
                    • Synchronizing SQL Azure data with SQL Server Compact
                      • Provisioning SQL Azure Data cache
                      • Reviewing SQL Server Compact database
                      • Build and run synchronization
                    • SQL Azure Data Sync Service
                    • Summary
                    • Chapter 10: Recent Developments
                      • SQL Azure updates
                      • SQL Azure security
                      • Using SQL Azure Firewall API
                      • SQL Azure with MS Access 2010
                        • Import a SQL Azure table into MS Access
                        • Creating a table in MS Access linked to SQL Azure
                        • Connecting to SQL Azure from MS Excel 2010
                      • OpenOffice Access to SQL Azure
                      • Accessing SQL Azure with non-.NET Framework languages
                        • Accessing SQL Azure with Java
                        • Accessing SQL Azure with PHP
                      • OData Service for SQL Azure
                      • Consuming SQL Azure data with PowerPivot
                      • SQL Azure with WebMatrix
                      • More third-party tools to SQL Azure
                        • Gem Query for SQL Azure developers
                      • Managing SQL Azure databases with the Houston Project (CTP1)
                      • Data Application Component and SQL Azure
                      • SQL Azure with Microsoft LightSwitch
                      • References
                      • Summary

                      Jayaram Krishnaswamy

                      Jayaram Krishnaswamy studied at the Indian Institute of Science in Bangalore India and Madras University in India and taught at the Indian Institute of Technology in Madras. He went to Japan on a Japanese Ministry of Education Research scholarship to complete his PhD in Electrical Engineering from Nagoya University. He was a Post-Doctoral Fellow at Sydney University in Australia; a Government of India Senior Scientific Officer at the Indian Institute of Science in Bangalore and Indian Institute of Technology at Kanpur; a Visiting Scientist at the Eindhoven Institute of Technology in the Netherlands; a visiting Professor of Physics at the Federal University in Brazil; an Associate Research Scientist at a government laboratory in São Jose dos Campos in São Paulo, Brazil; a visiting scientist at the National Research Council in Ottawa, Canada before coming to USA in 1985. He has also taught and worked at the Colorado State University in Fort Collins and North Carolina State University in Raleigh, North Carolina. He worked with Northrop Grumman Corporation on a number of projects related to high energy electron accelerators and Free Electron Lasers. These projects were undertaken at the Brookhaven National Laboratory in Long Island and in the Physics Department at Princeton University. He has over 80 publications in refereed and non-refereed publications and 8 issued patents. He is fluent in Japanese and Portuguese and lives in Honolulu, Hawaii, USA.

                      He has been working in IT-related fields since 1997. He was once a Microsoft Certified Trainer in Networking and a Siebel Certified developer. He has worked with several IT related companies, such as the Butler International in their Siebel practice, with several IBM sub-contractors and smaller companies. Presently he is active in writing technical articles in the IT field to many online sites such as,,,,,, Egghead Café,, Packt Article Network,,, and many others. Between 2006 and 2010 he wrote more than 400 articles mostly related to database and web related technologies covering Microsoft, Oracle, Sybase, ColdFusion, Sun, and other vendor products.

                      He has written four books all published by Packt related to Microsoft Database and Application Development: SQL Server Integration Services Using Visual Studio 2005, Learning SQL Server Reporting Services 2008, Microsoft SQL Azure; Enterprise Application Development, and Microsoft Visual Studio Lightswitch Business Application Development. He regularly writes for his four blogs on Blogger;,,, and He received the 2011 Microsoft Community Contributor award.

                      Contact Jayaram Krishnaswamy

                      Sorry, we don't have any reviews for this title yet.

                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Microsoft SQL Azure Enterprise Application Development +    Least Privilege Security for Windows 7, Vista and XP =
                      50% Off
                      the second eBook
                      Price for both: $45.60

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • An easy to understand briefing on Microsoft Windows Azure Platform Services
                      • Connect to SQL Azure using Microsoft SQL Server Management Studio
                      • Create and manipulate objects on SQL Azure using different tools
                      • Master the different types of Cloud offerings
                      • Access SQL Azure through best practices using Client and Server API’s in VB and C# and using hosted services with user authentication Windows Azure
                      • Learn how to populate the SQL Azure database using various techniques
                      • Create Business Intelligence Applications using SSIS and SSRS
                      • Synchronize databases on SQL Azure with on-site enterprise and compact SQL Servers
                      • Learn how to write an application to access on-site data from a cloud hosted service
                      • Get a comprehensive briefing on various updates that have been made to SQL Azure and the projects still in incubation
                      • Understand the future and evolving programs such as the Houston Project, OData Services, Sync Services, and more built to support SQL Azure and transform it into a global enterprise data platform


                      In Detail

                      SQL Azure is a database service in the cloud. Based on Microsoft’s Windows Azure platform, SQL Azure is well suited for web facing database applications. Are you interested in moving your business applications and data to the cloud but are not sure how to go about it? Look no further; this book covers all you ever wanted to know about taking your relational enterprise data to the cloud using SQL Azure.

                      This book will show you how to manage SQL Azure using various tools and also guide you in developing enterprise applications and business intelligence solutions. It will take you through migration and synchronization scenarios with a variety of tools, help you in working with Microsoft technology still in incubation, and in leveraging hybrid applications that exist partially in the cloud and partially on the ground.

                      This step-by-step tutorial begins by providing an overview of Cloud Computing, introducing you to the most significant Cloud Computing implementations. You will then learn the mechanics of signing up and obtaining an account on Microsoft Windows Azure and logging into the portal.

                      The book then dives deep into SQL Azure, showing you how to provision a SQL Azure Server, and how to create/delete databases as well as set up Firewall rules so that you can access SQL Azure from tools/Client programs. It is then followed by details of how to access SQL Azure using Client and Server APIs.

                      Other content includes, a comprehensive description of tools required to access SQL Azure and how to use them and how to populate and migrate SQL Azure databases using a variety of tools.

                      Finally, the book will detail with examples, data-centric applications that leverage a mix of on-site data and Cloud based data, how to synchronize data and extend the applicability of SQL Azure data by disconnected applications on mobile media, and synchronize services for globally distributed data. After covering the topics of services which are in production, the book will then cover future developments as well as a complete update to SQL Azure at the time of writing this book.

                      A step-by-step guide to design and build Enterprise applications for the cloud


                      Each chapter starts with a general overview reviewing the software architecture related information or the underpinning programming concepts followed by an example of working with specific examples. This is then followed by a description of the specific software used in the chapter. The topics that require you to write code are fully explained using annotations and the code is presented in both VB and C# (in most cases).

                      Who this book is for

                      If you are a .Net developer, an architect, or a DBA who wants to develop enterprise applications and projects and extend your on-site skills with SQL Azure, then this book is for you.

                      This book does not assume experience in Windows Azure or SQL Azure, nor is a high level of competency in SQL Server or the .NET Framework and associated technology required. However, a basic understanding of Visual Studio, C#, VB, SQL Servers, XML, web and WCF is required. If you decide to work with SQL Azure, then this book will provide you with the most up to date and practical information.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software