talk-data.com

Greetings, data enthusiasts!

Our October meeting is scheduled for Monday, October 14th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

Please RSVP at https://www.meetup.com/capital-area-sql-server-user-group/events/299931181/ if you are attending, so we can purchase an appropriate amount of food for everyone. Food is TBA (will be announced closer to the event). For this meeting, we are welcoming Michelle Gutzait and Christian Cote, who are joining us all the way from Montreal! Thank you, Michelle and Christian, for taking the time and energy to join us and share your knowledge!

Our meeting schedule is as follows:

• 5:30 PM: Food, soft drinks, and networking
• 6:15 PM: Chapter news and announcements
• 6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Michelle Gutzait and Christian Cote are presenting on a relatively new Microsoft/Azure offering that is a game-changer in the world of analytic data: Fabric from the Ground Up In this presentation, Christian and Michelle will talk about why do we want to use Microsoft Fabric and will explain the Fabric capacity, security and pricing models.

They will also discuss the differences between a Lakehouse and a Warehouse, along with example use cases.

Lastly, they will demonstrate the options, advantages and limitations of the Power BI Direct Lake access capability.

Dive into the world of ETL (Extract, Transform, Load) with 'Hands-On Data Warehousing with Azure Data Factory'. This book guides readers through the essential techniques for working with Azure Data Factory and SQL Server Integration Services to design, implement, and optimize ETL solutions for both on-premises and cloud data environments. What this Book will help me do Understand and utilize Azure Data Factory and SQL Server Integration Services to build ETL solutions. Design scalable and high-performance ETL architectures tailored to modern data problems. Integrate various Azure services, such as Azure Data Lake Analytics, Machine Learning, and Databricks Spark, into your workflows. Troubleshoot and optimize ETL pipelines and address common challenges in data processing. Create insightful Power BI dashboards to visualize and interact with data from your ETL workflows. Author(s) Authors None Cote, Michelle Gutzait, and Giuseppe Ciaburro bring a wealth of experience in data engineering and cloud technologies to this practical guide. Combining expertise in Azure ecosystem and hands-on Data Warehousing, they deliver actionable insights for working professionals. Who is it for? This book is crafted for software professionals working in data engineering, especially those specializing in ETL processes. Readers with a foundational knowledge of SQL Server and cloud infrastructures will benefit most. If you aspire to implement state-of-the-art ETL pipelines or enhance existing workflows with ADF and SSIS, this book is an ideal resource.