• 15 May 2017

    Overview of Foglight Management Server and Agent Manager upgrades

    How would you like to have a quick reference point for your Foglight Management Server (FMS) or Foglight Agent Manager (FglAm) upgrades? This article is designed to help you determine the best steps to take to upgrade your type of FMS and FglAm. Hyperlinks are included for specific topics which direct to the area of interest in the Upgrade Guide. FMS Types Standalone FMS - Typical installation FMS HA - High...
    • 9 May 2017

    Agile Development: Setting up Team Coding with VCS integration

    Are you using a version control system (VCS) and want to know how to access it from Toad to simplify check-out/check-in? This video shows how to install and configure Team Coding to work with a VCS provider as well as how to define and manage your pr...
    • 4 May 2017

    Toad Allows You to Do More and Not Just Try

    Yoda’s Jedi IT cousin Toada agrees “Do or do not, there is no try!”. It today’s climate of downsizing, staff reductions and the explosion of data sources and data volumes you must be able to do and do more and just trying without the right tools will lead to failure. “Seek help, you must! With less do more. Yes, hmmm” says Toada Automate, Optimize, Document and Diagnose. “Problems...
    • 1 May 2017

    Benchmark Factory – Performance Testing is Critical !!

    One time when I was a little boy, I was driving with my dad and we went over a bridge and there was a sign that read “Weight Limit 10 Tons”. I asked my dad how they figure out how much load the bridge can handle. My dad, being a dad, answered, “Well they build the bridge and then keep driving bigger and bigger trucks over it until it collapses. They then weigh the truck and rebuild the bridge and...
    • 1 May 2017

    Use Compare and Repair to Keep SharePlex Replication From the Dark Side

    "There has been great disturbance in the Force". In the SharePlex galaxy, we call that "out of sync". In a recent blog, SharePlex Jedi Mark Kurtz introduced us to the SharePlex Compare and Repair commands . Here are some additional best practices that that you can use to help bring balance back to the Force in your galaxy. Make Frequent Use of Compare While Post does a great job of detecting...
    • 1 May 2017

    Considerations when projecting database growth using Foglight

    Every now and then I run into a conversation with my clients around planning capacity for anticipated database growth. Although there are straight forward methods for calculating data/log file and object growth rates from catalogued views in the database which lead to linear predictions, there are several considerations that must be taken to make this exercise more appropriate in the real-world. Figure 1 – Instance...
    • 19 Apr 2017

    Oracle Yacht Fund Capsizing Your IT Budget?

    We’re throwing you a lifesaver – catch onto the more affordable OEM alternative. Help! I can’t afford Diagnostics and Tuning packs for performance monitoring with Oracle® Enterprise Manager. Really? You mean you’re not c...
    • 18 Apr 2017

    It only takes a minute to vote!! - DBTA Readers' Choice Awards - Vote for your favorite Quest Products!

    Hello all Information Management product users! Voting is now open for the 2017 DBTA Readers' Choice Awards. The DBTA Readers' Choice Awards Winners will be showcased in a special section on the DBTA website and in the August 2017 edition of Database Trends and Applications magazine. A number of Information Management solutions are contenders in a variety of categories. Unlike other awards programs that...
    • 17 Apr 2017

    Monitoring AWS EC2 Windows Instance with Foglight InfraStructure Cartridge (Host Monitoring)

    The other day I was speaking to a customer about their growth strategy and planning on database management and infrastructure. One of the topic that I really liked is how companies get very creative and innovative. One of the strong drive for them is to adopt the latest technologies, and to transition with minimal disruption internally. They were planning to move some or all of their infrastructure into Amazon’s...
    • 6 Apr 2017

    Exception handling by SharePlex when dealing with out of sync?

    The conventional methodology followed by SharePlex and most other replication solutions is to ignore out of sync DML within a transaction while applying rest of the successful DML to the target database. A transaction may span one or more objects, each having one or more rows, or DML. When posting that transaction, if any row runs into out of sync conditions, the default behavior is to simply discard that row, record...
    • 6 Apr 2017

    Finding your Heavy-Hitting SQL Statements with Foglight for Databases

    A Brief Walk-Through of SQL Performance Investigator In a previous Foglight for Databases / SQL Server blog post, I provided a guide for navigating your database servers’ performance metrics in real-time . That post showed you how to identify your SQL Servers’ current problem areas and then quickly understand the related statements, effected objects and/or root causes. This post will focus on the part...
    • 31 Mar 2017

    Log Shipping in Litespeed v8.5

    Log shipping is a critical feature for disaster recovery. It allows you to automate the backing up of a database (the publisher) and restoring its transaction logs on one or more standby databases (the subscribers). The process runs automatically throughout the day at the interval you specify, which creates synchronized databases. LiteSpeed for SQL Server provides flexible backup options for log shipping and allows...
    • 22 Mar 2017

    New Postgres Section Live on Toad World

    We’re happy to announce a new Toad World section supporting PostgreSQL and sponsored by EDBPostgres. Over the past couple of years, we’ve seen a surge in the adoption of open source relational database platforms. MySQL and Postgres datab...
    • 21 Mar 2017

    Collaborate Tip of the Day: Visit Quest at Booth #1308

    My feet hurt. I’m tired of wandering the floor. Who’s got the best giveaways and Oracle expertise at Collaborate 2017? We don’t want to toot our own horn, but…toot, toot! We’re talking Apple watch giveaways on the dai...
    • 20 Mar 2017

    It's About Time - Oracle Time Data and SharePlex

    Recently, we’ve had a number of questions about how SharePlex replicates Oracle time data; especially in cases where the source and target systems are in different timezones. Here’s a brief tutorial on how Oracle handles time data,...
    • 14 Mar 2017

    Slay SQL Server Dragons In Your Sleep

    Once upon a time, there lived a great king, some would say the king of all DBAs. Every evening, he retired to his castle where he enjoyed long, blissful nights of uninterrupted slumber. He awoke at his leisure, well-rested and ready to rule his doma...
    • 13 Mar 2017

    Would you like to have a direct influence on the Toad Products? Introducing Toad Design Research.

    We need your help. We know you are the experts using our products or how you might want to use our products. Our most valuable data comes from you. When you participate in our research studies, you are talking to people who have direct influence in the design process. One may see an existing product or a new prototype. In addition, we could just chat with you about how you use certain products or ask you to keep a record...
    • 10 Mar 2017

    The PostgreSQL Community, a new Toad World community

    Toad World brings to you a section on Postgres to expand our community for database professionals who are using or are interested in using this powerful data platform. PostgreSQL (or Postgres) is one of the world’s most advanced open-source relational databases, with a reputation for reliability, data integrity, and correctness. SQL-standards based, the database is highly customizable and runs on all major operating...
    • 9 Mar 2017

    Change Data Capture with SharePlex

    SharePlex replication can conveniently be used to maintain a change history target. Another industry jargon for change history is Change Data Capture or CDC. The CDC target maintains historical data on target as opposed to a copy of the source in case of a target in a regular replication. The CDC target is typically used for data mining. SharePlex gathers change data from source database to populate a change history...
    • 8 Mar 2017

    Quest 4 EDB Postgres Webinar

    Come one, Come all! #Quest4EDBPostgres Webinar Your Data is growing and growing and growing as is the cost of your databases and the thought of using an Open Source Database is really starting to look like a sweet way to go…..You’re not ...
    • 7 Mar 2017

    Hadoop's Map Reduce component and example

    I wanted to share the very popular posting from Oracle DBA, Fernando Garcia , within the NoSQL and Cloud Databases Community. Fernando is from Argentina and posted his knowledge in Spanish. With a posting this good, it needed to share amongst the English community as well. An example of using Map Reduce Map Reduce is a component of the Hadoop ecosystem. It consists of a programming model that allows large volumes...
    • 3 Mar 2017

    Forget Fake News, what about Fake Data?

    Over the past few months we’ve all seen how “fake news” and “alternative facts” can influence a presidential campaign, but it’s not just world leaders who can be affected. “Fake data” has the potential to cause chaos within organisations. People talk about being in the Information Age, but for organisations it’s more like the Data Age, epitomised by trends such as...
    • 1 Mar 2017

    Toad Turnpike: Tuning Database Object Access Patterns

    Robbing Peter to Pay Paul on the Database Performance Teeter-Totter: Part 2 of 2 In the previous post, Robbing Peter to Pay Paul , a DBA named "Alex" outlined what happened when he introduced a new index to speed up one user’s ...
    • 27 Feb 2017

    Spotlight Alarms and Powershell Execution

    Spotlight notifies DBAs of performance issues via triggered alarm messages. More importantly, specific actions can be taken based on these alarms, by configuring the Alarm Actions feature of Spotlight. Read our blog about Alarm Actions configuration steps to learn more. Some common actions are sending an email, suppressing the alarm or running a program. Additionally, executing a Powershell script is another available...
    • 27 Feb 2017

    Use SharePlex to Replicate Oracle Data to Amazon RDS

    In a previous blog we introduced you to SharePlex 8.6.6, which is certified to replicate data to Amazon and Azure Cloud Databases . In this blog, we’ll show you how easy it is to set up replication from an Oracle database , either on-...