Optimizing Azure SQL DB Performance: Identifying and Fixing Common Code Smells

As organizations increasingly migrate their databases to Azure SQL DB, it's crucial to ensure optimal performance to meet the demands of modern applications. In this session, we'll dive into the world of performance tuning for Azure SQL DB, focusing on identifying and fixing common "code smells" that can hinder your database's efficiency.

We'll explore a range of practical tips and tricks for identifying performance bottlenecks, we'll provide real-world examples and demonstrate best practices for refactoring and optimizing your database code.

Throughout the session, attendees will gain valuable insights and practical techniques they can immediately apply to their own Azure SQL DB environments. By the end of the session, you'll be equipped with a comprehensive toolkit for identifying and fixing common performance issues, enabling you to deliver faster, more efficient database solutions.

Whether you're a seasoned DBA or just starting your journey with Azure SQL DB, this session will provide you with the knowledge and skills needed to take your performance tuning abilities to the next level. Join us and learn how to optimize your Azure SQL DB performance like a pro!

Unleashing the Power of SQL Skills in Power BI with Dynamics 365 CE and NativeQuery

In this session, we'll explore how to leverage your SQL skills to build powerful Power BI reports on top of Dynamics 365 CE. With NativeQuery, you can use SQL statements directly within Power BI to query your Dynamics 365 CE data, giving you full control.

We'll discuss the benefits of using Power BI with Dynamics 365 CE and demonstrate how to use NativeQuery to extract data and build visually appealing, interactive reports. We'll cover best practices for optimizing queries, handling complex data relationships, and creating calculated columns and measures.

By the end of this session, you'll understand how to combine SQL, Power BI, and Dynamics 365 CE to create compelling reports and dashboards. Whether you're a seasoned SQL developer or a Power BI enthusiast, this session will provide you with the knowledge and techniques to take your reporting to the next level.

Join us to learn how to unleash the full potential of your SQL skills in Power BI with Dynamics 365 CE and NativeQuery!

Guide to Building a Powerful Yet Cost-Effective Azure Data Platform

Tired of complex and costly cloud data platforms or don't know where to begin?

Join us for an enlightening session where we guide you step-by-step to build a robust yet budget-friendly Azure data platform. Led by a seasoned Azure expert, we reveal insider tips to maximize Bang-for-Buck through optimal architecture, savvy data stores, and intelligent scaling.

Expect practical takeaways - arming you with an easy blueprint, clever tool-kit and pro techniques to build a data platform that doesn't blow the budget.

Whether starting small or boosting bigger platforms, this session shares hard-won lessons so you craft an Azure data platform with commanding power at disruptively low total cost. Depart with more budget for innovation and a competitive edge for your business.

From Rockstar to Rookie: A Journey of Career Transformation in Data Analytics

Embark on a captivating journey of career metamorphosis as we follow the path of a former truck-driving Rockstar turned data analysis Rookie. In this session, we'll delve into the transformation story that showcases the power of passion, determination, and the audacity to start anew.

Thrash through the Rookie's journey from data zero to analytical hero. Uncover the power chords of online courses, mentorship, and grit that propelled them forward.

Unlocking the Wonders of Power Query: Discover Proven Tips and Tricks

Join us for an engaging session dedicated to enhancing your Power Query experience like never before. Power Query, a remarkable data transformation tool, can be even more powerful and efficient with the right techniques in your arsenal. In this session, our expert presenters will delve into a treasure trove of tips and tricks that will elevate your data manipulation skills and streamline your workflow.

Whether you're a seasoned Power Query user or just beginning your journey, this session will cater to all skill levels. From clever shortcuts that save time to advanced techniques that optimize performance, we've got you covered. Learn how to effortlessly clean, transform, and shape your data, enabling you to unlock insights and drive informed decisions with ease.

Expect to explore:

*Strategies for optimizing query performance for large datasets
*Little-known functions and features that pack a big punch
*Best practices for handling common data cleaning challenges
*Automation tricks to streamline repetitive tasks

Don't miss out on this opportunity to expand your skills and take your data manipulation prowess to new heights.

Excel: The Accidental DBA - Hacking CRUD with VBA, SQL, and AI Sidekicks

