SQL Server Database Management Solutions

As a Managed Service Provider, your database teams face the unique challenge of monitoring your internal environment while also managing your customers’ database performance and providing data to both sides.

Join us for a LIVE webinar where our expert, Darren Mallette, will cover how Quest’s Foglight for Databases can:

• Condense your teams’ view to quickly identify potential issues across environments
• Reduce the time spent on customer calls requesting updates on their performance issues
• Deploy across complex and unique environments and architectures
• Clearly display end-user metrics in custom URL dashboards relative to their specific databases
• Monetize your monitoring - offering a unique service while saving you time and money

Speaker: Pinal Dave

Every new release of SQL Server brings a load of new features you can add to your database management arsenal to increase efficiency. SQL Server 2019 has introduced many new features and Pinal Dave of SQL Authority will show you how to maximize them in this special session. 

Here’s a glimpse of the SQL Server features Pinal will cover:

• Adaptive query plans 
• Batch mode adaptive join
• New cardinality estimates for optimal performance 
• Adaptive query processing 
• Indexing improvements 
• Introduction to automatic tuning 
• Batch mode for rowstore storage 
• Accelerated database recovery 

This session will provide invaluable guidance to help any DBA or developer who wants to get a jump start on SQL Server 2019 and its new features.

SQLBits is coming to London, 29 September through 3 October. 

In the meantime, you can learn expert techniques to streamline your cloud database journey in a special SQLBits preview webcast on 9 April. 

One of the challenges of cloud deployments is choosing the correct sizing for your cloud database environment.

Organisations commonly make the mistake of mimicking the on-premise server specs in the cloud, diluting the considerable cost-saving advantages that could be gained.
But when it comes to sizing an environment users can struggle to know what resources are required to ensure there is no impact on performance when migrating to the cloud.

Cloud database expert Denis O' Sullivan will discuss:

• How to choose the correct size for your cloud databases
• Why you shouldn’t mimic your on-premises server specs in the cloud
• How to achieve considerable cost-savings in the cloud
• What you can do to avoid performance impact when migrating to the cloud 

Speaker: Janis Griffin

Query tuning is key to peak performance in SQL Server databases. However, 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 session, I will share my tried and true best practices for tuning SQL statements and other issues by utilizing Wait Time Analysis, reviewing execution plans and using SQL diagramming techniques. In addition, I’ll go over several case studies 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 SQL performance tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases. 

You’ll learn how to: 

• Effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach 
• Quickly identify inefficient operations through review of query execution plans 
• Easily apply SQL diagramming techniques to find the best execution plan 

Databases serve a critical function in the banking world. Maintaining SLA compliance and avoiding risk is critical to your institution’s survival, all the while aiming to maintain the integrity of your financial institution. But as you juggle new database platforms and rapid data growth, database performance can decline. And when customer data is at stake, and hefty fines loom, you can’t afford to manage databases reactively. The databases that support these critical applications need to perform reliably.

Join this session and discover expert techniques to easily and proactively manage your ever-growing database environment.

You’ll learn how to:

• Isolate database performance issues and reduce resolution time for mission-critical financial applications
• Cope with large database environments (hundreds of instances and above)
• Handle databases in different locations (including on-premises and cloud)
• Support new database platforms and new cloud database service technologies
• and much more!