It doesn’t matter what type of organization you are; small, big, public or private – everyone has a database of some description. Databases come in many forms from Microsoft Exchange, Oracle, SQL to a litany of lesser known databases. The database, for…

How Available Is Your Master Data?

A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their…

In part one of monitoring Raspberry Pi with Foglight, I showed that the Infrastructure agent worked pretty much as expected when collecting from the Raspbian OS.

I was curious though if it exposed any metrics via snmp. 

The first step was to check if snmpd…

I once attended an excellent training on giving effective software demonstrations, and the main point was simple: Don’t make your audience wait - show them the good stuff FIRST!

So here it is, in just three steps in Spotlight on SQL Server Enterprise…

I had the pleasure of presenting, along with my colleague Anat Dror, on the SQL Server 2016 Query Store at the PASS Summit last week, and the interest level was phenomenal.  It's clear that this is a feature that DBA's are really eager about giving a spin…

Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.

Sometimes it…

SharePlex peer-to-peer setup

Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…

I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'

I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…

Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…

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…

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…

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…