What we’re about
User group for all devotees of the SQL Server Data Platform, whether you be an administrator, a developer, a manager, or a recruiter! Please come join us for a variety of talks pertaining all the shades of Data (with a capital "D"!)! Please feel free to let the group know if you are looking for employment or employees!
This is an official PASS (Professional Association of SQL Server) user group, but we talk about so much more!
Food and Networking from 6:00 PM - 6:45 PM
Short Presentation from 7:00 - 7:30 PM
Long Presentation (75 mins) from 7:45 - 8:45 PM
We always have a raffle sponsored by our lovely vendors from the community.
Parking is going to be free at our new location
Upcoming events (1)
See all- Oregon Data Community - August 20th - Azure SQL Memory Grants!Umpqua Bank, Vancouver, WA
Welcome to the August 20th 1800 HRS PST/2100 HRS EST/0200 HRS CEST, 2025 HYBRID meeting!
We are once again meeting in person in Vancouver, WA at the downtown Umpqua Bank in their Community Room!
We meet on the 3rd Wednesday of the month once again at 6:00 PM PST. We will have snacks and networking before the main meeting
We believe we have found a new location – fingers crossed!
Meetup Link:
https://www.meetup.com/oregonsql/events/308930951
In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams. Please be mindful of the other attendees and mute your mic!
We will be starting at 6:00 PM PST/9:00 PM EST
Schedule: (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation
8:30 PM – Happy Hour/Networking (Shanahans in Vancouver)Presentation:
Title: Azure SQL Memory Grants
Abstract:
Memory Grant in Azure SQL
When SQL Server executes a query, it requires memory to store temporary data for sorting and joining rows. In this deep dive session, you will learn about the intricacies of memory grants, including how they are requested, allocated, and used during query execution. You will explore the dependencies of memory grants and the impact of insufficient memory leading to spills to tempdb, which can degrade performance. The session will also cover the memory grant feedback feature introduced in SQL Server 2019, explaining how it dynamically adjusts memory grants based on historical query execution data. Finally, you will gain insights into identifying and optimizing memory-intensive queries to enhance overall throughput and reduce costs by effectively scaling down the Azure SQL database. This session aims to equip you with a thorough understanding of memory management in SQL Server and practical techniques to improve query performance.
