<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

Event Description:
Unlock the secrets to creating stunning, fully customizable Powerviz visuals that will transform the way you interact with your data. An immersive and empowering event where we unveil the secrets of how to design eye-catching visuals that tell compelling data stories with ease.

Event Highlights:
1. Introducing Powerviz Visuals:
We will delve into a few Powerviz Visuals, showcasing their versatility in turning your data into captivating visual narratives.

2. Hands-On Exploration:
Get ready for an interactive demonstration where you'll explore the user-friendly interface and learn how to harness the full potential of Powerviz visuals. From pre-built themes to customizable color palettes, we'll show you how to design visuals that not only look great but also convey meaningful insights. We'll guide you through the process step by step, ensuring you can create impressive dashboards without any prior coding knowledge.

3. Real-world Applications:
Let's discuss about the various use cases and scenarios where Powerviz visuals can be a game-changer

Supercharge your Power BI Dashboards with Powerviz visuals​

In this session Rony will demonstrate how traditional on premise databases like SQL Server can be transformed into a GenAI machine. Rony will describe the complexities of using the foundational model over enterprise data and will show how important is to create data models for large language models to optimally function and provide accurate responses. Rony will share the architectural considerations and the business specific use cases observed and how enterprises are adopting GenAI.

Can your database be turned into a GenAI machine?

In PostgreSQL, Vacuuming is a routine maintenance procedure that improves database speed and frees up space. It leads to clearing out old or deleted rows from tables and indexes, as well as refreshing query planner statistics. By deleting records that are no longer required, PostgreSQL's vacuum operation maintains the database's speed and space efficiency.

In PostgreSQL, autovacuum is enabled by default and can be customized using a number of settings in the postgresql.conf file. There are several vacuum-related PostgreSQL options that may be customized to manage how the vacuum process functions.

In this session, Suyog will cover: •  What is the Vacuum and Autovacuum process. •  How to tune Autovacuum parameters to optimize database performance. •  When and how to use Vacuum full, reindex, and pg_repack •  Best practices and lessons learned from real-world case studies.

IMPORTANCE OF POSTGRESQL VACUUM TUNING TO OPTIMIZE DATABASE PERFORMANCE

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

Unlock the full potential of PostgreSQL with our advanced session tailored specifically for SQL Server DBAs. This intensive session dives deep into PostgreSQL's robust features, exploring performance tuning, advanced indexing, replication, and more. Designed for database administrators familiar with SQL Server, this session will bridge the gap between the two platforms, equipping you with the skills to manage and optimize PostgreSQL databases effectively. Join us to enhance your expertise and ensure a smooth transition to leveraging PostgreSQL in your environment.

"Mastering PostgreSQL: Advanced Techniques for SQL Server DBAs"

Think geospatial intelligence is just about mapping data? Think again! In this session, we'll dive into the world of geospatial functions available in popular data platforms. We'll walk through a compelling real-world use case: predicting the percentage of students participating in the free and reduced lunch program using shape files and data from various government agencies. Learn how to leverage geospatial intelligence to enhance analysis, and, yes, even get tips on displaying your results in maps. Whether you're a beginner or looking to expand your geospatial toolkit, this session has something for you. Join us for a journey beyond the map!

More than Just Maps: Unleashing Geospatial Intelligence

Having a consistent performance-experience is crucial for a successful business. If your role requires supporting SQL Server Databases you need to understand where to look and what to look for.
Depending on whether your SQL database is hosted on-prem, in Azure SQL or Fabric, there are some differences in what tools are available.
In this session, Andreas Wolter, former Program Manager at Microsoft with over 20 years of experience in the field as consultant will give you an overview over the available tools, explain where they overlap and where limitations require a different approach using built-in SQL functionalities.
Among the things you will be introduced to will be the database watcher, extended events, wait stats and DMVs.
So next time someone asks you to take a look at a badly performing database application, you know where to look.

Quickstart into Performance Monitoring & Troubleshooting for SQL databases in Azure and Fabric

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

Explain the best practices of designing and implementing BI solutions using Power BI

Power BI Development Framework Post Fabric Launch

Because however much you buff and shine the seats, wheels and body, how fast and how well your car drives depend on its engine's conditions.

As many SQL Server Administrators and Virtualization Administrators have (painfully) discovered, unless the underlying virtual infrastructure is well-configured and properly tuned, a virtualized SQL Server instance will severely under-perform against a similarly-sized physical SQL Server.

If you have found yourself caught in this State of "We shouldn't have virtualized" conundrum, don't despair. 

Attend this Session for the latest and most authoritative guidance on how to successfully virtualize your Mission-Critical, Monster-sized SQL Server on the VMware Cloud Foundation (VCF) and VCF-based Public/Hybrid Cloud infrastructure.

This Session will attempt to present all the common pitfalls you need to avoid in your virtualization efforts, regardless of whether your virtualized Microsoft SQL Server virtualization is on-premise or in one of the various VCF-based Hybrid Cloud options available from AWS, Microsoft, Google, Oracle, etc.

Oh, wait... all is well with your SQL Server virtualization experience? Come to the Session anyway. You will learn more than one new ways of optimizing performance even more for your SQL Server farm.

Come with questions. I need to earn my keeps.

Successfully Virtualizing SQL Server: It's Beyond Query Tuning

Event Highlights:
Experience the potential of Powerops Desktop, a FREE external tool designed for comprehensive analysis, usage identification, report comparison, and best practice evaluation of Power BI reports and models.
This session will demonstrate how Powerops simplifies the process of analyzing and comparing Power BI reports, offering users an intuitive interface for identifying changes and improvements effortlessly. Explore the Best Practices feature, which enables easy self-auditing of reports, helping you optimize them further for enhanced performance.
Don't miss out on this opportunity to learn how to harness the potential of Powerops Desktop for a more efficient and productive Power BI journey.

Takeaways:
1. Attendees will learn how Powerops simplifies the often complex tasks of analyzing and comparing Power BI reports
2. Attendees will learn practical strategies to optimize their reports for improved performance and usability using the best practices feature

Discover Powerops Desktop- Your Free Power BI Sidekick

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?

The goal of this presentation is to demonstrate the power of window functions in SQL, using real-world examples and providing complex engineering insights from various perspectives.

Demystifying SQL Window Functions in Healthcare, Sales, Marketing, and Beyond

In today's data-driven world, ensuring privacy is more critical than ever. Join us for an insightful session that begins with an overview of key data privacy laws and requirements. We'll explore the challenges of re-identification - even in aggregated data - and dive into three different privacy-preserving methodologies: data suppression, differential privacy (adding noise into results), and synthetic data generation. You'll learn about tools and techniques available for each method and gain insight into their strengths and weaknesses.

Practical Solutions to Protect Data Privacy

We will walk through an end-to-end example of how data originating in Azure Databricks can be consumed and presented by PowerBI today. We'll start in Azure Databricks with base data, conduct ETL, publish to PowerBI, and author a report. Along the way, we will examine relevant Databricks features to give you a more comprehensive understanding of how the platform works. We'll also examine how Databricks closely integrates with PowerBI, and how - together - they both simplify implementation efforts and greatly reduce time-to-market.

Harnessing the Power of Databricks + PowerBI Today

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

Title: "Harnessing the Power of MySQL HeatWave for Industry-Level Data Management: A Comparative Analysis with MySQL and AWS SageMaker"


In this presentation, we delve into the transformative capabilities of MySQL HeatWave in managing industry-level terabytes of data. MySQL HeatWave is a fully managed database service that combines OLTP (Online Transaction Processing), OLAP (Online Analytical Processing), and machine learning capabilities in a single database engine, offering unprecedented speed and performance.

Key Topics Covered:
Introduction to MySQL HeatWave:

Overview of MySQL HeatWave and its unique architecture.
How HeatWave integrates OLTP, OLAP, and machine learning.
Managing Terabytes of Data:

Real-world examples of industry-level data management using MySQL HeatWave.
Techniques and best practices for handling large-scale data efficiently.
Performance Comparison:

Detailed performance benchmarks comparing MySQL HeatWave with standard MySQL.
Analysis of data processing speed, query performance, and resource utilization.
Machine Learning Integration:

Demonstrating the integration of machine learning within MySQL HeatWave.
Use cases showcasing predictive analytics and data-driven decision-making.
Comparison with AWS AI SageMaker:

