There is a code of conduct for this event that all attendees are expected to follow. Please report violations to the organizers
If you need to report a Code of Conduct violation, please contact the organizers and send a copy to coc@sqlsaturday.com
Data Privacy
This event adheres to the generic data privacy policy.
SQL Saturday Silicon Valley returns in 2023 as a free training event for professionals who use the Microsoft data platform. Nowadays, this community event offers content across different data platforms (Azure, AWS, GCP, etc...), SQL (SQL Server, Postgres, MySQL, etc...) & No-SQL (CosmosDB, MongoDB, ElasticSearch, etc...) systems, data management, public, private and hybrid cloud architecture, data & business analytics, business intelligence, data visualization, data science and artificial intelligence, and many more topics.
Do you wish you could make your SQL Server or Azure SQL database queries go faster without paying for expensive tools? In this workshop, you will learn how to identify your slowly running queries and how to make them go faster by applying indexes, code changes, and execution plan changes. I will teach you not only how to use the tools but also the processes I use on a day-to-day basis to improve SQL Server workloads for over 50 different customers.
Tools covered include Query Store, Plan Explorer, Extended Events, Intelligent query processing, and open-source scripts.
Speaker Info:John's experience leading large technical teams in complex environments has made him a global expert in performance and scalability. John speaks at conferences worldwide on database strategy and topics related to performance tuning, development, and cloud computing. He is a Microsoft Certified Trainer. He is the principal consultant and founder at Procure SQL.
This full-day workshop session will provide participants with essential best practices knowledge and practical tools to begin designing enterprise-ready solutions with Power BI. We will design a report, but this session will primarily focus on enterprise data modeling and dataset delivery for reporting & analytics.
Bring your questions to the webinar for a live Q&A session.
Focus:
Overcoming challenges with data at scale
Meeting the needs of data governance, and business buy-in. and ownership
Addressing challenges with DevOps, and code sharing. and multi-developer projects
Futureproofing Power BI solutions for business, data. and user audience growth
Delivering an enterprise Power BI solution using a best practice checklist
Getting ready for Microsoft Fabric and exciting platform enhancements
So many features! OMG, let’s focus on the essentials!
Bring your laptop and together, we will design a business-ready solution, including:
Fundamental data modeling
Transformation basics & guidelines
Designing and building performant queries for data at scale
Using parameters to manage source changes and environments
Naming conventions, annotations, and documentation
DAX essentials & building blocks
Deployment planning
Keeping it real – balancing “ideal” DevOps and realistic BI delivery
Right-sizing data models for flexibility & expanding requirements
We will also discuss and demonstrate some advanced topics, including:
When and how to consider using composite models
Calculation groups – the key to flexible calculations
