Amazon cover image
Image from Amazon.com

Microsoft SQL Azure : enterprise application development : build enterprise-ready applications and projects with SQL Azure / Jayaram Krishnaswamy.

By: Material type: TextTextPublication details: Birmingham : Packt Pub., ©2010.Description: 1 online resource (398 pages) : illustrationsContent type:
  • text
Media type:
  • computer
Carrier type:
  • online resource
ISBN:
  • 9781849680813
  • 1849680817
  • 1849680809
  • 9781849680806
  • 128293791X
  • 9781282937918
  • 9786612937910
  • 6612937912
Other title:
  • SQL Azure
Subject(s): Additional physical formats: Print version:: Microsoft SQL Azure.DDC classification:
  • 005.75/85 22
LOC classification:
  • QA76.9.D3 K75 2010eb
Online resources:
Contents:
Credits -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe -- Free Access for Packt account holders -- 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 servicesInfrastructure 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 PlatformSigning 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 levelRole 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 firewallCreating 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.
Summary: Build enterprise-ready applications and projects with Microsoft SQL Azure using this book and eBook.
Holdings
Item type Current library Collection Call number Status Date due Barcode Item holds
eBook eBook e-Library EBSCO Computers Available
Total holds: 0

Includes bibliographical references and index.

Print version record.

Credits -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe -- Free Access for Packt account holders -- 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 servicesInfrastructure 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 PlatformSigning 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 levelRole 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 firewallCreating 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.

Build enterprise-ready applications and projects with Microsoft SQL Azure using this book and eBook.

English.

Added to collection customer.56279.3

Powered by Koha