SQL Solutions Group Senior Consultant Warwick Rudd will present at the Microsoft Community Conference in Las Vegas, March 31 – April 2. He has several sessions on the schedule.
Accidental Azure DBA in 2025 Copilot is Your Toolkits
In the rapidly evolving landscape of cloud computing, many IT professionals find themselves unexpectedly taking on the role of a Database Administrator (DBA) without formal training. This session, “Accidental Azure DBA in 2025 Copilot is your toolkit,” is designed to equip these accidental DBAs with the essential knowledge and skills needed to manage and optimize your Azure SQL DB and Fabric SQL DB effectively.
We will begin by exploring the fundamental concepts of a DBA in the cloud. Next, we will delve into the how as an accidental DBA we can manage these concepts, such as performance tuning, security management, and backup and recovery with the help of Copilot. Through practical demonstrations and real-world examples, participants will learn how to monitor and optimize database performance using Azure’s built-in tools and services.
By the end of this session, attendees will have confidence in knowing how copilot fits into their Azure DBA toolkit. Whether you are an IT professional who has recently been thrust into the DBA role or someone looking to expand your skill set, this session will provide you with the knowledge and practical skills needed to succeed.
Decrease Cost and Management Effort with Fabric SQL DB
Businesses today want well designed databases which can be used not only by applications but are part of an analytical solution which allows people to interact visually with the data in reports. Are you interested in decreasing and centralizing your Azure costs while continuing to support applications which need a SQL database? Are you interested in migrating an on-premises SQL Server database to the cloud or move away from decentralized manage instance databases? Fabric SQL DB can be the solution as it provides the ability to combine SQL Server functionality with Business Intelligence Analysis.
For many existing applications, having a SQL Database is a requirement. We will review the processes for doing maintenance for SQL DB inside of Microsoft Fabric, focusing on the “knob free” methods to minimize the steps involved and migration from an on prem database. We will examine the different cost models to demonstrate how this solution can be used to minimize costs and decrease management effort through automated maintenance and centralized resource monitoring.
Mastering Data Modeling for Power BI and Fabric: Best Practices and Techniques
Data modelling is a critical aspect of creating efficient and effective Power BI reports. In this session, we will discuss the best practices and techniques for building robust data models that enhance usability, performance, adaptability, and scalability. We will discuss how to interpret business requirements to conceptualise the model, plan development with tables structured in a star schema, and create organization-wide conformed dimensions.
Attendees will learn how to apply these principles to their actual models, ensuring that their Power BI reports are functional and optimised for performance. We will cover the entire process from user requirements to the finished report, providing practical tips on how to turn initial ideas into brilliant, well-performing, adaptable, and scalable reports.
Through real-world examples and case studies, you will gain insights into the common challenges and solutions in data modelling for Power BI. By the end of the session, you will have a clear understanding of how to design and build data models that meet the needs of your organisation and support complex business scenarios.
Register for the Microsoft Fabric Community Conference.
