SQL Azure
SQL Azure is Microsoft's RDBMS for the cloud. Because it is based on SQL Server, developers can apply what they know about SQL Server to SQL Azure immediately. SQL Azure is its own product and, over time, developers will discover that they need to know some extra items in order to be fully productive on this platform. This module covers much of what developers need to know: basic development, security models, integration with existing platforms, and pricing. It covers new features like the SQL Azure OData service as well.
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
SQL Azure Overview |
|
00:29:16 | |
|
Introduction
|
|
01:06 | |
|
What is SQL Azure?
|
|
05:03 | |
|
SQL Azure Architecture
|
|
02:19 | |
|
SQL Azure Security
|
|
01:44 | |
|
Demo: Provision and Connect to Database
|
|
13:09 | |
|
Comparing SQL Azure to SQL Server
|
|
04:57 | |
|
Summary
|
|
00:58 | |
SQL Azure Pricing |
|
00:09:19 | |
|
Introduction
|
|
01:35 | |
|
SQL Azure Pricing
|
|
02:44 | |
|
Understanding the SQL Azure Bill
|
|
01:30 | |
|
Demo: A Real SQL Azure Bill
|
|
03:09 | |
|
Summary
|
|
00:21 | |
Developing for SQL Azure |
|
00:35:38 | |
|
Introduction
|
|
01:07 | |
|
Candidate Applications
|
|
03:29 | |
|
SQL Azure Scenarios/Taxonomy
|
|
02:18 | |
|
Deployment Architecture
|
|
01:18 | |
|
Microsoft Tooling
|
|
00:55 | |
|
Demo: Using the SQL Azure Tools
|
|
07:56 | |
|
Development Choices
|
|
01:00 | |
|
Demo: Developing with SQL Azure
|
|
08:48 | |
|
Connection Termination
|
|
06:07 | |
|
Summary
|
|
02:40 | |
Migrating Data to SQL Azure |
|
00:35:33 | |
|
Introduction
|
|
01:13 | |
|
What can move?
|
|
02:17 | |
|
Demo: Migrating Access with the Access SSMA
|
|
07:28 | |
|
Migrating Databases
|
|
01:51 | |
|
Preparing for the move
|
|
01:40 | |
|
Migration Tasks
|
|
01:56 | |
|
Planning your migration
|
|
01:20 | |
|
Common Hurdles
|
|
01:33 | |
|
Tools
|
|
01:28 | |
|
Demo: Migrating a database with existing tools.
|
|
12:56 | |
|
Summary
|
|
01:51 | |
Using the SQL Azure OData Service |
|
00:30:53 | |
|
Introduction
|
|
01:21 | |
|
OData overview
|
|
03:00 | |
|
OData Query String Parameters
|
|
01:59 | |
|
$filter Expressions
|
|
02:37 | |
|
Supporting JSON
|
|
01:20 | |
|
SQL Azure and OData
|
|
01:18 | |
|
Demo: Expose SQL Azure over OData
|
|
07:26 | |
|
Demo: Consuming OData from JavaScript
|
|
04:04 | |
|
Demo: Consuming OData from Windows Phone 7
|
|
06:35 | |
|
Summary
|
|
01:13 | |
SQL Azure and Business Intelligence |
|
00:18:01 | |
|
Introduction
|
|
01:44 | |
|
What is Business Intelligence?
|
|
02:16 | |
|
Tools to Analyze Data
|
|
01:12 | |
|
Demo: Using SSRS with SQL Azure
|
|
05:03 | |
|
Demo: Using Excel with SQL Azure
|
|
06:55 | |
|
Summary
|
|
00:51 |
SQL Azure Overview