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

Today is my 65th birthday. Did you know that your two most vulnerable years are before your first birthday and the first year you retire? So, I have no plan to retire, so I might live forever. I am so fortunate to have been chasing a dream for the last 20 years to do what…

I started programming in the 1970s, but I have made a significant effort to continue to embrace new ideas and technologies. I am concerned about AI and ChatGPT, and although they can be unreliable, I have enjoyed experimenting with them. I uploaded all of my blogs for 2023 and asked ChatGPT what makes my Nexus…

In the fast-paced world of data analytics, having it both ways can be a game-changer, and that’s precisely what Nexus offers. They say you can’t have your cake and eat it too, but with Nexus, you can have powerful analytics both centralized and at your fingertips. Drawing from my extensive experience of teaching over 1,000…

Why do companies think the database is the strategic solution when they all provide the same thing? You submit SQL, and they provide you with a result set, especially when there is so much important data that no database can handle the storage and currency. I’ve taught over a thousand classes and written 90 books…

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…

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…

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…

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…

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…

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…

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…

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…

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…

They call it the Nexus Chameleon because it fits into any database environment, changes colors, migrates data, queries all systems, can build the SQL automatically, and has shocked the data world by joining 20 tables from 20 different cloud, legacy, and open source systems in a single query. No other tool allows everyone to do…

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…