New MSDEV videos show you how to use SQL Azure Data Sync to synchronize data between the cloud and on premises and between cloud data centers. In addition, two other videos show how to manage the SQL Azure firewall and configure SQL Azure for security.
Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases video introduces you to Data Sync Service for SQL Azure, that extends on SQL Azure Data Sync tools’ ability to provide symmetry between SQL Server and SQL Azure where data changes at either location are bi-directionally synchronized between on-premises and the cloud:
Extending SQL Server Data to Cloud using SQL Azure Data Sync video show you how SQL Azure Data Sync enables on-premises SQL Server data to be easily shared with SQL Azure allowing you to extend your on-premises data to begin creating new cloud-based apps. Using SQL Azure Data sync’s bi-directional data synchronization support, changes made either on SQL Server or SQL Azure are automatically synchronized back and forth:
How Do I: Configure SQL Azure Security? video introduces security within SQL Azure. The creation of Logins, Databases and Users is discussed and demonstrated. The views sys.sql_logins and sys.databases which allow the display of logins and databases from the master database are also discussed:
How Do I: Manage SQL Azure Firewall rules? video discusses the IP firewall rules inherent in SQL Azure, and demonstrates connecting to a SQL Azure database using SQL Server Management Studio 2008: