eBook - ePub
Microsoft SQL Azure Enterprise Application Development
Jayaram Krishnaswamy
This is a test
Share book
- 420 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Microsoft SQL Azure Enterprise Application Development
Jayaram Krishnaswamy
Book details
Book preview
Table of contents
Citations
About This Book
Each chapter starts with a general overview reviewing the software architecture related information or the underpinning programming concepts followed by an example of working with specific examples. This is then followed by a description of the specific software used in the chapter. The topics that require you to write code are fully explained using annotations and the code is presented in both VB and C# (in most cases). If you are a.Net developer, an architect, or a DBA who wants to develop enterprise applications and projects and extend your on-site skills with SQL Azure, then this book is for you. This book does not assume experience in Windows Azure or SQL Azure, nor is a high level of competency in SQL Server or the.NET Framework and associated technology required. However, a basic understanding of Visual Studio, C#, VB, SQL Servers, XML, web and WCF is required. If you decide to work with SQL Azure, then this book will provide you with the most up to date and practical information.
Frequently asked questions
How do I cancel my subscription?
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlegoâs features. The only differences are the price and subscription period: With the annual plan youâll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weâve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Microsoft SQL Azure Enterprise Application Development an online PDF/ePUB?
Yes, you can access Microsoft SQL Azure Enterprise Application Development by Jayaram Krishnaswamy in PDF and/or ePUB format, as well as other popular books in Informatik & Informationstechnologie. We have over one million books available in our catalogue for you to explore.
Information
Microsoft SQL Azure: Enterprise Application Development
Table of Contents
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 cloud
Types 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 services
Exercise 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 administration
Setting 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 Server
Setting 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
Creating tables and indexes
Add, remove columns, and constraints
SQL Azure templates
Basic monitoring of the database
Summary
3. Working with SQL Azure Databases from Visual Studio 2008
SQL Azure architecture
Application access to SQL Azure
TDS and SQL Azure
Microsoft data access technologies
Connecting to the database
Data providers
Connection string
Commands
Using connection string builders
Accessing SQL Azure data using the Server Management Objects (SMO)
Accessing SQL Azure from Visual Studio 2010 Express
The easy way to connect to SQL Azure using ADO.NET 3.5, ODBC, and OLE DB
Using ADO.NET to connect to the SQL Azure database
Using ODBC to connect to the SQL Azure Database
Using OLE DB to connect to the SQL Azure database
Using ADO.NET to connect to a SQL Azure database in C#
Application using a SqlConnectionStringBuilder to connect to SQL Azure
Testing the effectiveness of SqlConnectionStringBuilder
Demo using an SqlConnectionStringBuilder to connect to SQL Azure in C#
Using SQL Server Management Objects (SMO) to connect to SQL Azure
SQL Server Management Objects (SMO) to connect to SQL Azure in C#
Creating database objects using ADO.NET
Using connection string information in application settings
Inserting connection string information to the application settings file
Connect to the database on the server using the settings
Create a test database and drop it
Connect to the master database and get the Session ID
Create a table if it does not exist and populate the table
Creating database objects with SQL Server API
Summary
4. SQL Azure Tools
Microsoft tools
Visual Studio related
VS2008
VS2010
SQLBulkCopy for Data Transfer
SQL Server Integration Services
SQL Server Reporting Services
Entity Framework Provider
SQL Server related
SQL Server Management Studio
Import/Export Wizard
SyncFramework and SQL Azure
MySQL to SQL Azure Migration
Scripting support for SQL Azure
SQLCMD
Connect to SQL Azure from the DOS window
Run queries using SQLCMD in SSMS
BCP Utility
IIS7 Database Manager
OData and SQL Azure
Brand new tools
Third-party tools
SQL Azure Migration Wizard
Installing the SQL Azure Migration Wizard
SQL Azure Explorer
Installing the SQLAzure2010 Add-in
Exploring the SQL Azure in VS2010
Running a query in VS2010
SQL Azure Manager Ă la community
Installing and running the SQL Azure Manager
Cerebrata©
DBArtisan©
Explore SQL Azure with DBArtisan
Red Gate (SQL Compare©)
ToadSoft©
SQL Azure and...