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

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

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Krishnaswamy, Jayaram
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Pub., ©2010.
Temas:
SQL server.
SQL server
Database management.
Relational databases.
Cloud computing.
Bases de données > Gestion.
Bases de données relationnelles.
Infonuagique.
COMPUTERS > Database Management > General.
Cloud computing
Database management
Relational databases
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares