<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

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

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

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

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

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

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.