From the CTO of RADSense Software

Alin Irimie

Subscribe to Alin Irimie: eMailAlertsEmail Alerts
Get Alin Irimie via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Blog Feed Post

Free Introduction to Microsoft SQL Azure

Microsoft Learning has a training clinic for Microsoft SQL Azure with lots of useful information. If you’re a newbie or even an experimented Windows Azure developer this is a required reading. This two-hour clinic explores the capabilities of Introduction to Microsoft SQL Azure and covers topics from understanding the SQL Azure Platform to how to achieve scale with SQL Azure. Users completing this collection should have a basic understanding of SQL Server and relational database systems.

Understanding the SQL Azure Platform

  • Windows Azure Platform
  • Extending the SQL Data Platform to the Cloud
  • What SQL Azure Is
  • What SQL Azure Is Not
  • When to Use SQL Azure vs Azure Tables
  • SQL Azure Provisioning Model
  • Provisioning a SQL Azure Account and Connecting to SQL Azure
  • SQL Azure Architecture
  • Creating a SQL Azure Database
  • High Availability and Recovery

Designing Applications for SQL Azure

  • Logical vs Physical Administration
  • Creating Objects in SQL Azure
  • Compatibility Goals
  • T-SQL
  • T-SQL Support
  • SQL Azure Security Model
  • Managing Logins and Security
  • Connection Model
  • Managing Connections in SQL Azure Applications
  • Managing Connections in a SQL Azure Application

Migrating Applications to SQL Azure

  • Migrating Database Schemas to SQL Azure
  • Migrating Database Schema to SQL Azure
  • Migrating Application Data to SQL Azure
  • SQL Server Integration Services
  • Working with BCP
  • Migrating Application Data to SQL Azure Using SSIS
  • Choosing an Appropriate Local Caching Strategy
  • Using Local Caching with SQL Azure Data Sync
  • PHP Support for SQL Azure

Achieving Scale with SQL Azure

  • Why Scale Out?
  • Database Size
  • Performance Considerations
  • Accessing Usage Data from System Views
  • Scale out Considerations
  • Throttling Considerations
  • Sharding Basics
  • Example Sharded Database Model
  • Working with a Sharded Database

Related posts:

Read the original blog entry...

More Stories By Alin Irimie

Alin Irimie is a software engineer - architect, designer, and developer with over 10 years experience in various languages and technologies. Currently he is Messaging Security Manager at Sunbelt Software, a security company. He is also the CTO of RADSense Software, a software consulting company. He has expertise in Microsoft technologies such as .NET Framework, ASP.NET, AJAX, SQL Server, C#, C++, Ruby On Rails, Cloud computing (Amazon and Windows Azure),and he also blogs about cloud technologies here.