Microsoft SQL Azure: Enterprise Application Development -- Table of Contents -- Microsoft SQL Azure: Enterprise Application Development -- Credits -- About the Author -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 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 -- SalesForce.com -- 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 -- 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 -- Server-level administration -- Managing logins -- Connecting to SQL Azure using new login -- Logins with server-level permissions -- 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 -- 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 -- 4. SQL Azure Tools -- Microsoft tools -- Visual Studio related -- VS2008 -- VS2010 -- SQLBulkCopy for Data Transfer -- SQL Server Integration Services -- SQL Server Reporting Services -- 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 -- Connect to SQL Azure from the DOS window -- Run queries using SQLCMD in SSMS -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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.