Database Training Days: Oracle Resources

Maintaining data integrity is a critical responsibility for database administrators (DBAs). In this foundational session, we'll explore the powerful Database Console Commands (DBCC) toolset, which provides an array of options for validating the logical and physical integrity of your SQL Server databases. We’ll guide you through the setup process, ensuring you're equipped to leverage DBCC effectively.

Topics that will be discussed include:

• The importance of incorporating integrity checks into DBA practices
• Overview of DBCC options and their role in ensuring data consistency and reliability
• Detailed exploration of DBCC parameters and configuration methods
• Introduction to community-driven tools that streamline DBCC processes
• Best practices for integrating DBCC into your database maintenance routines

Speaker:

• Mikey Bronowski
  Data Enthusiast, Microsoft Data Platform MVP, Microsoft Certified Trainer

Feel like you’re the Sherlock Holmes of IT, always working hard to solve SQL Server or Oracle performance mysteries? Well, every Sherlock needs a little help from Watson. In this session, you’ll see how to get the assistance you need to speed up your investigations and quickly take down your fiercest adversaries. Discover how the Foglight® Performance Investigator solution can empower you to keep your database environment running efficiently, allowing you to focus more on strategic initiatives and less on menial tasks. With powerful tools for real-time and historical analysis, you’ll gain the skills needed to piece together the clues and resolve even the most complex performance issues.

Topics that will be discussed include:

• Keeping your database environment running efficiently to minimize time spent on routine tasks
• Utilizing an intelligent, scalable SQL workload analytics engine to piece together real-time and historical clues
• Investigating data on baselines, lock analysis, and change tracking
• Enhancing your detective skills with multidimensional drilldowns and historical session data

Speaker: Pini Dibask, Product Manager at Quest Software

Many companies have data stored in Oracle databases and are at various stages of their cloud computing journey. Whether you're just considering the move or already operating as a cloud-native organization, this session will show you how Quest tools and expertise can help you move, manage, and better understand your data at every phase. Learn how to analyze your data before migration, migrate it to the cloud without downtime or risk, and optimize your cloud resources for maximum efficiency.

Topics that will be discussed include:

• Analyzing your data before migration
• Migrating data to the cloud without downtime or risk
• Optimizing cloud resources for cost and performance
• Managing and understanding data throughout the cloud journey

Speaker

Clay Jackson
Sr. Database Systems Engineer, Quest

Cloud migration is a journey, and migrating your databases requires careful planning, testing, and execution. Ensuring continuous application and database performance is essential for ongoing success. Many companies that migrate their databases to the cloud are often surprised by higher-than-expected subscription costs.

In this on-demand webcast, you'll learn how to navigate the challenges of migrating Oracle databases to Azure cloud services, ensuring minimal downtime and preventing data loss. We’ll explore how to balance cloud costs with manageability, monitor database performance for future scalability, and optimize your Azure cloud subscription to avoid unexpected expenses. Additionally, you’ll discover how to continuously replicate Oracle data between your data center and Azure.

Topics that will be discussed include:

• Strategies for migrating Oracle databases to Azure with minimal downtime and no data loss
• Choosing the right Azure cloud service tier to balance costs and manageability
• Effectively monitoring database performance and ensuring scalability while optimizing costs
• Continuously replicating Oracle data between your data center and Azure

Speaker

John Pocknell
Database Solutions Evangelist, Quest Software

In this session, delve into the utilization of free Linux tools to conduct comprehensive analysis of Oracle database performance. While Oracle software is equipped with excellent instrumentation, certain scenarios require deeper investigation. This session addresses common queries, such as identifying the causes of excessive CPU consumption or sluggish I/O performance. Attendees will gain insights into a range of free tools available on the Linux platform, empowering them to effectively troubleshoot various database-related issues and optimize performance.

Topics that will be discussed include:

• Utilizing free Linux tools for Oracle database performance analysis
• Investigating causes of excessive CPU consumption and sluggish I/O performance
• Conducting comprehensive performance assessments beyond Oracle’s built-in instrumentation
• Troubleshooting complex database-related issues with Linux tools

Speaker:

• Stefan Koehler, Independent Oracle Performance Consultant and Researcher

Performance tuning can be complex, often leaving developers and DBAs uncertain about which adjustments will yield the most significant performance improvements. In this on-demand presentation, Janis Griffin, a seasoned System Consultant at Quest Software, will walk you through five essential steps to quickly identify and resolve performance issues.

Whether you're struggling with SQL statement optimization or trying to understand how new Oracle features impact execution plans, this session provides actionable insights to enhance your database performance.

