SQL Server Database Management Solutions

One day you ‘accidentally’ became a SQL Server DBA… Now you are ‘accidentally’ a multi-platform DBA.  It can be overwhelming. 

What if you could…?

• Ease the transition to your growing and changing environment with consistent workflows regardless of the database platform
• Ensure performance SLAs are met while shifting workloads from one platform to another
• Impress Management with cross domain reporting

If you are a DBA who has been thrust into the Open Source and/or NoSQL arena and have been tasked with maintaining its availability and performance, you are not alone. As enterprise data grows and changes, so too does the need to adopt different database platforms. One of the primary challenges traditional (Relational) DBAs face is to efficiently find ways to learn and understand these technologies.

This webinar will cover not only a brief review of Foglight’s core competencies but also an informative and interesting introduction to Open Source and NoSQL technologies…their storied histories, why they were developed, their key strengths, and various ‘flavors’. From there, some common use cases will be highlighted demonstrating how Foglight can simplify the identification of common performance scenarios against MySQL, PostgreSQL, MongoDB, and Cassandra.

Join us and learn how to more efficiently monitor the health of your cross-platform environment.

Oracle Database Standard Edition has supported the use of Real Application Clusters (RAC) for many years, but since 2015, Oracle has made this increasingly challenging for customers.

On 1 January this year, Oracle stated that RAC is no longer supported from Database 19c Standard Edition 2 in a move clearly designed to encourage customers to upgrade to the more expensive Enterprise Edition or migrate to Oracle Cloud Infrastructure.

More recently, Oracle announced the introduction of Standard Edition High Availability (SEHA), which is intended to offer Standard Edition customers an alternative to RAC.

The session will review why using Standard Edition remains important for many customers and explore some of the limitations of SEHA and why customers should seriously consider SharePlex^® if they truly need a HA/DR solution without going to Enterprise Edition.

We’ll focus on the following key points and customer needs:

• Failover vs HA/DR
• Scaling Standard Edition
• Heterogeneous systems
• Rolling upgrades

Virtualization administrators and tools that don’t support the specialized needs of database servers can make your job challenging. If you’ve ever had a sysadmin ask why your server was using all of its RAM, you understand these challenges.

In this session, SQL Server MVP Joseph D'Antoni and Oracle ACE Director Janis Griffin will show you how to overcome these obstacles and improve performance in virtual SQL Server environments.

You’ll learn how to:

• Configure VMs for SQL Server and database workloads
• Troubleshoot and understand where performance bottlenecks can happen
• Follow best practices to quickly and proactively fix performance problems

Speaker: Janis Griffin

Speaker: Brent Ozar 

The next biggest cause of deadlocks is working through tables in long transactions. You'll learn why you need to work through tables in a consistent order and touch them as few times as possible, then we'll rewrite a stored procedure that's having deadlocking problems.

Speaker: Pinal Dave

Execution plans are the first-place database professionals go to tune their query, but they often provide misleading information. The science behind query optimization is knowing what to believe and what to ignore from the execution plan. You’ll learn the 3 biggest issues with the execution plan and tips and tricks to overcome them easily and efficiently to ensure better performance.