Blog

I called the Nobel committee to nominate myself for the prize, and they asked me point blank, why on God’s green Earth would we consider your book for a Nobel Piece Prize? I told them the Vertica Architecture and SQL book breaks down all the cool Vertica features, peace-by-peace. And it is a 1024-page masterpeace…

I called the Nobel committee to nominate myself for the prize, and they asked me point blank, why on God’s green Earth would we consider your book for a Nobel Piece Prize? I told them the Google BigQuery SQL book breaks down all the cool BigQuery features, peace-by-peace. And it is a 485-page masterpeace with…

I called the Nobel committee to nominate myself for the prize, and they asked me point blank, why on God’s green Earth would we consider your book for a Nobel Piece Prize? I told them the Amazon Redshift Synapse Architecture and SQL book breaks down all the cool Redshift architecture features, peace-by-peace. And it is…

I called the Nobel committee to nominate myself for the prize, and they asked me point blank, why on God’s green Earth would we consider your book for a Nobel Piece Prize? I told them the Azure Synapse Architecture and SQL book breaks down all the cool Microsoft Synapse architecture features, peace-by-peace. And it is…

We broke another record by joining 19 Excel spreadsheets with a production table on Postgres, and the process took minutes to set up and execute. Our previous blog and video demonstrated how easily we could join 20 tables spanning 20 different systems in a single query. So, we decided to stress-test our ability to import…

The secret behind a non-technical user joining 20 tables across 20 systems in a single query is a modern software architecture we call Nexus. We provide Nexus software for the user’s desktop or laptop with an option to schedule jobs on a Nexus Server, which is software that companies install on a windows server on-premises…

For the record, I am not the world’s greatest data scientist. I am 63 years young, but I will celebrate 50 years of working in the computer industry in three years. People continue to tell me I am the greatest data scientist the world has ever known, but it is not true. I only appear…

For almost 30 years, the largest companies in their vertical have trusted Tom Coffing and the Nexus for their data warehouse books, training, and software. Tom’s Nexus development team has been evolving and improving the product for 18 years with a mission to query all systems, migrate data between any two systems, and join data…

My team and I celebrate Halloween by using Nexus to do a 15-table join across 15 different systems in a single query, which has taken us 18 years to accomplish. Scary, but slow and steady wins the race! In this example, Nexus joins tables across the cloud, enterprise data warehouse, legacy, OLTP, and open-source systems…

You have data in about 18,000 places, and you know that if you could integrate the right data, you are minutes away from world domination. You are two minutes away from understanding that migration across all systems is now an automated process. It took almost 20 years to make the Nexus software act like a…

So, you are moving to the cloud to save money. Save even more money by mixing your Teradata, Oracle, and Snowflake systems with inexpensive and open-source systems like Hadoop, MySQL, Aurora, Athena, and Postgres, also available on the cloud. The biggest hurdle is fear and uncertainty because 95% of people don’t know how easy migration…

Are you considering migrating from Oracle to Amazon Redshift? Smart move! Converting the table structures and data types from Oracle to Redshift takes seconds with Nexus. Building the load scripts for each table takes the Nexus half a second. Large Oracle systems can take time because many companies want to gradually migrate the data to…

Are you considering migrating from Oracle to Postgres? Smart move! Converting the table structures and data types from Oracle to Postgres takes seconds. Building the load scripts for each table takes seconds. Large Oracle systems can take time because many companies want to gradually migrate the data to Postgres. Another smart move! So, customers also…

Only one query tool is so sophisticated that a business user with no technical knowledge can migrate 20 different database platforms to Snowflake or between any two database systems. You are about to see a video of how business users are migrating data to Snowflake with the click of a button in the blink of…

Survival is not the norm; it’s the exception. Humans have evolved more than any other species on Earth. Plants, insects, fish, and other mammals are beautiful, but humans are the dominating force. Nothing evolves faster in today’s world than business because of the power of data and analytics. A company’s survival and the survival of…

Thomas Edison spent 10,000 hours testing to build one of the great inventions of all time, the electric lightbulb. As a kid, I dreamed of becoming Thomas Edison, not Thomas Coffing, but I have spent what seems like 1,000,000 hours attempting to get all databases to integrate seamlessly. It took Thomas Edison two years to…