EDM Data

We have two sessions this month for an in person event at the Capilano branch of the Edmonton Public Library.

Alternatively the URL to join virtually is: https://teams.microsoft.com/l/meetup-join/19%3ameeting_YzVmZWVhZGEtY2NlYi00ZDRmLWJjNTYtNjFmMDlkOTMwNzc0%40thread.v2/0?context=%7b%22Tid%22%3a%22b4c9f32e-da17-4ded-9c95-ce9da38f25d9%22%2c%22Oid%22%3a%228f81c4ed-a33a-4baa-a903-5dd8cf4ddd4d%22%7d

Deployment Pipelines in PowerBI
Power BI Deployment Pipelines help us achieve the "deploy" part of the CI/CD life cycle in a manual way, but with fabric the Git integration now makes it easy to use Azure DevOps. Versioning, automation of deployment can be achieved and enterprise BI Teams can bring application lifecycle management to their Power BI environments. The session will focus mainly on Power BI objects (reports, datasets) in the Fabric workspace.

Speaker Bio:
Akshata is a Data Engineer, with almost 16 years of experience in data engineering and data reporting space. Akshata has worked with Oracle database, SQL Server, SSIS, Informatica Power Center, Hadoop Systems, Power BI, Qlik and Tableau. She enjoys being in the data space and learning new things.

Query Store: Best Performance Practices
Query optimization is an important part of a Database Administrator job. Query store feature is used to identify and fix the query performance issues.
In this Demo-centric presentation, we will take a deep dive into mastering the Query Store feature and its latest enhancements in SQL Server 2022 and in Azure SQL database. This session will cover the advantages of Query Store, Automatic plan correction in SQL Server and in Azure SQL database, Query hints with real time scenarios and examples.
Attendees will leave this presentation with a solid understanding of Query Store and how to use it to optimize query performance in both SQL Server 2022 and Azure. They will also learn best practices for using Query Store to identify and troubleshoot performance issues, and how to leverage this feature for maximum Query performance.

Speaker Bio:
Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification in Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.