Description |
1 online resource (398 pages) : illustrations |
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 |
Bibliography |
Includes bibliographical references and index |
Notes |
English |
|
Print version record |
SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server fast |
Subject |
Database management.
|
|
Relational databases.
|
|
Cloud computing.
|
|
COMPUTERS -- Database Management -- General.
|
|
Cloud computing
|
|
Database management
|
|
Relational databases
|
Form |
Electronic book
|
ISBN |
9781849680813 |
|
1849680817 |
|
1849680809 |
|
9781849680806 |
|
128293791X |
|
9781282937918 |
|
9786612937910 |
|
6612937912 |
|