Federating Data Across Systems - The Paradigm Shift
The latest version of Nexus and the Nexus Server is available on our websites at CoffingDW.com or NexusDataServer.com for you to...
top of page
Search
tomcoffing
Jan 22, 20232 min read
World Record - 19 Excel Spreadsheets Join to A Table
We broke another record by joining 19 Excel spreadsheets with a production table on Postgres, and the process took minutes to set up and...
573 views0 comments
tomcoffing
Jan 17, 20233 min read
Secrets Behind a 20-Table Join Spanning 20 Systems
The secret behind a non-technical user joining 20 tables across 20 systems in a single query is a modern software architecture we call...
717 views0 comments
tomcoffing
Jan 13, 20231 min read
Can a Business User (raised by wolves) Migrate 20 Systems to the Cloud?
Can a business user raised by wolves migrate 20 different systems to the cloud? Of course, I might have exaggerated the raised by wolves...
29 views0 comments
tomcoffing
Nov 16, 20224 min read
I am not the World's Greatest Data Scientist
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...
26 views0 comments
tomcoffing
Nov 13, 20221 min read
World Record! Nexus Does 20-Table Join Across 20 Systems
For almost 30 years, the largest companies in their vertical have trusted Tom Coffing and the Nexus for their data warehouse books,...
3,248 views0 comments
tomcoffing
Nov 7, 20221 min read
Teradata Row_Number Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
27 views0 comments
tomcoffing
Nov 7, 20221 min read
MySQL Row_Number Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
6 views0 comments
tomcoffing
Nov 7, 20221 min read
Google BigQuery ROW_NUMBER Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
21 views0 comments
tomcoffing
Nov 7, 20221 min read
Azure Synapse ROW_NUMBER Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
19 views0 comments
tomcoffing
Nov 7, 20221 min read
Amazon Redshift ROW_NUMBER Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
9 views0 comments
tomcoffing
Nov 7, 20221 min read
Oracle ROW_NUMBER Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
4 views0 comments
tomcoffing
Nov 7, 20221 min read
Snowflake ROW_NUMBER Analytic
Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual?...
33 views0 comments
tomcoffing
Nov 4, 20221 min read
ROW_NUMBER Analytic For Postgres
Migrate to Postgres, use advanced analytics, and save money. This blog teaches you how to use the ROW_NUMBER ordered analytic to find...
36 views0 comments
tomcoffing
Oct 30, 20222 min read
Nexus Does 15-Table Join Across 15 Systems
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...
26 views0 comments
tomcoffing
Oct 24, 20222 min read
2-minutes to Cloud Migration and World Domination
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...
51 views0 comments
tomcoffing
Oct 24, 20223 min read
Save on Teradata, Snowflake, and Oracle with Inexpensive and OpenSource Databases
So, you are moving to the cloud to save money. Save even more money by mixing your Teradata, Oracle, and Snowflake systems with...
37 views0 comments
tomcoffing
Oct 21, 20222 min read
Oracle to Amazon Redshift: Migrate, Federate, and Search
Are you considering migrating from Oracle to Amazon Redshift? Smart move! Converting the table structures and data types from Oracle to...
14 views0 comments
tomcoffing
Oct 20, 20222 min read
Oracle to Postgres: Migrate, Federate, and Search
Are you considering migrating from Oracle to Postgres? Smart move! Converting the table structures and data types from Oracle to Postgres...
232 views0 comments
tomcoffing
Oct 19, 20222 min read
How a Business User Migrates 20 Systems to Snowflake
Only one query tool is so sophisticated that a business user with no technical knowledge can migrate 20 different database platforms to...
153 views0 comments
bottom of page