
Understand, Design, Migrate, Manage, and Monitor Azure SQL Databases.
Event Information
Event description
Description
This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to:
- Understand how Azure SQL Database works
- Know the newest and most important features to manage your Azure SQL Database
- Design scalable architectures
- Design Disaster Recovery plans
- Manage security on your Azure SQL Database
- Monitor and troubleshoot Azure SQL Database
- Face a migration project
Agenda
Module 1: Introduction to Azure SQL Database
This module provides an overview of the basic concepts of Azure SQL Database and will cover:
- Architecture, service tiers and DTUs
- Create and connect to Azure SQL Database
- Difference between SQL Server on Azure VM and Azure SQL Database
- How to choose between IaaS and PaaS solution
Module 2: Azure SQL Database Administration
This module covers the different Azure SQL Database administration tasks like:
- Scaling up or down your database
- Scheduling jobs
- Commonly used DMVs and supported features in Azure SQL Database
- Various Disaster Recovery options
Module 3: Manage Security
This module covers the different options to manage security for an Azure SQL Database like:
- Configuring Active Directory security
- Always Encrypted
- Row Level Security and Dynamic Data Masking
- Auditing and threat detection
Module 4: Monitoring and Troubleshooting
This module covers the different tools for monitoring the performance of your database like:
- Query Store
- Extended Events
- Index Advisor
- Configure alerts to enable proactive monitoring
Module 5: Database Migration
This module covers the different strategies to migrate your on-premises database to Azure SQL Database and will cover:
- How to analyze the database for compatibility issues
- The different migration methods
======================================================
Bio Jose Manuel Jurado
José Manuel Jurado currently works as SQL Support Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 15+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events as SQL Saturday, SQLBits, SQL Nexus, TechReady, DotNetConference and Azure BootCamp. In the past, he worked as Project Manager for large Global Retail Company for more than 10 years developing projects using different Microsoft Technologies
José Manuel Jurado currently works as SQL Support Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 15+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events as SQL Saturday, SQLBits, SQL Nexus, TechReady, DotNetConference and Azure BootCamp. In the past, he worked as Project Manager for large Global Retail Company for more than 10 years developing projects using different Microsoft Technologies
Bio Raghda Abd Aldeen
Raghda is a Microsoft Azure DB Support Engineer, who Researches, diagnoses, troubleshoots and identifies solutions to resolve customers issues, and she is a speaker for internal events at Microsoft. Raghda has been working with Azure Services since 2014. Previously, Raghda was specialized on Azure Internet of things services, Where she developed an IOT SOLUTION FOR RFID DATA and was featured as solution of the week by MICROSOFT UK on 2015.
Raghda is a Microsoft Azure DB Support Engineer, who Researches, diagnoses, troubleshoots and identifies solutions to resolve customers issues, and she is a speaker for internal events at Microsoft. Raghda has been working with Azure Services since 2014. Previously, Raghda was specialized on Azure Internet of things services, Where she developed an IOT SOLUTION FOR RFID DATA and was featured as solution of the week by MICROSOFT UK on 2015.
FAQs
What are my transportation/parking options for getting to and from the event?
There are public bus/ferry rides to the venue. There is also a public parking lot just outside.
How can I contact the organizer with any questions?
Email to mikael@wedham.com or Phone +46(0)706-990852
Do I have to bring my printed ticket to the event?
No, pdf or screendump of barcode/qrcode is enough.
Is my registration fee or ticket transferrable?
Yes, however there can be only one attendant per ticket.
Is it ok if the name on my ticket or registration doesn't match the person who attends?
Yes, as long as only one person enters per ticket.