-
Resources
- Forums
-
Managing data? Let’s talk at PASS Summit 2024.
Why you should visit us at PASS Summit 2024
Engage with our experts: Experience firsthand demos of our cutting-edge Toad, SharePlex, erwin and Foglight solutions.
Gain new insights: Attend our thought-provoking speaking sessions on tuning queries in PostgreSQL and development challenges in today’s database environment.
Socialize with your peers: Join us Thursday evening for beer, bites and fun at our happy hour social event at A Stir Bar & Restaurant.
Earn awesome SWAG: We have a new, exclusive Funko Pop Toad collectible that you can earn this year.
Win a set of Apple AirPods Max headphones: And don’t miss the opportunity to earn your chances to win the ultimate over-ear personal listening experience, Apple AirPods Max headphones!
Collect giveaways and enter our raffle!
Stop by the Quest booth (#600) to collect rad giveaways and sign up for your chance to win a set of Apple AirPods Max!
Additionally, if you scan the QR code displayed in our booth and fill out the corresponding survey you can earn a limited, first edition Funko Pop Toad collectible!
Featured solutions
Database management, productivity and automation
Database replication, migration, upgrades and HA/DR
Data modeling and data governance
Database performance and cost monitoring
Quest Sessions at the PASS Summit 2024
Join us for our presentations…
Development
Challenges in Today’s Database Environment
Presenters: Janis
Griffin, Senior Technical Consultant, Quest Software
Track:
Database Management
Level:
200 - Beginner
Date:
November 6
Time:
11:05 AM-11:35 AM
Location:
Ecosystem Stage, Paramount Lounge
Are you under pressure from your business to build, test and release software changes faster? Is it unclear how to bring database processes into your DevOps infrastructure? Are you concerned about the risks of making compromises while shortening your release cycles? Are you wondering how to effectively monitor the performance impacts of your database changes? Are you required to replicate fast moving changes to your hybrid database environments? If the answer is ‘yes’ to any of these questions, then this presentation is for you! Future proof your databases and achieve continuous database operations!
Can SQL Server DBAs/Developers Tune Queries in PostgreSQL?
Presenters: Janis
Griffin, Senior Technical Consultant, Quest Software
Track:
Database Management
Level:
200 - Beginner
Date:
November 8
Time:
10:30 AM-11:30 AM
Location:
447-448
Let’s face it, query tuning is key to peak performance in any database. However, if you are primarily SQL Server-focused and you’re suddenly tasked with tuning PostgreSQL queries, that task can seemingly become daunting.
Lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time trying to fix them. In this presentation, I will share my tried-and-true best practices for tuning PostgreSQL statements and other issues. By utilizing Wait Time analysis, reviewing explain plans, and giving tips on which operations to look out for, you will be able to quickly tune queries that are affecting performance. In addition, we’ll explore SQL diagramming techniques to find the best execution plan and several case studies will be used to demonstrate these best practices.
Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing - saving countless hours of tuning queries and optimizing performance of your PostgreSQL databases.
Quest Sessions for those also attending the Postgres Conference on the 4th Floor of the Seattle Convention Center
Join us for our presentations…
Top 5 PostgreSQL Query Tuning Tips
Presenters: Janis
Griffin, Senior Technical Consultant, Quest Software
Track:
Dev
Difficulty:
Easy
Date:
November 6
Time:
14:00 PST (2:00 PM PST)
Room:
Dev: 422 (on the 4th floor of the Seattle Convention Center)
Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. This presentation will detail five steps to identify performance issues and resolve them quickly. Attendees at this session will learn how to fine-tune a SQL statement quickly; identify performance inhibitors to help avoid future performance issues; recognize costly steps and understand how execution plans work to tune them.
Bridging the Gap: Smooth Data Migration from Oracle to
PostgreSQL
Presenters:
Clay Jackson, Sr. Database Solutions Architect, Quest Software
Track:
Ops
Difficulty:
Easy
Date:
November 6
Time:
16:00 PST (4:00 PM PST)
Room:
Ops: 421 (on the 4th floor of the Seattle Convention Center)
In today's data-driven world, the demand for data is increasing and its protection is critical. Oracle is everywhere - from ERP to medical and other applications. However, not all applications need all the features and cost of Oracle. In this presentation, we will explore ways to move data from Oracle to PostgreSQL.
We will begin by highlighting the high-level trends in data and the growing need for data movement and migration. With ever-increasing adoption of PostgreSQL, it’s more important than ever to have a data strategy that allows you to move data between heterogeneous systems.
Moving data is not a straightforward task and requires considering data growth, data demand, and data protection. We’ll will explore these challenges and the options available to move data from Oracle into PostgreSQL.
We will also delve into the different aspects of data movement such as real-time data delivery, ensuring data is in the right place at the right time and is available and secure.
After a long day at the Summit, relax and rock out with us at the Quest happy hour!
Join us for beverages, bites and fun at our private happy hour event! Space will be limited, so RSVP today!
Quest happy hour at A Stir Bar & Restaurant
Date: Thursday, November 7, 2024
Time: 6:00 PM – 9:00 PM PST
Location: A Stir Bar & Restaurant, 818 E. Pike St, Seattle, WA 98122
Space is limited, so RSVP today to save your spot at our happy hour event!