Jacksonville SQL Server Users Group

Welcome to the Jacksonville SQL Server Users Group

The Jacksonville SQL Server Users Group (JSSUG) was founded by Brian Knight in January 2003, creating a community for database developers and administrators in the Jacksonville area. The goal of JSSUG is to share knowledge, best practices, and network. Today, it is a community focusing on development, administration, and business intelligence. Free meetings are open to the public every month. Meetings include presentations, technology announcements, local job opportunities, and quick brainstorming/guidance for users experiencing difficulty. An after event for additional networking, shop talk, and users desiring more detailed guidance for specific challenges is available following the meeting.

Welcome

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:20 - General Q&A session & Announcements 6:20 - 7:30 - Presentation(s) 7:30 - 7:45 - Door prizes and Question & Answer session 7:45-Whenever - Social time

 **NEW Location**Address:

Keiser University 
6430 Southpoint Pkwy #100
Jacksonville, FL 32216

If you have any questions, please feel free to email: Jeff Taylor at jeff@reviewmydb.com. 

Next Meeting

Friday,

May

03

PreCon: Move your DB to the Cloud: Migrate, Manage, and Monitor Azure SQL DB

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

Speakers:

Bio Roberto Cavalcanti

Roberto Cavalcanti is a Mission Critical Premier Field Engineer for Microsoft's customers with the most critical systems running in the Azure Data Platform. He is a database specialist with 20+ years of experience. He is passionate about SQL Server support, focusing on working to improve Microsoft database products, and on helping users make the most of their Azure Database implementations. Roberto has written many articles about SQL Server/Azure SQL DB for MSDN/TechNet, SQL Magazine, and has been a speaker in events such as TechReady, Microsoft Insights/TechEd, SQL Saturday. He has delivered SQL trainings in multiple countries in the Americas, and in Europe. Roberto is based on the Microsoft Support Center in Las Colinas, Texas, USA.
https://www.linkedin.com/in/robertocavalcanti

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, 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. https://www.linkedin.com/in/jose-manuel-jurado-diaz-5a586014/

**Special Notes**

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Click Here for Map https://bit.ly/2NE9H41

Featured Presentation:

PreCon: Move your DB to the Cloud: Migrate, Manage, and Monitor Azure SQL DB

Roberto Cavalcanti, Senior Support Escalation Engineer Microsoft

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

About Roberto:
Roberto Cavalcanti is a Sr. Support Escalation Engineer with the Microsoft CSS Azure SQL Database support team. He is a database specialist with over 20 years working in the database industry. Since joining Microsoft CSS SQL Escalation team in 2008, Roberto has been passionate about customer support. He has been supporting Azure SQL Database since 2010, when it was still called SQL Azure. Roberto has written many articles about Azure SQL Database for MSDN/TechNet, SQL Magazine, and has been a speaker in internal and external events such as TechReady, Microsoft Insights/TechEd, and has delivered SQL training to many Microsoft SQL Support Engineers in multiple countries.

PreCon: Move your DB to the Cloud: Migrate, Manage, and Monitor Azure SQL DB

Jose Manuel Jurado Diaz, Support Escalation Engineer - SME SQL Database Microsoft

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

About Jose Manuel:
José Manuel Jurado currently works as SQL Support Escalation Engineer and Subject Master 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, SQL Nexus, SQLBits, SQL Server Konferenze, 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.

  

click to search
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids