Blog

I wrote my first 50 books on Teradata, but then I got smarter and wrote my next 50 on all the other incredible databases. Of course, you have access to my books for free. I will show you today what nobody else can do for the next decade: integrate Snowflake, Databricks, BigQuery, Amazon Redshift, and…

Mr. Coffing: Your mission, if you decide to accept it, is to make data flow like water between every major database. And you must finish the task within 20 years. Mission accomplished! The most difficult thing about every database is they cannot and will not communicate with other databases. However, I accepted the mission to…

Most people have never imagined writing a two-table join where tables reside on different database platforms. However, today, you will see a join of 20 tables from 20 separate systems in a single query! And the entire process is automated, so anyone can do it without technical expertise. The architectural superiority it takes to pull…

To show appreciation to our fellow data professionals, we are giving away our incredible books for FREE. For example, the Snowflake Architecture and SQL book, an 1130-page masterpiece with hundreds of brilliant Snowflake tips and tricks, best practices, and SQL examples, is now FREE. But you can also download our books on Synapse, Redshift, Google…

To show appreciation to our LinkedIn group members, we are giving away our Snowflake Architecture and SQL book, an 1130-page masterpiece with hundreds of brilliant Snowflake tips and tricks, best practices, and SQL examples, for FREE. You can download the PDF from our CoffingDW.com website immediately. Here is how you do it. Go to CoffingDW.com…

The greatest breakthrough became official yesterday with the latest release of Nexus because the world can now join tables from Databricks and Snowflake in a single query. And Nexus does all of the intelligence work automatically. Almost impossible to believe that you can join Databricks and Snowflake tables with Google BigQuery, Azure Synapse, Amazon Redshift,…

Twenty years ago, we thought computing would change so quickly and dramatically that nobody would see it coming, so we got to work. What did we miss in our quest to prepare you for 2024 computing? Nothing! Even today, most people don’t believe joining data across legacy and cloud computing is possible, but it is…

It is so intelligent that it writes the SQL for you across all systems. Even better yet, it writes the SQL to join data across systems. That is why they call it the Nexus Super Join Builder, the greatest tool for data ever invented. According to Safari books which company has written 96 percent of…

Here is a tutorial to show you how to use the Nexus Super Join Builder for federated queries. You will see all the amazing features the Nexus places at your fingertips. Joining tables from separate systems in a single query is often considered an unattainable goal by most individuals and database companies. However, Nexus defies…

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.…

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…

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…

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…

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…

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…

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,…

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,…

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,…

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…

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…