Windows Azure Data Platform Technical Immersion Day

2013

TL; DR

This full day seminar provides an immersive, marketing-free, deep dive for experienced architects who want to learn architectural and implementation best practices that have been developed from implementing real world large distributed Azure systems.

Session Details

This full day seminar provides an immersive, marketing-free, deep dive for experienced architects who want to learn architectural and implementation best practices that have been developed from implementing real world large distributed Azure systems that leverage characteristics and features of the Windows Azure platform. This session will be presented by members of the Azure Customer Advisory Team and the Data Platform Azure Product Team.
We will cover a number of use cases, including migration of traditional applications to the cloud, and more modern green field application scenarios and needs with a specific flavor and focus on data platform technologies. We’ll show you how to analyze where a cloud platform can really make the difference. These considerations will include arguments like architecting for costs, increasing deployment and upgrade flexibility, reduce operating complexity in real application scenarios.
The experiences we share and learnings we present to you have been acquired working with the most complex customer projects to date. The practices we share are immediately applicable to design and implement solutions of every scale. Across the entire seminar we’ll consider different angles, like achieving scalability at every application layer, addressing reliability and resiliency requirements, and operating, monitoring and troubleshooting cloud solutions at scale. You will learn about pros and cons of different options for storing data in cloud solutions, like Azure SQL Database or SQL Server running in Windows Azure Virtual Machines, and how to optimize data access layers that need to interact with these different data sources using caching and other approaches.
Agenda:
- Architecting scalable and reliable Azure data-centric solutions (1.5h)
- Implementing a cloud service data access layer (1.5h)
- Azure Data Platform technologies: performance and scalability comparison (1.5h)
- Design for operations: solution monitoring and troubleshooting (1.5h)

3 things you'll get out of this session

Ewan Fairweather's previous sessions

Building Big - In The Cloud

The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

High Scale OLTP - LL From SQLCAT Performance Labs

In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores

Silvano Coriani's previous sessions

From the Classroom to the Boardroom – Azure SQL DB through Demos

Join us to learn about Azure SQL DB exciting features in form of demos, yes you heard it right, no slide only Demos.

Building SaaS solutions on Azure SQL Database

Azure SQL Database is powering some of the largest SaaS solutions on the planet sporting millions of tenants. It does that through a combination of multiple multi-tenancy models that support different requirements and use cases. from few users to millions. In this session, we'll dig deeper into some examples of real-world architectures implemented by 1st party and 3rd party solution providers like Microsoft Dynamics 365 and others, and see how these can be applied to your own scenarios.

Practical Azure SQL for the Modern Developer

Come learn how to take advantage of everything Azure SQL can offer to a developer

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

Conor Cunningham's previous sessions

Why is Batch Mode Fast?

Conor will explain details of how SQL/Synapse makes queries go very, very fast.

Query Store: A Retrospective

Conor will discuss the history and evolution of the query store design and how it has changed query performance troubleshooting

Modern Database Design – Do’s and Don’ts

The goal of the talk will be to show you how to choose among the various storage technologies that exist when building your next application.

Adaptive query processing in SQL databases

Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.

GDPR-How did the Microsoft SQL team approach it

GDPR is affecting any business that stores data including the SQL Server product group. Come and listen to how the Microsoft SQL Team approached the GDPR challenge for the SQL and SQL Azure business.

Graph Data Processing in SQL Server, the “Relationship” db

A look at how the Graph engine introduced with SQL Server 2017 and Azure SQL Database can help you generate insights from your highly connected data

Whats new in Azure SQL DB and SQL engine

Attend this session to get an overview of the wide array of significant changes and investments with Azure SQL Database, including parity with SQL Server 2016 and Intelligent database capabilities.

Adaptive QP Enhancements in SQL Server and SQL Azure

The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.

SQL Server/Azure Engineering Model

The SQL Team delivers value monthly to both cloud and on-premises environments. This is not easy to do. This talk will explain the model, telemetry and security

Query Store: New Query Tuning Feature For SQL Server & Azure

Query Store is a new feature that is coming to SQL Azure and SQLServer. It aims to greatly simplify the process of getting insight intothe performance of your application. Come learn how the SQL team is going to make your life awhole lot easier!

Keynote - Architecting Large-Scale Solutions on Azure

While there are many similarities between SQL Server and SQL Azure, there are different kinds of applications that are easier to build in one or the other. One of the major differences relates to how to build an application that “scales”. This presentation will provide an introduction into the difference between scale-up (SQL Server) and scale-out (SQL Azure) architectures and give you a primer on how you can build a large, Internet-facing service that can scale to arbitrarily large sizes on commodity hardware. This talk is targeted at SQL Server practitioners to give them a working knowledge of how the two platforms differ based on Microsoft’s experiences with its largest Software-as-a-Service (SaaS) customers running on SQL Azure.

Saturday Keynote: Inside SQL Server 2012’s ColumnStore Index

This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster. Covering details of the storage and execution model, how this model interacts with modern CPUs to deliver significant performance benefits.

Distributed Query Deep Dive

This talk will cover how the distributed query feature in SQL Server works, end-to-end. Topics include the query model, metadata, query optimization, execution, distributed transactions, and scale-out scenarios via Distributed Partitioned Views(DPV)

DW Design With The Product Team

This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.

Update Queries-Deep Dive

Ever wanted to know exactly what is happening underneath the covers in your queries. Let me show you.