Posts

Showing posts with the label Jeremy Boyd

Building Applications on SQL Azure

These are my notes from Jeremy Boyd's presentation at TechEd NZ '09. These notes are pointers for finding out additional information and as such do not give full details of any particular areas of SQL Azure. Initial services coming with SQL Azure - RDBMS, Data Sync, Data Hub Down the road they will add more services such as Reporting Services and Analysis Services Databases limited to 10GB each SQL Azure is not SQL Data Services - they are two different things. SQL Data Services no longer exists and the tasks it was achieving are now part of Windows Azure. SQL Azure has a familiar SQL relational model Virtual DB server Auto HA and fault tolerance Friction-free scaling Self provisioning Provisioning model: Create an account, add a server, add a database, connect & play OR you can create via SSMS All standard T-SQL language minus a lot of DBA stuff When connecting ignore the error message - it's irrelevant and doesn't stop you connecting. All tables MUST have a c