Database Webcast Series

Join SolarWinds and their partner Clever Distribution in a discussion on Maximizing Your Network Performance With SolarWinds - On-Demand!

About the presenter: John O'Callaghan, Director, Partner Development, SolarWinds joined SolarWinds in January 2018 and is responsible for Partner development across EMEA since March 2021.

In traditional database analysis, application performance is often put off until the deployment phase, which can often be too late. Fast access to query performance on production servers incorporates application performance in the development cycles, so you can more easily optimize database performance.

SolarWinds® Database Performance Analyzer (DPA) is built to monitor development, test, and production servers with less than a 1% load. With the DPA dashboard, DBAs can more easily visualize the production database to understand how code is performing.

Join us for our latest on-demand webinar to find out more about DPA and how it can be used to help you gain the most out of your databases.

Join SolarWinds and their partner Clever Distribution in a discussion on Simplifying Database Performance Management with SolarWinds.

In traditional database analysis, application performance is often put off until the deployment phase, which can often be too late. Fast access to query performance on production servers incorporates application performance in the development cycles, so you can more easily optimize database performance.

SolarWinds® Database Performance Analyzer (DPA) is built to monitor development, test, and production servers with less than a 1% load. With the DPA dashboard, DBAs can more easily visualize the production database to understand how code is performing.

About the presenter: John O'Callaghan, Director, Partner Development, SolarWinds joined SolarWinds in January 2018 and is responsible for Partner development across EMEA since March 2021. Prior to that John led product marketing in the international markets.

In this webcast, Steven Wright will review some of the most common SSAS performance killers as well as useful metrics to monitor in SSAS Tabular model, which is now the default installation option in SQL Server.

As a DBA, it can be frustrating to get assigned a ticket suggesting something is wrong with the database, and after you spend the time you don't have, it becomes clear it wasn't the database at all. It was the underlying infrastructure, network, etc. In this video, we show how SolarWinds® Server & Application Monitor (SAM) can enable your IT team to monitor the health and availability of your Microsoft® SQL Server and other database instances. SAM in the hands of your IT support and monitoring teams provides broad visibility across the stack. It can make it easy for the team to identify the underlying cause for database availability and performance problems. SAM gives you visibility to the underlying elements with an impact on database availability and performance. It also looks up at the applications the databases are supporting, helping eliminate wasted time and resources, finger-pointing, slow time to repair, and unhappy customers.

DevOps is a widespread and popular set of practices, tools, and philosophies used to improve and accelerate the system's development life cycle. DevOps automates and integrates the processes between software development teams (“Dev”) and IT administration teams (“Ops”).

While DevOps is popular for full-stack software development, it is also excellent for database development and can help reduce or eliminate many database performance issues before they ever deploy to production. Unfortunately, this practice isn’t widespread. But it should be!

In this two-part webcast, you will learn how developers using Visual Studio “quality gates” can integrate with SolarWinds DPA and SQL Sentry to make that happen. Without this integration, undetected performance problems can lead to lost productivity and even lost data, as well as significant time spent by developers and database administrators (DBAs) chasing down performance problems.

Packed with demos in Visual Studio and both DPA and SQL Sentry, you will see how to identify SQL Server performance problems in the development cycle, before the changes hit production.

PREREQUISITES: Basic proficiency with core SQL statements, like CREATE, ALTER, DROP, GRANT, SELECT, INSERT, UPDATE, and DELETE

Now more than ever, it is important for professionals across various roles, levels, and functions to easily access and use operational tools designed to add value and accelerate the business. To achieve this, tools must be simple to use and integrate. 

Join us for our next SolarWinds Day virtual event, where we will share how we are making it easier than ever to access and use IT operational tools. We will introduce our latest innovations that expand the availability of our Service Desk and Database Management solutions beyond IT.  

During the event, you will:   
• Learn how we are expanding the availability of SolarWinds Service Desk to additional functions across the enterprise, standardizing processes and enhancing the delivery and management of their services.    
• Discover how we are making it easier than ever for database professionals to quickly detect, remediate, and prevent issues with the latest SQL Sentry® release.
• See live demos and get your questions answered by subject matter experts.

Discover the Latest Enhancements in SQL Sentry

