[This article was contributed by the SQL Azure team.]
DAT209 Migrating Applications to Microsoft SQL Azure
Are you looking to migrate your on-premise applications and database from MySql or other RDBMs to SQL Azure? Or are you simply focused on the easiest ways to get your SQL Server database up to SQL Azure? Then, this session is for you. Chris Hewitt, David Robinson cover two fundamental areas in this session: application data access tier and the database schema+data. In Part 1, they dive into application data-access tier, covering common migration issues as well as best practices that will help make your data-access tier more resilient in the cloud and on SQL Azure. In Part 2, the focus is on database migration. They go through migrating schema and data, taking a look at tools and techniques for efficient transfer of schema through Management Studio and Data-Tier Application (DAC). Then, they discover efficient ways of moving small and large data into SQL Azure through tools like SSIS and BCP. We close the session with a glimpse into what is in store in future for easing migration of applications into SQL Azure.
Meeting Room 8 Wednesday, August 25 09:45 - 11:00
COS220 SQL Azure Performance in a Multi-Tenant Environment
Microsoft SQL Azure presents unique opportunities and challenges with regards to database performance. While query performance is the key discussion in traditional, on-premise database deployments, David Robinson shows you that factors such as network latency and multi-tenant effects also need to be considered in the Cloud. He offer some tips to resolve or mitigate related performance problems. He also digs deep into the inner workings of how SQL Azure manages resources and balances workload in a massive Cloud environment. The elastic access to additional physical resource in the Cloud offers new opportunities to achieve better database performance in a cost effective manner, an emerging pattern not available in the on-premise world. He shows you some numbers that quantify the potential benefits.
Arena 1B Wednesday, August 25 15:30 - 16:45
David’s sessions for TechEd New Zealand are not finalized yet, I will repost when I have them.