• 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-...
    • 21 Feb 2017

    Two additional free powerful Toad Data Point tools available to use

    In this blog, I would like to focus on an article that Toad Data Point Product Manager, Julie Hyman, shared within the Toad World community. These two tools are the Toad Intelligence Central Community Edition and the Toad Data Point Viewer . Many users may not be aware that these tools are readily available to use and they are free. Yes, absolutely free! Centrally Publish and Share Your Work with Toad Intelligence...
    • 20 Feb 2017

    The Importance of Performance Benchmarking to Decrease Op Ex

    Throughout my career I have conversed with many IT leaders that have adopted the practice of measuring the performance of their technology assets by monitoring key performance indicators (or KPIs). Most of them will tell you that there needs to be some standard against which KPIs are measured and compared. The process of comparing a set of key performance metrics against some kind of objective standard is a form of benchmarking...
    • 14 Feb 2017

    Shared LOVE between Toad and Toad Intelligence Central – The Power Couple

    It’s Valentine’s Day, and power couples everywhere are celebrating. Have you noticed how the biggest power couples share the love by dedicating themselves to a worthy cause? Mark and Priscilla focus on human potential and equality . Beyonc...
    • 14 Feb 2017

    Getting Organized Using Toad

    Toad has so many features and RDBMS' have so many objects it can sometimes be difficult to mesh them together to accomplish the tasks at hand. Wouldn't it be great if there were ways to have these organized in the way you need vs ...
    • 8 Feb 2017

    Secure Automation Using Toad for Oracle

    While Toad for Oracle has had Automation for a long time now it has been necessary to run it on your desktop. While this is an important feature this limitation made it not ideal for organizations where security is imperative, such as in t...
    • 7 Feb 2017

    Enhancement in SharePlex 8.6.6 for Replication from Oracle to Kafka

    If you are currently using ActiveMQ to consume data produced by SharePlex from Oracle, you may want to look into the performance gains with Kafka. The use cases for Kafka include website activity tracking, metrics, log aggregation, stream processing, event sourcing and commit log. There are several enhancements included in the new release of SharePlex 8.6.6 for replication from Oracle to Kafka. Support for multiple...
    • 6 Feb 2017

    SharePlex Can Help You Move Your Databases To The Cloud

    Almost every business is at least considering moving some of their IT workload to “the cloud” for any number of reasons. Databases are often a major component of this workload. SharePlex 8.6.6, certified for Cloud ...
    • 6 Feb 2017

    SharePlex Tuning 101 - A Journey, Not A Destination

    In recent SharePlex blogs , my colleagues and I have discussed using the Analyze Config command to help gather information to tune SharePlex , and the importance of tuning the target database. In this blog, I’ll attempt to put it all togeth...
    • 1 Feb 2017

    Online Transactions and Batch Jobs Don’t Get Along

    Running both online transactions and batch jobs like reporting or analytics can compromise the performance of one or the other. For example, reporting indexes could adversely affect the performance of your Oracle database to your OLTP users. Having ...
    • 31 Jan 2017

    Configuring Subversion integration with Toad for SQL Server, DB2, and SAP Databases

    I've been seeing more customers ask about integrating Toad with their version control systems. Toad for Oracle users have enjoying that for a long time, but now other Toad products are picking up support as well. Subversion is an easy way to get started with version control. In this step by step tutorial, I'll show you how to integrate the Toad .NET products (Toad for SQL Server, Toad for DB2, and Toad for SAP...
    • 31 Jan 2017

    Toad Turnpike: Tuning Database Object Access Patterns

    Robbing Peter to Pay Paul on the Database Performance Teeter-Totter: Part 1 of 2 ... Within the previous month alone, I’ve had three different customers ask me the same identical question: “Does Quest have a solution that re...
    • 31 Jan 2017

    How to Resolve Backlogs in SharePlex Using Named Post Queues

    I’m sure we’ve all gone to an amusement park like Disneyland or Knots Berry Farm. We all love the thrill and excitement the rides give us. What we all hate though are the lines we have to wait in for each ride....
Read Tech Center Blog Posts RSS