When installing SharePlex one of the things you need to do is verify the installation is working by using the SharePlex test tables before using your own tables. 

There are a couple of scripts you can run to do this but in the video I recorded I show you…

DevOps has been pervasive within Application Development for several years, but the database environment is so different and sensitive in nature, making database development a barrier to an end-to-end DevOps strategy.

The most important element of DevOps…

SharePlex has an interesting feature termed Auto-Add that allows objects to be brought into replication as and when they are created on the source. Essentially the ongoing replication creates the objects in the target database once they are created on…

When very large tables are out of sync on the target and Compare is not a suitable sync option, it requires a set of coordinated steps to bring them in sync with the source tables. This is especially true if the downtime on the source table is not acceptable…

Spotlight on SQL Server Enterprise‘s main purpose in life is to inform you of SQL Server performance problems, and then give you a quick way to diagnose their root causes so you can take action quickly.  Email and mobile app notifications along with…

I'm very happy to report that a new release of Spotlight on SQL Server Enterprise (version 11.7) is now available.  This is a relatively minor release, mostly including fixes, although there are two enhancements worth mentioning.  One that has been…

Whether it’s hitting sys.dm_io_virtual_file_stats DMV with calculated queries, collecting Perfmon Disk Counter statistics, reviewing Resource Monitor Disk information, or keeping your storage admin close by, I/O issues are all too familiar a concern.…

Connecting.
We do it every day.
Person to person – and on a network level, database client to database platform.

Toad for Oracle’s legacy has always been about increasing performance, configuration, and internal self-help in solving technical…

I had a question recently from a customer. They were asking how to keep track of inactive SQL Server instances in Foglight so that the data can be removed. A flip side of this would be to check what instances they have being monitored vs. what is supposed…

“The most significant business benefit of DevOps is faster delivery of features.”

If most of the people you asked about DevOps told you that, wouldn’t it be worth a try?

Think of how much innovation DevOps adoption could introduce to…

I get this question at least once a month and it has to do with transferring Toad for Oracle user settings from one version to an updated version. When you install a new version of the Toad for Oracle 2016 Suite, the installer does a side-by-side installation…

Friends in High Places

I’m starting a blog series about our Toad solution family, and how it’s changed lives for almost 20 years now.  Sometimes a vendor’s product does something extraordinary for its customers.  The stories you read…

Configuring alarms in Spotlight on SQL Server Enteprise is quite easy. Configuring alarms across multiple connections, however, wasn’t always so easy. In versions prior to 11.5, you were required to select a connection and then apply your configuration…

Differential backups make perfect sense….backup only what has changed since the last Full backup. Differential backups dramatically reduce the storage needed to maintain backups, while lowering maintenance windows associated with Full backups. 

Toad for Oracle’s Query Builder window provides a quick method for creating the framework of a SQL queries (Select, Insert, Update, or Delete statement). Additionally, one can select Tables, Views, or Synonyms, join columns, select columns, and generate…

Data scientists are in high demand. Across a range of industries, organizations are searching for highly skilled data scientists (aka data analysts) who can make sense of the rapidly rising volume, variety and velocity of data available today. Those data…

New homes generally rock – and Toad’s new lily pad at Dell is no exception. We’re not saying Quest.com wasn’t great, but Toad is moving up in the world and has a new address at Quest.com.

But as soon as Toad’s all moved in, there…

I’m sure as DBAs we’ve all been there; your IT manager comes to you saying the warranty is expiring on the production database server and asks “do we extend or replace the server”? Both choices lead to further questions. If you decide to extend the warranty…

Over the past three months, we’ve been developing a playbook for winning in the database management tools market guided by Playing to Win: How Strategy Really Works. This best-selling book is co-authored by A.G. Lafley, executive chairman of the…

The mature and stable backup market has seen an influx of innovative technologies over the past few years and organizations can now choose a mix of backup technologies that are just right for them. Backup-to-tape is slowly being phased out and replaced…

Within Toad for Oracle, you can now manually execute Automation Apps within the Toad Intelligence Central Web interface.

In addition, the Toad Intelligence Central Web interface now includes a Team Coding page that displays the status of team coding objects…

Benchmark Factory for Database 7.5 is available for download via the Support Portal. 

“Capturing” is the word of action from this new release.

• Includes capture threshold settings, including CPU utilization, disk space and more to minimize risks…

Starting with version 12.10, Toad for Oracle will bring the Knowledgebase dynamically into the product’s window. No more having to leave an application to search and find answers outside of the product.

Got an error?

No problem.

Click on a button…

As the old saying goes, “the one constant in life is change”, and this is especially true in database environments.  There are many reasons why database environments experience change whether it be through typical maintenance efforts such…

Had a question from a customer today about backing up the Foglight for SQL PI database. The customer wants to automate this using command line and the reference guide asks you to deactivate the agent first, via the UI. 

No problem, I said, there is always…