<p>SQL Saturday SD is a FREE, 100% volunteer ran, training event for IT data professionals. This event offers high-quality technical training on a variety of data-related topics such as:<br></p><ul><li>Data analytics,</li><li>SQL and No-SQL,</li><li>Database Administration,</li><li>DevOps,</li><li>Development,</li><li>Microsoft Azure,</li><li>Amazon Web Services,</li><li>Google Cloud Platform,</li><li>Databricks,</li><li>Data Science, and Machine Learning,</li><li>Business Intelligence and Analytics,</li><li>Women in Technology,</li><li>Personal Branding,</li></ul>
<p>...and more</p><p></p>
<p>This is a great opportunity for all data professionals or students to engage with their peers and learn from Microsoft MVPs and other local and international speakers, not to mention the great networking opportunities that this in-person event will offer. Don't forget to inform your friends and colleagues about the event!</p><p><br><a href="https://sqlsaturday.com/2024-09-14-sqlsaturday1092/">SQL Saturday San Diego 2024 (#1092)</a></p>

<h1 class="align-center"><i>Global Sponsor</i></h1><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/81492ef4Microsoft-logo_rgb_c-gray.png" id="19bc4875-8db9-4959-afbb-91ffcb4430a6" data-image="19bc4875-8db9-4959-afbb-91ffcb4430a6" width="582" height="157"><h1 class="align-center"><b><i>Platinum Sponsor</i></b></h1><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/8de57590vmware_broadcomm.png" id="bf25ddbf-248e-40b7-b976-3e6a3ac4c756" data-image="bf25ddbf-248e-40b7-b976-3e6a3ac4c756" width="567" height="169"><h1 class="align-center"><b><i>Silver Sponsor</i></b></h1><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/75953057cozyroc_silver.png" id="6bc2f623-3cde-4f60-9983-56eef972dd38" data-image="6bc2f623-3cde-4f60-9983-56eef972dd38" width="519" height="119"><h1 class="align-center"></h1><p><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/ae6700dddatabricks_silver.jpg" id="06e03879-bf3d-4481-946b-e452bfd6486c" data-image="06e03879-bf3d-4481-946b-e452bfd6486c" width="516" height="258"><br><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/c19d2e3cdatavail_silver.jpg" id="948f1c85-9c5f-4002-b287-4a2b1831df42" data-image="948f1c85-9c5f-4002-b287-4a2b1831df42" width="514" height="164"></p><h1 class="align-center"></h1><h1 class="align-center"><b><i>Valve In Kind</i></b></h1><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/68c42e38jetbrains_vik.png" id="c21018d9-78ae-4e8b-af9f-6bed82a40101" data-image="f12cff3a-fb21-47e2-a05a-5f44a9e1ce76"><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/38bf97fesqlskills.jpg" id="14e6137e-8864-442a-b724-136396e6e5be" data-image="14e6137e-8864-442a-b724-136396e6e5be"><img src="https://communitydaysstorage.blob.core.windows.net/events/2024/bc08b37e-9c0d-4862-83fd-09c49165add8/86e52699oreilly-115x20.jpg" id="14e6137e-8864-442a-b724-136396e6e5be" data-image="12b5c9b2-69e8-47ad-b9cd-5251583d8007" width="338" height="59">

SQL Saturday San Diego 2024

Ever wonder how somebody else does it? In this all-demo session, watch over Brent Ozar's shoulder while he takes a slow stored procedure in the Stack Overflow database, analyzes it, and iterates over several improvements trying to make it go faster. He'll explain his thought process as he goes, and get feedback from the audience on what they'd try as well.

Goals:
Learn to use sp_BlitzCache to identify which queries in a proc need tuning first
Understand the use of query hints to test possible database setting changes
See how to measure the overhead of query hints like recompiles

Prerequisites:
You should be comfortable writing T-SQL, reading execution plans, and using STATISTICS IO to measure logical reads. 

Watch Brent Tune a Query in SQL Server 2022

This session will teach you the difference between a good Power BI report and a bad one. Come to this session to learn:
* which visual you should use for which problem
* how to appropriately choose colors
* how to organize your data for the correct audience
* how to remove clutter and get to the point
* how to prompt action from your business users
All demos will be available to attendees. Come learn how to make Power BI an essential decision-making tool for your organization.

Data Storytelling with Power BI

Using SQL for data transformation is a powerful way to empower an analytics team to create their own optimized data model. However, applying best practices like version control and data tests is often skipped. dbt is an open source tool to apply engineering best practices to SQL based data transformations, giving you more confidence in your ELT pipeline.
 
This talk provides an introduction to how dbt helps with SQL based ETL and guidance on using dbt with Databricks SQL Warehouse. We will cover patterns using dbt Cloud with Databricks as the processing engine.


dbt + Databricks: SQL based ELT

Choosing the right Azure SQL Server offering could be daunting. With over 50 individual deployment options it is not uncommon to see DBAs migrating to Azure getting dizzy. In this session you will learn the basis of each offering and when to apply them through demos.

Azure SQL Server flavors, which one is right for my scenario?

Organizations are collecting enormous amounts of structured and unstructured data. This data holds valuable insights, but traditional data warehouses can struggle to handle the volume, variety, and velocity of modern data sets. This presentation will explore how combining SQL Server with a data lakehouse architecture can revolutionize your analytics capabilities.

We'll dive into the concept of a data lakehouse, which brings the best of data lakes and data warehouses together. You'll learn how to leverage SQL Server's robust relational capabilities alongside the scalability and flexibility of a data lake, all while maintaining data quality and governance. We'll discuss how to:

Ingest and store: Efficiently capture and store data from diverse sources, including databases, IoT devices, and cloud applications, in your data lakehouse.

Transform and model: Prepare your data for analysis using familiar SQL Server tools and techniques, ensuring data quality and consistency.

Query and analyze: Leverage the power of SQL Server's query engine, augmented by data lakehouse capabilities, for high-performance analytics and reporting.

Govern and secure: Implement comprehensive data governance and security measures to protect sensitive data and ensure compliance with regulatory requirements.

Whether you're a data engineer, analyst, or business leader, this session will provide actionable insights and strategies to accelerate your analytics initiatives, reduce costs, and unlock the full potential of your data assets. Discover how SQL Server and data lakehouse can empower your organization to make faster, more informed decisions and drive business growth.


Accelerate Your Analytics with SQL Server + Data Lakehouse

In this talk, we will explore the challenges of data migration and propose innovative solutions to ease the process. Migration is often seen as a daunting task, taking years to complete and costing millions. However, we believe there's a better way.

We will introduce the concept of Lakehouse Federation to legacy Data Warehouses as a starting point, followed by the use of Serverless SQL Warehouse for efficient and scalable BI. We will also discuss the use of Data Intelligence tools to explore and initiate AI, and how we can track lineage and consumption with UC.

We will share a case study of a global media company that was able to reduce their migration time by half by identifying and eliminating "zombie" pipelines.

The talk will also delve into the role of AI in migrating warehouse ETL logic. We will discuss the limitations of current data platform capabilities and the complexity that arises from overlapping tools. We will propose a solution in the form of a metadata-driven framework, a popular and effective method for system migration.

Join us as we explore these innovative strategies and tools to revolutionize the data migration process, making it more efficient, cost-effective, and less daunting.