Since the acquisition of SentryOne by SolarWinds, a lot of development work has gone into SQL Sentry. With each release, we aim to continue empowering Microsoft Data Professionals to achieve breakthrough performance across physical, virtual, and cloud environments.

In this webcast, we’ll discuss some of the newest features added to SQL Sentry over the last few releases. During the webcast, we’ll be discussing the following:

• The new Enhanced Environment Health Overview dashboard built to help surface the most important information about your database environment
• The addition of SQL Server Wait Stat as part of our Top SQL monitoring to help provide users with troubleshooting and performance tuning
• Monitoring of Azure Synapse as a target, providing detailed visibility into the queries, loads, backups, and restores of all your data
• A whole host of enhancements we’ve added to our SQL Sentry Portal web client and how it’s modernized the product

During this webcast, the product leadership team of SQL Sentry will join to discuss the product roadmap and their vision for the product.

If you are an existing user of SQL Sentry or considering it as a monitoring tool for your environment, this webcast is not to be missed.

Are you struggling with performance issues in your Azure® Synapse Dedicated SQL Pools? Or are you looking to optimize your environment for better results?

Register for our webcast to learn about common performance issues that can impact effective use and get insights into how to resolve them.

Join Steve Wright, senior solutions architect, as he discusses:

• MPP architecture and key components of Synapse Dedicated SQL Pools, laying the groundwork for troubleshooting.
• How to identify issues and discover common performance bottlenecks that can hinder the effectiveness of your Azure Synapse Dedicated SQL Pools, and the options to resolve them.
• Get introduced to the basics of data warehousing in Microsoft Fabric and how these concepts might translate to Microsoft's latest Analytics Platform

We’ll also answer any questions you might have about how to get optimal performance of your Synapse SQL Pools.

Please note if you cannot attend this webcast live, a recording will be sent directly to your inbox so you can catch up on this not to be missed session in your own time.

Join us for this live webcast in partnership with Data WIT, celebrating the women speakers in our community. The final webcast in a series of four live digital webcasts, we’ll bring you deep technical content and awareness of women’s issues in data.

Developing databases and Azure Data Factory pipelines is just the beginning. Once the code has been committed to source control, moving code between environments can be cumbersome in a manual environment. When multiple databases are involved or database changes need to be deployed with ADF pipeline changes, tracking the proper builds of each solution is critical. Otherwise, the quality assurance team may test incompatible builds, leading to wasted time and potentially allowing unsupported changes to be deployed together.

This session will introduce database developers and administrators to build and release pipelines in Azure Data Factory. Participants will gain hand-on experience, working with a demonstration database and a set of Data Factory artefacts to deploy to a target environment. Additionally, PowerShell will be used to do basic tests to ensure the database and ADF artifacts were deployed correctly. There are many nuances and advanced settings in Dev Ops, which will not be covered in this course.

In today's data-driven world, achieving optimal database performance is critical. However, complex modern database systems bring challenges. Downtime, data loss, and security worries underline the need for innovative solutions.

Introducing our latest offering, SolarWinds Database Observability.

Built for the cloud on the SolarWinds Platform and our SolarWinds Observability Solution, Database Observability helps to ensure optimal performance by providing full visibility for all major open-source databases.

Are you curious about the evolving landscape of database administration and data professionals? Have you heard of job roles like database engineer (DE), database reliability engineer (DBRE), and data steward?

Wondering how to stay ahead in a rapidly changing industry?

Join industry experts Bob Ward, Kevin Kline, and Blythe Morrow as they delve into the exciting prospects that lie ahead for DBAs and data pros in our field.

Agenda:

Introduction: The changing role of DBAs in the tech landscape.

Exploring Tasks: Unpacking the future tasks that will define the data professional's role.

Skill Development: Discovering the essential skills to stay ahead in an evolving environment.

Marketplace Preparedness: Proactive steps to take now to navigate future marketplace shifts.

Microsoft's Vision: Aligning with Microsoft's product direction to empower data pros and organizations.

Don't miss this opportunity to gain a competitive edge in your DBA career. Be part of the discussion that shapes the future of data professionals.

Do you have a cost-saving strategy to replace legacy Oracle databases with open-source PostgreSQL?

