Welcome to SQLSaturday Jacksonville!
SQL Saturday is a training event for SQL Server and data professionals who want to learn how to elevate their careers to the next level. This is the 12th year of SQL Saturday in Jacksonville and will be held on May 4, 2019. Admittance to this event is free, all costs are covered by donations and sponsorship. Please register soon as seating is limited, and let friends and colleagues know about the event.
Why: It is a great opportunity to learn from SQL Server Jedi's, SQL Server Jedi Masters, Microsoft MVPs, SQL Server authors, and professionals who have been through and can relate to the obstacles you have day to day. This one day training event is unlike any other providing free food, training and networking.
When: Saturday, May 4, 2019
Where: University of North Florida Campus, Main Campus, 1 UNF Drive, Jacksonville, FL 32224. Building 51 and Building 3. Parking in Garage 38 near the baseball fields.
SQL Jedi Clinic
We will have a room setup for you to ask our SQL Jedi Master's for assistance with any current challenges you might be having. Look for this image posted at the door.
**PLEASE NOTE THAT WE WILL BE USING 2 BUILDINGS!**
**BUILDING 51 IS THE SAME AS LAST TWO YEARS BUT DIFFERENT BUILDING THAN PREVIOUS YEARS**
Click here for an Interactive map of the UNF campus with Building 51 highlighted
**SOME CLASSES WILL BE IN BUILDING 3**
Click here for an Interactive map of the UNF campus with Building 3 highlighted
So what are you waiting for? Register today to be a part of SQL Saturday! #820!
Friday, May 3rd Precons - $150 Each
Register Here: https://www.meetup.com/jaxssug/events/255976109/
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
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
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.
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/
Power BI, PowerApps, and Microsoft Flow have made for an amazing trio of business ready applications. Citizen Developers are now able to use PowerApps to design line of business applications faster than ever with this “low code” tool. Then leveraging Microsoft Flow users can control business workflows and automate tasks. Then last but certainly not least Power BI can be implemented for reporting and analytics. In this hand-on full day session you will get a taste of all of what the Power Platform has to offer.
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Mitchell Pearson - For the last six years Mitchell has worked in the capacity as a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell recently authored the Power BI Quick Start Book and can be found blogging at mitchellpearson.com. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things Business Intelligence and Tabletop games.
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 kiosk map and pay by plate instructions.