Overview of AWS SageMaker's capabilities for machine learning.
Comparative analysis of MySQL HeatWave's integrated machine learning versus SageMaker's dedicated ML services.
Pros and cons of using MySQL HeatWave versus AWS SageMaker for different business scenarios.
Cost and Efficiency Considerations:

Analyzing the cost-effectiveness of using MySQL HeatWave for large-scale data management.
Comparing the total cost of ownership (TCO) with MySQL and AWS SageMaker.
Case Studies and Industry Applications:

Presenting case studies from various industries that have successfully implemented MySQL HeatWave.
Discussing the impact on business performance and efficiency.


Harnessing the Power of MySQL HeatWave for Industry-Level Data Management: A Comparative Analysis

Have you ever worked on a database used by more than one person?  ;-)  If so, then this session is for you!  In this session we'll talk about what happens when multiple processes compete for the same resources  (aka "Concurrency").  We'll break down SQL Server's isolation levels, and the trade-offs between concurrency and such scary-sounding things as "dirty", & "phantom" reads. There will be practical demo's and some real-life examples "from the trenches".   There are a lot of misconceptions out there about this topic, you may be surprised!  

Concurrency - "SQL Server Traffic Control" - Avoiding Data Collisions

As a DBA, you know that TempDB performance is crucial to overall health and server performance. At the same time, you have tons of concurrent tasks running on your server that depend heavily on TempDB, causing a slowdown in performance. 

In this session, I'll cover how the allocation of resources and workspace on TempDB is being managed. Next, I'll show you how to analyze the causes of contention and explore methods to identify and fix them. This includes configuring, and monitoring the TempDB to operate optimally on production servers.
Finally, I'll show you a demo on how to mitigate each of the contention types and how it varies across SQL Server versions.

By the end of this session, you will be able to address and resolve TempDB contention promptly, ensuring optimal TempDB performance in your SQL Server.

TempDB Contention: How to Identify and Resolve it

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.


Massively Accelerated AI Migrations

Security is a top priority for Microsoft Fabric. As a Fabric customer, you need to safeguard your assets from threats and follow your organization's security policies. The Microsoft Fabric security session serves as an end-to-end security overview for Fabric. It covers details on how Microsoft secures your data by default as a software as a service (SaaS) service, and how you can secure, manage, and govern your data when using Fabric. This will be an engaging session and you will get an opportunity to provide direct feedbacks to the product team. If you are a data analytics professional implementing Fabric or if you are an IT/InfoSec admin who wants to make sure that proper controls are in place for your organizational tools, then don't miss this session.

Fabric Security - Everything you need to know

There are many Managers in this world and every once in a while we come across a leaders.  We will go on a Journey as to what is a leader and what we can do to improve our ability to stay ahead of the curve and become a better leader.

Leadership Principles Uncovered...

Do you have a slow Power BI report? This session will equip you with the knowledge to address the issue of slow Power BI reports.

Whether you are just starting on your Power BI Journey or an experienced Power BI developer these tools enhance your development and analysis of your data. This session will cover connecting to Power BI Desktop, Power BI Premium Workspaces, and Fabric Workspaces to meet you where you currently are. DAX Studio and Tabular Editor are part of the study guide for the DP-600 exam for Fabric, so this is the perfect time to start learning how to put them to good use.

The first tool we will look at is DAX Studio. Its strength is being able to analyze your data separately from Power BI and Fabric. You can use it to quickly gather statistics about multiple semantic models. Has a user reported that one of the reports is running slow? You can use DAX Studio to do DAX performance tuning to make it faster. 

The second tool is Tabular Editor 2.  It gives you the ability to check to see if your models are following best practices. You can make changes to your models whether they are running in Power BI Desktop, Power BI Premium, or Fabric Workspaces. With Tabular Editor you can use scripts to automate changes that if done manually could take days.

These are just some of the topics we will cover as we learn how valuable these tools can be. This session will have the greatest benefit to someone new to DAX Studio and Tabular Editor regardless of where you are on your Fabric journey.

Details

Address

Date / Time

Registration

Call for Speakers

Call for Sponsors

Social / Web

Twitter

Hashtag

Website

Community Days | SQL Saturday San Diego 2024