Jacksonville SQL Saturday #1041 - May 6th, 2023

Jacksonville's 15th Annual SQL Saturday event includes two paid pre-con tracks and one FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their skill set in Business Intelligence, Analytics, and SQL Server. This event is hosted by Jacksonville SQL Server Users Group, a 501c3 non-profit organization.

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 15th year of SQL Saturday in Jacksonville, and it will be held on May 6, 2023. Admittance to this event is free, and all costs are covered by donations and sponsorship. Please register soon, as seating is limited, and let friends and colleagues know about the event. SQL Saturday Jacksonville is hosted by Jacksonville SQL Server Users Group, a 501c3 non profit organization.

Why: It is a great opportunity to learn from SQL Server Experts, 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.

You may place discounted reservations between 5/4/23 and 5/7/23 - All reservations must be booked before 4/20/23 for the discount.

Immerse yourself in this day-long workshop on SQL Server 2022 including presentations, hands-on exercises, and interactive Q&A taught by the Microsoft engineering team. You will learn all aspects of what is new in SQL Server 2022 including features for hybrid, built-in query intelligence, industry-proven engine, data virtualization and object storage, and new T-SQL capabilities. Attendees will need to bring their own laptop running Windows and will be provided instructions on software to be pre-installed including SQL Server 2022 Evaluation Edition and tools like SQL Server Management Studio. All attendees are expected to have a fundamental working knowledge of SQL Server including the T-SQL language, engine fundamentals, and use of tools like SQL Server Management Studio (SSMS). If you are looking to dive deep into “everything” SQL Server 2022 this workshop is for you.

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 29 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022 including Azure SQL. Bob is a well-known speaker on SQL Server and Azure SQL, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Azure Data Conference, Microsoft Build, Microsoft Inspire, Microsoft Ignite, PASS Summit, and many different events. You can also learn Azure SQL from him on the popular series https://aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, and Azure SQL Revealed available from Apress Media.

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. Kiosk map and pay-by-plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

In this all-day session we will be doing a deep dive into using Azure Synapse Analytics to create an analytics solution using the different components of Azure Synapse and visualize data with Power BI. Whether you choose to call it a Modern data warehouse or lakehouse or a datamart , the process to create it is the same, you need to gather the data from different data sources, analyze, transform, and develop a data model to provide user insight with the data by generating visuals on the data in Power BI.

The process involved sounds simple, but it involves a lot of different technology to create a robust scalable solution. This precon describes the components used to create a data lakehouse, perform serverless data analysis on flat files, develop code first data transformation pipelines, incorporate spark development, and implementing administration and security needed for a Power BI model with a Azure Synapse created backend.

By the end of the precon you will have the skills and code needed to implement this solution in your environment.

Agenda

• Introduction

• Developing a data lakehouse

• Analyzing the data

• Transformation layer

• Spark development

• Administration and security

• Data Analytics with Power BI

Recommend that attendees bring their laptops.

Ginger Grant is a Data Platform MVP who provides consulting services in advanced analytic solutions, including machine learning, data warehousing, and Power BI. She is an author of articles, books, and at DesertIsleSQL.com and uses her MCT to provide data platform training in topics such as Azure Synapse Analytics, Python and Azure Machine Learning.

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. Kiosk map and pay-by-plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

Immerse yourself in this day-long workshop on SQL Server 2022 including presentations, hands-on exercises, and interactive Q&A taught by the Microsoft engineering team. You will learn all aspects of what is new in SQL Server 2022 including features for hybrid, built-in query intelligence, industry-proven engine, data virtualization and object storage, and new T-SQL capabilities. Attendees will need to bring their own laptop running Windows and will be provided instructions on software to be pre-installed including SQL Server 2022 Evaluation Edition and tools like SQL Server Management Studio. All attendees are expected to have a fundamental working knowledge of SQL Server including the T-SQL language, engine fundamentals, and use of tools like SQL Server Management Studio (SSMS). If you are looking to dive deep into “everything” SQL Server 2022 this workshop is for you.

Bradley Ball is a Sr. FastTrack Azure Engineer on the Microsoft CXP Product Group. He is a current Microsoft MVP Reconnect member and former MVP. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, was the Data Platform Practice Manager for Pragmatic Works Consulting, and a Sr. Consultant for Microsoft Premier Support for Developers. He has presented at many SQL Saturdays, for PASS SSUG’s across the US from California to Puerto Rico to New Hampshire, SQL Rally, DevConnections, SQLBits 2015, TechReady 24, SQL Live 360 2011-2019, SQL Intersections 2019 - 2021, & the PASS Summit 2011-2015. He wrote Chapter 14 Page & Row Compression for PRO SQL Server 2012 Best Practices and he can be found blogging on http://www.sqlballs.com about anything else that interests him.

Neeraj Jhaveri is a Sr. Azure Fasttrack Engineer with expertise in providing Data, Analytics and AI solutions. Neeraj has MS in Computer Science from NYIT. He has about 20 years of experience in the IT industry as an Architect/Team Leader which includes experience

in Data warehousing, Business Intelligence & analytics areas. IT Leader managing and delivering Big Data & Business Intelligence solutions while promoting analytics driven culture.

He has worked closely with Client Managers, Solution Architects, Leads, Users and Development teams in successfully translating business requirements into specifications, planning and deliverable. Neeraj is one of the founding host of Tales from the Field youtube channel.

Daniel Taylor is a Microsoft Sr. Service Engineer, FastTrack for Azure and on the Azure Engineering CXP Team - I have presented a pre-con on Azure Dedicated Pools at SQL Saturday Jacksonville and was a speaker at many SQL Saturday events. My consulting role at Pragmatic Works provided me an opportunity to present the Airlift Dedicated Pool workshop to a large audience. Outside of public speaking engagements, my role within Microsoft has provided me with the opportunity to speak with large groups about the benefits of migrating to Azure, as well as, the capabilities of SQL Server on-premises and in the cloud. My passion these days is helping folks modernize within Azure utilizing one of our many PaaS solutions, as well as, the out of the box SQL Server product.

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. Kiosk map and pay-by-plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

We will have a room set up for you to ask our SQL Experts for assistance with any current challenges you might be having. Look for this image posted at the door

If you are interested in speaking at SQL Saturday Jacksonville, please go here to submit your sessions: https://sessionize.com/sqlsatjax1041

By registering for this event you agree to the following.

SQLSaturday events seek to create a respectful, friendly, patient, considerate, and inclusive event experience, and an environment where all participants feel welcome.

We therefore ask all participants to honor this Code of Conduct. Any disruptive, intolerant or inappropriate behavior will not be tolerated, and we reserve the right to remove participants who violate our Code of Conduct from the event.

We do not tolerate any harassment or discrimination. Although this list cannot be exhaustive, we explicitly honor diversity in age, gender, gender identity or expression, culture, ethnicity, language, national origin, profession, race, religion, sexual orientation, socioeconomic status, physical and psychological ability, and technical ability.

The organizer of this event will prioritize marginalized people’s safety over privileged people’s comfort. Please report any concerns, harassing behavior, or suspicious or disruptive activity to the event organizer or staff.

[email protected]

Event Venue & Nearby Stays

University of North Florida, 1 UNF Dr, Jacksonville, United States