Blog
20 Table Join Spans 20 Systems To Shock The World
Most people have never imagined writing a two-table join where tables reside on different database platforms, called a federated query. However, federated queries are so easy that Nexus writes them for you. There is so much data out there that no single system can hold it all, so joining across systems is the new standard.…
Read MoreThe Friendliest Yet Most Powerful Federated Data Tool Ever Invented
After programming for ten years, writing 85 books, and teaching over 1,000 classes on the architecture and SQL for all databases, I knew I could design the friendliest yet most powerful federated tool ever invented. Most people believe that Nexus is a query tool that works across all databases, and yes, it is true, but…
Read MoreUnite All Databases Into One Giant Ecosystem
My dream to unite all database systems into one giant ecosystem began 20 years ago when I realized the value of data would create a data tsunami that no single system could hold. There was only one problem. Database vendors hate one another, and no database integrates with another. The solution took 20 years to…
Read More“Unleashing the Power: Seamlessly Unite Databricks and Snowflake Across All Systems with Nexus!”
Every single day at Coffing Data Warehousing is an electrifying adventure that pushes the boundaries of what’s possible in the realm of data. We are trailblazers, constantly shattering records and achieving feats that no one else on this planet has ever dared to dream of. And the exhilaration doesn’t stop there! Our latest triumph involves…
Read MoreNexus – Closest Data Tool To AI With No AI
Nexus has no AI functionality like ChatGPT, yet, Nexus automates the integration and conversion functions across all database platforms. Nexus is the closest thing to AI without using any AI. My goal as a designer has always been to automate the most difficult and impossible tasks of working with big data. At the beginning of…
Read More20-Table Join Across 20 Systems is 20X Faster
We have found a technique on all Postgres databases to move 20X faster, so our migrations and federated queries have blistering speeds. I put together a 2-minute video showing a 20-table join that spans 20 systems to show the speed, versatility, and impact this will have on everyone in the computer industry. Why put all…
Read MoreGreat Teradata Date Functions To Know
Below the video are great date functions on Teradata. However, you can first witness a two-minute video that joins a Teradata table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, MySQL, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat MySQL Date Functions to Know
Below the video are great date functions on MySQL. However, you can first witness a two-minute video that joins a MySQL table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat Postgres Date Functions To Know
Below the video are great date functions on Postgres. However, you can first witness a two-minute video that joins a Postgres table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat Greenplum Date Functions To Know
Below the video are great date functions on Greenplum. However, you can first witness a two-minute video that joins a Greenplum table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…
Read MoreGreat Date Functions for Azure Synapse
Below the video are great date functions on Azure Synapse. However, you can first witness a two-minute video that joins a Synapse table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…
Read MoreGreat Google BigQuery Date Functions to Know
Below the video are great date functions on Google BiqQuery. However, you can first witness a two-minute video that joins a BigQuery table with tables from Databricks, Snowflake, Redshift, Azure Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books…
Read MoreGreat Amazon Redshift Date Functions To Know
Below the video are great date functions on Amazon Redshift. However, you can first witness a two-minute video that joins a Redshift table with tables from Databricks, Snowflake, Yellowbrick, Vertica, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books…
Read MoreMastering Date Functions on Vertica
Below the video are incredible date functions on Vertica. However, you can first witness a two-minute video that joins a Vertica table with tables from Databricks, Snowflake, Redshift, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books on…
Read MoreJoin tables from Databricks, Snowflake, Redshift, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Vertica, MySQL, Postgres, Microsoft Access, and Excel in a single federated query.
You are about to witness a two-minute video showing Nexus join tables from Databricks, Snowflake, Redshift, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Vertica, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. The first amazing feat is that a user with no technical expertise can build and run it, and…
Read MoreThe Query Tool with an ETL Engine that COULD Federate
Nexus is a query tool with an ETL engine that could federate. Analytics on data is the gold that runs every successful business, and business is good because today’s companies grab as much data as possible to analyze later. The key is to store it somewhere cheap until it’s time to analyze. Nexus queries all…
Read MoreWhy Your Database Vendor Hates Our Guts!
I love a good database, but unfortunately, I revolutionized the industry, and they hate my guts because nobody saw it coming. There isn’t a database on planet Earth that talks to another database. Therefore, each table syntax, data type, SQL, and load utility differs. A database vendor’s business is retention, and business has been good,…
Read MoreThe LEAD Analytic Function on Postgres – Working Session
The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Postgres in a live demo. You will also see a federated query between Postgres, Snowflake, and Oracle across clouds! Below is your data, with a week of sales data for three products. Below is an…
Read MoreThe LEAD Analytic Function on Databricks – Working Session
The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Databricks in a live demo. You will also see a federated query between Databricks and Snowflake across two clouds! Below is your data, with a week of sales data for three products. Below is an…
Read MoreThe LEAD Analytic Function on Oracle – Working Session
The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Oracle in a live demo. You will also see a federated query between Oracle and Snowflake across two clouds! Below is your data, with a week of sales data for three products. Below is an…
Read More