Topics that will be discussed include:

• Fine-tuning SQL statements for immediate performance gains
• Identifying performance inhibitors to prevent future issues
• Understanding how new Oracle features can impact and support execution plans

Speaker

Janis Griffin
System Consultant, Quest Software

Whether you’re already using Oracle Database in Amazon Web Services (AWS) or considering a migration, this on-demand webcast is designed to help you optimize your cloud experience. Learn how to right-size your service tier, monitor and optimize resource consumption, and secure your data to reduce IT costs. Quest® provides powerful, end-to-end solutions for AWS, supporting you through every step of your cloud journey.

In this session, you'll receive expert advice to ensure a smooth and cost-effective cloud migration and management experience.

Topics that will be discussed include:

• Determining the best service tier for your database workloads
• Preventing database downtime and data loss during migration
• Optimizing AWS cloud subscription costs
• Monitoring cloud performance and ensuring scalability
• Replicating data between on-premises and cloud databases
• Quickly and easily connecting to the cloud
• Strengthening data protection

Speaker

John Pocknell
Quest Software

Your on-call duties shouldn't consume your entire day, but balancing everyday responsibilities with solving new and recurring issues can be challenging. How can you efficiently manage these tasks while still keeping projects and timelines on track? In this session, you'll explore key features of Quest® Toad for Oracle®, such as DB Health Check, Capture and Replay, and History Browser. Discover how these tools can simplify and streamline your on-call duties, allowing you to focus on what truly matters.

Topics that will be discussed include:

• Simplifying on-call duties with DB Health Check
• Managing issues efficiently using Capture and Replay
• Keeping track of changes and troubleshooting with History Browser

Speaker

Albert Rodriguez

Database performance issues can quickly escalate into major problems, but with the right tools and strategies, you can proactively prevent these issues from causing havoc. In this session, you'll discover how to ensure peak database performance by leveraging performance monitoring tools that simplify your work. Learn how to quickly identify and resolve common issues before they escalate, keeping your systems running smoothly.

Topics that will be discussed include:

• Establishing around-the-clock monitoring and diagnostics
• Using alarms and notifications to stay ahead of issues
• Accessing critical data when and where you need it
• Monitoring your database environments on-the-go

Speaker

Denis O’Sullivan

Database migrations and upgrades can often feel like a runaway train of risk, downtime, and stress. But with the right guidance, you can keep your projects on track. In this session, you'll gain expert tips to help you navigate the common pitfalls and risks associated with meeting your database operational goals. Our practical advice will empower you to execute migrations and upgrades with confidence and minimal stress.

Topics that will be discussed include:

• Scaling out your databases effectively
• Ensuring high availability of your critical applications
• Integrating data from multiple data sources seamlessly

Speaker

Michael Sass

Have you watched with envy as application development teams reaped the benefits of agile and DevOps, rapidly releasing products and automating their deployment pipelines? Now it’s your turn to become an international DevOps hero. This session will equip you with the tools, skills, and secret weapons you need to command the respect you deserve in the world of DevOps.

Topics that will be discussed include:

• Achieving both speed and quality without introducing risk
• Applying automation to eliminate bottlenecks
• Breaking down silos between development and operations teams

Speaker

Denis O'Sullivan

In this webcast, you'll learn how to reduce costs and enhance database performance by offloading reporting tasks. Microsoft Cloud Solutions Architect Sri Hari and Quest® Database Solutions Engineer Martin Wild will guide you through the process of safely and efficiently migrating Oracle data to lower-cost Azure SQL and SQL Server databases.

This session will provide practical insights on how to leverage Azure's capabilities to optimize your reporting processes, making it easier to manage and analyze your data without sacrificing performance.

Topics that will be discussed include:

• Offloading Oracle reporting to an Azure PaaS database, such as PostgreSQL, MySQL, or SQL Server
• Using Oracle data in Azure Analytics
• Locating your audit data from Oracle to Azure (CDC)
• Building a data warehouse in Azure that’s based on and in sync with your Oracle data
• Continuously moving Oracle data to Azure SQL Database to accurately and affordably offload reporting

Additional Considerations:

• Optimizing reporting performance on target databases by placing workloads closer to users and segregating reporting workloads to different locations and data sets
• Using a data replication solution that is easy, flexible, accurate, and can handle high transaction volumes with low overhead
• Monitoring the health and performance of your Azure databases
• Addressing network latency and running Azure database workloads

Speakers

Sri Hari
Microsoft Cloud Solutions Architect

Martin Wild
Quest® Database Solutions Engineer