1.

Record Nr.

UNINA9910458804003321

Autore

Krishnaswamy Jayaram

Titolo

Microsoft SQL Azure [[electronic resource] ] : enterprise application development ; build enterprise-ready applications and projects with SQL Azure / / Jayaram Krishnaswamy

Pubbl/distr/stampa

Birmingham, U.K., : Packt, 2010

ISBN

1-282-93791-X

9786612937910

1-84968-081-7

Descrizione fisica

1 online resource (583 p.)

Disciplina

005.1

005.4

005.4476

Soggetti

Cloud computing

Application software - Development

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di bibliografia

Includes bibliographical references and index.

Nota di contenuto

Microsoft SQL Azure: Enterprise Application Development; 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 cloudTypes 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 servicesExercise 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 administrationSetting 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 ServerSetting 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

Sommario/riassunto

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