If so, you might be thinking about the following:
• What monitoring and tuning tool options exist for PostgreSQL?
• How do I pinpoint where (and why) PostgreSQL is performing better or worse than Oracle?
• Do I have to leave my Oracle tooling behind after we migrate?
• How will my Oracle tuning and troubleshooting skills transfer to PostgreSQL?

In this webcast, PostgreSQL experts Ash Recksiedler and Robert Mandeville will answer those questions and others.

They’ll share their knowledge of the PostgreSQL monitoring and tuning tool landscape and their advice on how to “tool up” to help ensure your Oracle-to-PostgreSQL migration goes smoothly.

The adoption of containerization and orchestration platforms, such as Kubernetes, has grown quickly as DevOps teams look to build scalable and resilient applications. Container environments consist of many moving parts. For example, in a busy application environment, hundreds of pods, the smallest execution unit in Kubernetes, are continuously being launched and decommissioned.

In this complex and dynamic environment, monitoring the health of your application infrastructure and troubleshooting issues can quickly become challenging. Between resource allocation issues that can cause pod eviction events, an unexpected termination scenario due to a spot instance availability, or CrashLoopBackOff errors arising from missing dependency that results in repeated failed launches; the sheer scale and complexity of a Kubernetes-back application requires more than standard monitoring and alerting to ensure optimal performance and health.

However, automation done well is more than just setting a SQL Agent task to take nightly database backups. Smart automation incorporates aspects of monitoring enabling your automations to respond dynamically and flexibly to the situation at hand.

You have a lot of choices in how you automate your workflows in SQL Server. There are tools to help you write your automation code, products to set-it-and-forget-it, and everything in between. Join Database Evangelist Kevin Kline to discuss where monitoring ends and automation begins.

In this session, you’ll learn:
• How database automation and better monitoring can support trouble-free operations
• Which tasks should you consider automating, on which servers, and in which order?
• The difference between PowerShell/korn/bash scripting, Microsoft CoPilot for SQL Server, Power Automate, DIY scripting, and an enterprise product
• Resources available to you to continue to learn about SQL Server automation

Join us to learn more about the world of SQL Server automation from experts in the field.

It’s rare to find a database completely free from the ills of poor design and/or inefficient queries. The result? Typically, higher I/O, longer user wait times, greater amounts of blocking, and increased resource consumption and contention.  

So, what’s the best way to tackle the issues and maximize return on time invested? Tune the SQL statements? Add another index? Add more columns to an existing index?  

Join database experts Kevin Kline, technical evangelist for database technology at SolarWinds, and Kellyn Gorman, director of data and AI at Silk, for a discussion about optimizing PostgreSQL database performance. Kevin and Kellyn will cover a variety of critical insights into query efficiency and table indexing on PostgreSQL, such as: 

*Assess query inefficiencies by reading execution plans. 
*Review table and index design for optimal performance. 
*Determine the priority of what options to tune first by reviewing overall workload behavior. 

Finally, Kevin will demonstrate the newest features in Database Performance Analyzer (DPA) that make the entire performance tuning process faster and easier!

Enterprises worldwide are adopting more selective stances toward their cloud solutions, with a greater emphasis on meeting strategic business goals and increasing flexibility, scalability, and cost-effectiveness. This shift involves more rigorous evaluations of ROI and, in situations where the ROI is inadequate, uprooting cloud-based applications, workloads, and data from the cloud back to local infrastructure – a process known as cloud repatriation.

Cloud repatriation is driven by several factors, including security, compliance, performance, and internal policies. However, the number one reason for cloud repatriation is cost. This session will cover the five most important steps you can take to optimize your cloud spend before taking the drastic step of repatriation.

In this session, you’ll learn how to:
• Right-size and match the instance types and sizes to your specific workloads while including spot, reserved, and standard instances in your analysis
• Enable smart autoscaling and microservices to enable workloads to dynamically adjust consumption on demand
• Be vigilant for unused resources since you must pay for everything running in the cloud, even if unused or unattached
• Tune existing applications and databases for poor-quality SQL code and database designs since every cycle wasted on CPU, Storage, Memory, and I/O adds cost
• Assess the cost-benefit choices between cloud VMs and managed services

Join SolarWinds and the experts from Soaring Eagle to learn more about the world of cloud cost optimization from top experts in the field!