Jacksonville SQL Server User Group (JSSUG)

***** Register here: https://sqlsatjax.eventbrite.com/?aff=Meetup *****

This is a workshop for Power BI Developers to learn how they can enhance their existing Power BI solution with the components of Microsoft Fabric and how each component takes part in the overall architecture of the analytical solution.

In this workshop, features such as Data Engineering, Data Warehousing, Data Integration, and One Lake will be discussed as their role in a multi-layered architecture solution for Power BI. Attendees will learn how to use Dataflows and data pipelines to build the ETL solution, load the data into staging Lakehouse, apply data engineering scenarios, transform it into Star schema and then load it into a data warehouse, the importance of medallion architecture, the Onelake feature of Shortcut to re-use components and finally the Power BI DirectLake to have a better connection type from Power BI to the underlying data. The concepts will be discussed in detail with many hands-on lab exercises. Reza developed the content of this workshop based on his work with current customer projects, best practices, and experiences.

This is not a workshop about all the features of Fabric. Only the features directly related to Power BI solution architecture will be discussed. These are data engineering, integration, warehousing, and Power BI.
Attendees will leave this workshop with a ready-to-use plan and an approach to enhance their existing Power BI solution architecture to a multi-layered, easy-to-maintain solution using Microsoft Fabric.

***** Register here: https://sqlsatjax.eventbrite.com/?aff=Meetup *****

You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans.

In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.

You should be comfortable using SSMS to write multi-page queries, functions, and stored procedures. You should be comfortable identifying common query plan operators like index seeks & scans, key lookups, sorts, and parallelism, and comparing plans.

In this session, you’ll:

* Learn the difference between early and late estimation errors
* Learn how to choose between temp tables, CTEs, and table variables
* Learn the best query hints to apply quickly
* And more!

****** REGISTER HERE https://sqlsaturday.com/jax REGISTER HERE ********

Jacksonville's 17th 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 17th year of SQL Saturday in Jacksonville and will be held on May 3, 2025. Admittance to this event is free, and donations and sponsorship cover all costs. 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 nonprofit organization.

Why Attend? This 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.

Pre-Cons will be held on Friday, May 2nd.

PreCon: DAX and Calculations in Power BI from Rookie to Rock Star - Reza Rad
Click Here To Register - https://sqlsatjax.eventbrite.com

PreCon: Mastering Query Tuning - Brent Ozar
Register Here - https://sqlsatjax.eventbrite.com