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

Format:

Book

Author/Creator:

Krishnaswamy, Jayaram.

Language:

English

Subjects (All):

SQL server.

Cloud computing.

Application software--Development.

Application software.

Physical Description:

1 online resource (583 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, U.K. : Packt, 2010.

Language Note:

English

Biography/History:

Krishnaswamy Jayaram: Jayaram Krishnaswamy studied at the Indian Institute of Science in Bangalore India and Madras University in India and taught at the Indian Institute of Technology in Madras. He went to Japan on a Japanese Ministry of Education Research scholarship to complete his PhD in Electrical Engineering from Nagoya University. He was a Post-Doctoral Fellow at Sydney University in Australia; a Government of India Senior Scientific Officer at the Indian Institute of Science in Bangalore and Indian Institute of Technology at Kanpur; a Visiting Scientist at the Eindhoven Institute of Technology in the Netherlands; a visiting Professor of Physics at the Federal University in Brazil; an Associate Research Scientist at a government laboratory in Sao Jose dos Campos in Sao Paulo, Brazil; a visiting scientist at the National Research Council in Ottawa, Canada before coming to USA in 1985. He has also taught and worked at the Colorado State University in Fort Collins and North Carolina State University in Raleigh, North Carolina. He worked with Northrop Grumman Corporation on a number of projects related to high energy electron accelerators and Free Electron Lasers. These projects were undertaken at the Brookhaven National Laboratory in Long Island and in the Physics Department at Princeton University. He has over 80 publications in refereed and non-refereed publications and 8 issued patents. He is fluent in Japanese and Portuguese and lives in Honolulu, Hawaii, USA. He has been working in IT-related fields since 1997. He was once a Microsoft Certified Trainer in Networking and a Siebel Certified developer. He has worked with several IT related companies, such as the Butler International in their Siebel practice, with several IBM sub-contractors and smaller companies. Presently he is active in writing technical articles in the IT field to many online sites such as http: //CodeProject. com, http: //APSFree. com, http: //DevShed. com, http: //DevArticles. com, http: //OfficeUsers. org, http: //ASPAlliance. com, Egghead Cafe, http: //SSWUG. org, Packt Article Network, http: //databasedev. co. uk, http: //cimaware. com, and many others. Between 2006 and 2010 he wrote more than 400 articles mostly related to database and web related technologies covering Microsoft, Oracle, Sybase, ColdFusion, Sun, and other vendor products. He has written four books all published by Packt related to Microsoft Database and Application Development: SQL Server Integration Services Using Visual Studio 2005, Learning SQL Server Reporting Services 2008, Microsoft SQL Azure; Enterprise Application Development, and Microsoft Visual Studio Lightswitch Business Application Development. He regularly writes for his four blogs on Blogger; http: //Hodentek. blogspot. com, http: //HodentekHelp. blogspot. com, http: //HodentekMobile. blogspot. com, and http: //HodentekMSSS. blogspot. com. He received the 2011 Microsoft Community Contributor award. Contact Jayaram Krishnaswamy

Summary:

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

Contents:

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

Notes:

Includes index.

Includes bibliographical references and index.

ISBN:

9786612937910

9781282937918

128293791X

9781849680813

1849680817

OCLC:

797915927