Excel, the beloved spreadsheet tool, has been secretly aspiring to be a database admin all along. In this one-hour session, we'll embark on a thrilling journey to transform Excel into the DBA interface it was never meant to be, but always dreamed of becoming.

Armed with the power of VBA and SQL, we'll hack our way through CRUD (Create, Read, Update, Delete) operations, turning Excel into a data management superhero. But fear not, you won't be alone in this adventure! Large Language Models (LLMs) will be your trusty AI sidekicks, providing coding assistance, performance boosts, and witty banter along the way.

Through live demonstrations and hands-on examples, you'll learn to wield VBA and SQL like a pro, while LLMs guide you in implementing logging and error trapping, ensuring your CRUD operations are bulletproof and maintainable.

Join us for this hilarious and educational session, where we'll unleash Excel's inner DBA and prove that spreadsheets can handle data management tasks with style and grace. Get ready to level up your Excel skills and become the accidental DBA you never knew you wanted to be!

Excel will earn it's title as a database, no apologies made

Outliers: Embracing the Quirky Side of Data

Outliers - they're the nonconformists of the data world, always dancing to their own tune. In this session, we'll dive into the peculiar world of these data mavericks and explore how their unconventional nature can impact your analysis.

From high-flying salaries skewing your averages to rebellious data points staging a mutiny on your trends, outliers have a knack for keeping you on your toes. Fear not, we'll equip you with the tools to identify, assess, and strategically handle these quirky data points.

Mastering Data Integration: Building Robust Pipelines with Azure Data Factory

In today's data-driven landscape, organizations often face the challenge of integrating data from disparate sources, both on-premises and in the cloud. In this session, we'll explore how Azure Data Factory, a fully managed data integration service, can help you build robust and scalable data pipelines with ease.

We'll start by discussing the common pain points of data integration, such as data silos, complex ETL processes, and data consistency issues. Then, we'll introduce you to Azure Data Factory and its powerful features for data movement, transformation, and orchestration.

Through step-by-step demonstrations and real-world scenarios, you'll learn how to create and manage data pipelines using Azure Data Factory. We'll cover topics like data connectors, data flows, and control flows, showcasing how Azure Data Factory can help you streamline your data integration processes.

By attending this session, attendees will gain:

*An understanding of Azure Data Factory and its role in data integration
*Practical skills for designing and implementing data pipelines using Azure Data Factory
*Knowledge of how to integrate Azure Data Factory with other Azure services for end-to-end data solutions
*Best practices for monitoring, troubleshooting, and optimizing data pipelines in Azure Data Factory

Azure Data Factory Monitoring Secrets

Building and deploying data pipelines is just the first step in ensuring a reliable and efficient data integration process. Equally important is the ability to monitor and troubleshoot your pipelines to identify and resolve issues quickly. In this session, we'll explore best practices and tips for monitoring and troubleshooting Azure Data Factory pipelines.

We'll start by discussing the importance of pipeline monitoring and the key metrics and logs available in Azure Data Factory. Then, we'll walk you through the process of setting up and configuring monitoring for your pipelines using tools like Azure Monitor and Log Analytics.

Through practical demonstrations and real-world scenarios, you'll learn how to identify and diagnose common pipeline issues, such as failures, performance bottlenecks, and data inconsistencies. We'll also cover advanced topics like custom logging, alerting, and error handling strategies.

By attending this session, attendees will gain:

*An understanding of the importance of monitoring and troubleshooting in data integration
*Practical knowledge of the monitoring and troubleshooting capabilities of Azure Data Factory
*Strategies for setting up and configuring effective pipeline monitoring
*Best practices for identifying and resolving common pipeline issues and optimizing performance

Breaking Barriers: Thriving with ADHD in the Tech Industry

As a tech professional recently diagnosed with ADHD, I've faced challenges but also discovered incredible potential. In this session, I'll share my journey of thriving in the tech industry while navigating ADHD.

We'll explore common challenges, like time management and communication, and strategies to overcome them. We'll also dive into the unique strengths of ADHD, such as creative problem-solving and hyperfocus, with real-world examples of how they've propelled my career.

I'll offer tips for self-advocacy, building supportive networks, and challenging stigmas. Whether you're neurodiverse or an ally, this session provides valuable insights and strategies to celebrate our strengths and redefine success in tech.