You are previewing Microsoft SQL Azure: Enterprise Application Development.
O'Reilly logo
Microsoft SQL Azure: Enterprise Application Development

Book Description

Moving business applications and data to the cloud can be a smooth operation when you use this practical guide. Learn to make the most of SQL Azure and acquire the knowledge to build enterprise-ready applications.

  • 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

  • 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

    Table of Contents

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