Blog

You will love this blog because date functions and formatting differ dramatically between databases, but I have covered that with brilliant examples and clear and concise explanations below. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best…

You will love this blog because date functions and formatting differ dramatically between databases, but I have covered that with brilliant examples and clear and concise explanations below. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best…

You will love this blog because date functions and formatting differ dramatically between databases, but I have covered that with brilliant examples and clear and concise explanations below. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best…

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…

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…

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

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…

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…

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…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Azure Synapse in a live demo. You will also see a federated query between Snowflake and Azure Synapse across two clouds! Below is your data, with a week of sales data for three products. Below…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Snowflake in a live demo. You will also see a federated query between Snowflake and Azure Synapse across two clouds! Below is your data, with a week of sales data for three products. Below is…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Yellowbrick in a live demo. The result will be a week of your sales data on one line per product_id. Below is your data, with a week of sales data for three products. Below is…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Vertica in a live demo. The result will be a week of your sales data on one line per product. Below is your data, with a week of sales data for three products. Below is…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Amazon Redshift in a live demo. You will also see a federated query between Redshift and Snowflake! Below is your data, with a week of sales data for three products. Below is an example of…

I recently saw join syntax that I had never seen before in my 50-year career: NATURAL INNER JOIN. As I was curious about what that even meant, I decided to investigate, and it is extremely clever. Many databases now have the NATURAL INNER JOIN or NATURAL OUTER JOIN capability, which you will see below. It…

Not all databases or clouds are created equal, especially regarding pricing and features. So, don’t commit to a single database or cloud for the next five years and become trapped. Commit to none and realize you can use them all depending on your ever-changing needs. Database vendors and cloud providers want you to commit to…

I recently saw join syntax that I had never seen before in my 50-year career: NATURAL INNER JOIN. As I was curious about what that even meant, I decided to investigate, and it is extremely clever. Yellowbrick also has a NATURAL OUTER JOIN capability, which you will see below. It is such a revolutionary advancement…

I recently saw join syntax that I had never seen before in my 50-year career: NATURAL INNER JOIN. As I was curious about what that even meant, I decided to investigate, and it is extremely clever. Vertica also has a NATURAL OUTER JOIN capability, which you will see below. It is such a revolutionary advancement…

I recently saw join syntax that I had never seen before in my 50-year career: NATURAL INNER JOIN. As I was curious about what that even meant, I decided to investigate, and it is extremely clever. It is such a revolutionary advancement that I assembled a five-minute video to explain it across multiple databases. Like…

For the first time in history users can join tables across all systems in their enterprise. Since the beginning of the first database platform systems could not communicate, but cracking the code has been the biggest game changer the industry has ever seen. No matter whether it is cloud, legacy, or open-source systems the Nexus…