Transcript Introduction to SQL Azure Databases

SQL Azure Database is
Get started quickly
Ready to get started?
Server
Server defined
Provision servers interactively
Automate server provisioning
Database
Use familiar technologies
Differences in comparison to SQL Server
Unsupported SQL Server features
Database
Thin client database development
Rich client database development
Database
Data-tier Application Framework (DAC Fx)
How to get the latest DAC Fx
Database
Interactive approach for dacpac v1 and v2
Interactive approach for bacpac v2
Upgrading a dacpac or bacpac
Your Database
Server identity and access control
Database identity and access control
Your Application
Connecting to SQL Azure
<connectionStrings>
<addname="AdventureWorks"connectionString=
"Data Source=[server].database.windows.net;
Integrated Security=False;
Initial Catalog=ProductsDb;
User Id=[login];
Password=[password];
Encrypt=true;"
providerName="System.Data.SqlClient"/>
</connectionStrings>
Special considerations