Learn the fundamentals of Windows Azure SQL Database administration using just the Windows Azure Management Portal and the instructions in this tutorial.
Use this tutorial to learn how to syncronize databases using SQL Data Sync in the Windows Azure Management Portal.
How to guides
In this guide, you'll step through logical server creation and configuration. In the new Windows Azure (Preview) Management Portal, revised workflows let you create a database first, and then create a server. However in this guide, you'll create the server first. You might prefer this approach if you have existing SQL Server databases that you want to upload.
Use Management Studio to connect to a logical server on Windows Azure. This step requires you to have SQL Server Management Studio version 2008 R2 or 2012.
In the following step, you'll use Management Studio to connect to a logical server on Windows Azure. This step requires you to have SQL Server Management Studio version 2008 R2 or 2012.
See how to quickly add logins and users using two scripts. For the first script, you'll connect to master and run a script that creates logins. The second script assigns database user permissions.
Use Data Management Views (DMVs) to monitor data capacity, query problems, and current connections.
On Windows Azure, database scalability is synonymous with scale out, where a workload is redistributed across multiple commodity servers in a data center. Scale out is a strategy for addressing problems with data capacity or performance.
The guidance describes how to use SQL Server Management Studio to manage SQL Database logical servers and databases in Windows Azure.