Blog
Nexus is Free to Everyone Until February 15th
Below is a Universal license key for you to try Nexus until February 15, 2024, which is a three-month license. Please share it with everyone in your company so they can also try Nexus Version 18. EKHN0-W0T00-2GF18-F848V-1I1RB-8Z7HVN Here is why this could change your career and set your company on a path that leaps them…
Read MoreThe Greatest Data Warehouse Exists In Your PC
A data warehouse and your PC process data with a CPU, memory, and disk, so why not make the PC the greatest data warehouse? Nexus Version 18, released today (Nov 9, 2023), allows every company and user to use the millions of CPUs within your company to migrate or join data instantly across all databases…
Read MoreRogue IT Data Analyst Makes Daring Escape
Can you imagine the horror of going to prison? Yet, every day, anyone working with data is sentenced to life in database prison, and they don’t even know they’re behind bars and line charts with a cellmate named Worksheet. In database prison, you can’t run a query involving tables across database platforms, and migrating or…
Read MoreBreaking News – Analyst Escapes From Database Prison
Can you imagine the horror of going to prison? Yet, every day, anyone working with data is sentenced to life in database prison, and they don’t even know they’re behind bars and line charts with a cellmate named Worksheet. In database prison, you can’t run a query involving tables across database platforms, and migrating or…
Read MoreIt’s the Dates and Timestamps that Byte You
As someone who has taught over 1,000 database architecture and SQL classes on all systems and written over 90 books, I can tell you that the date and timestamp syntax differences across databases will bite you. I have written multiple blog posts to ensure you have a clear picture of the dates and timestamp functions…
Read MoreThe Data Warehouse is DEAD!
One of the most exciting opportunities in my career was training corporations on their Teradata Enterprise Data Warehouse. I was one of the original teachers at Walmart, AT&T, Bank of America, and Bell Labs, and I eventually taught over 1,000 classes across 5 continents. The Enterprise Data Warehouse concept allowed thousands of users to access…
Read MoreTom Coffing “Cloud Series” Books Now Free
I love that my 90 books on database architectures, performance tuning, and SQL have helped millions, so I am giving them away for FREE. They normally cost $199.00 a piece. You can now download my books on Snowflake, Databricks, Google BigQuery, Amazon Redshift, Synapse, Oracle, DB2, Yellowbrick, Vertica, MySQL, Postgres, and more. Here is how…
Read MoreThe Crucial Role of Joining Tables Across Different Systems in Modern Business
In a world where data is the linchpin of success, joining tables across different systems is not just a convenience; it’s a necessity. Combining tables across any two systems in a single query is even more important as organizations migrate to the cloud. As we navigate the complexities of modern business, data integration should be…
Read MoreDive into Dazzling Databricks Date Functions
Below the video are dazzling date functions on Databricks. However, you can first witness a the amazing video that shows how our customers are using Nexus to integrate Databricks with all other relevant databases, including Snowflake, BigQuery, Amazon Redshift, and Azure Synapse. You will soon be able to download our incredible book on Databricks, but…
Read MoreThe 20-Table Federated Join Spanning 20 Systems That Changed the World of Data
There is no I in TEAM and no AI in Nexus, but this year’s miracle is joining data across systems with the click of the mouse. Nobody on Earth can show you a 20-table join involving 20 different systems in a single query except us. Today, almost everyone needs to join data across multiple systems,…
Read MoreAll Databases are Created Equally
Nobody loves a database like me. Nobody knows more about every database than I do. I have written 85 books on every relevant system, taught over a thousand classes, put out hundreds of videos, and built the only software to integrate them all equally! You probably only work with one or two databases, yet your…
Read MoreTotally Integrate Snowflake, Databricks, BigQuery, Redshift, and Synapse
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…
Read MoreThe Mission Impossible of Data
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…
Read MoreThe Technology that Flatfooted Snowflake, Microsoft, Oracle, Teradata, and Google.
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…
Read MoreFREE Books – Snowflake, Redshift, BigQuery, Synapse and More
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…
Read MoreFREE – Snowflake Architecture and SQL Book
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…
Read MoreJoin Databricks to Snowflake to BigQuery to Synapse to Redshift to Everything
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,…
Read MoreThe Complexity of Analytics In the Year 2024
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…
Read MoreSo Intelligent It Writes The SQL For You
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…
Read MoreHow to use the Amazing Nexus Super Join Builder for Federated Queries – Tutorial
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…
Read More