EVENTS

SQL Server tuning hasn't changed. The tools you can bring to it have. AI can read an execution plan. It can flag patterns. It can suggest a fix. This session covers everything that comes after that: how Pinal Dave uses AI-assisted workflows in practice for execution plan reviews, performance pattern recognition, and slow query troubleshooting. He'll also cover the limitations: where AI helps, where it doesn't, and why the DBA in the room is still the one making the call.

ServiceNow contains a wealth of operational data, but many organizations struggle to unlock its full value using native reporting alone. To gain deeper insights, power advanced dashboards, and support emerging AI initiatives, teams need reliable ways to move ServiceNow data into modern analytics and visualization platforms. In this webinar, “From ServiceNow Data to AI Insights: Exporting Data for Power BI and Advanced Visualization,” we’ll explore how organizations can efficiently export ServiceNow data to power richer analytics, interactive dashboards, and AI-driven insights. Learn how to overcome common challenges such as performance impacts, limited reporting capabilities, and difficulty accessing large datasets directly from ServiceNow. We’ll demonstrate how exporting and replicating ServiceNow data enables teams to build scalable Power BI dashboards, create advanced data visualizations, and prepare data for AI and machine learning initiatives, without putting additional strain on the ServiceNow platform.

Database Administrators are often overwhelmed by the volume of performance data, frequently finding the "what" of a bottleneck but spending hours or days on the "how" of the resolution. This session explores the evolution of SQL Diagnostic Manager from a deep observability platform to an intelligent optimization engine. You’ll see how Query Monitor and Wait Statistics can be used to isolate high-impact performance issues, along with the new AI-powered capabilities in version 14.0 that help bridge the gap between identifying a slow query and implementing a verified fix. Key Discussion Topics:

• Query Monitoring Mastery: How to utilize Signature and Statement modes to group problematic workloads and identify recurring performance offenders.
• Decoding Wait Statistics: Moving beyond resource metrics to understand the "why" behind query delays using wait-type analysis.
• AI-Powered Query & Index Optimization: A deep dive into the new 14.0 features that provide automated, workload-aware recommendations for single queries and complex schema structures.
• Maintaining DBA Control: Exploring the AI Optimization History and the importance of a "recommendation-first" approach that ensures all changes are audited and manually approved.
• Reducing MTTR: Practical workflows for turning a performance alert into a tuned index in minutes rather than hours.

Who Should Attend: This webinar is designed for Database Administrators, SQL Developers, and IT Managers who need to scale their performance tuning efforts across large, complex SQL Server environments without increasing manual overhead.

Parameter sniffing is easy to spot and hard to pin down. The optimizer picks a plan based on the first execution, and that choice can ripple across your workload in ways that are not always obvious. A lot of that risk comes down to one decision: index seek with key lookups, or table scan. How your indexes are set up directly influences that choice. Brent walks through how deliberate index tuning reduces that risk and shrinks the blast radius when things go sideways. You’ll leave with a more practical way to think about sniffing, plan selection, and the indexing decisions behind both.

Attend a live demo of the WhereScape Data Automation ecosystem hosted by a senior solutions architect. Experience the features that enable WhereScape users to save time, money and resources on data projects and enable individual developers to do the work of many.