Blog

Someone recently asked me, “What are the secrets of Nexus’s seamless integration across all systems?” You have to get everything right. Databases were never meant to communicate and cooperate. How each database creates tables, builds objects, and loads data is radically different. So, you have to understand each database completely and master these fundamentals. In…

The integration of Excel worksheets with our data warehouse tables is a crucial aspect of data management. While it may seem like a minor detail, this integration holds immense importance for our organization’s efficiency, accuracy, and decision-making processes. Why? Data Consistency and Integrity: By joining Excel worksheets to our data warehouse tables, we ensure consistency…

One of the funniest lines from the movie Animal House was when John Belushi said, “Seven years of college down the drain.” However, there is a problem with the data that nobody knows about, including me, which caused me to state, “14 years of development down the drain.” The dream I had been working on…

Introducing Snowflake’s Time Travel feature is like unlocking the gates to a realm where the past, present, and future of your data converge in a symphony of efficiency and reliability. Imagine a world where you not only have a snapshot of your data frozen in time, but you can also journey seamlessly through its evolution,…

A federated query joins tables across database systems, and today, you will see 19 tables joined across 19 systems and a wide variety of techniques to federate humongous amounts of data quickly and efficiently. Federating data should be compared to driving a car in rush hour traffic because it’s complicated, and a million things could…

You have probably seen SQL for a 20-table join, but you have never seen a 20-table join where the tables are located across 20 different systems. You will see that happen today. You might think that NASA would be the organization tech-savvy enough to crack the code to make all databases join, but the first…

AI or Artificial Intelligence can use advanced data analysis and predictive modeling to benefit energy consumption, reduce waste, improve environmental conservation efforts, improve agricultural practices, maximize crop yields, and early detection of natural disasters. Overall, AI holds promise in fostering a more sustainable and harmonious coexistence between humanity and Mother Earth. However, EI or Experienced…

Do you know what weapon was deemed so powerful by experts of the day that it was thought to end all war because those who held it were invincible? The crossbow is believed to have been invented in ancient China in the 5th century BCE and spread to other regions, including Europe, where it became…

The largest companies in their industry don’t write SQL because the SQL is automatically written for them. Everyone merely points and clicks from a menu to see what tables join, and then they choose the columns they want on the report. The average query is a five-table join, ready to run in seconds. Once the…

One of my biggest regrets was not learning SQL-ordered analytics and window functions immediately. Because I was unclear and frightened, I put them off for years, yet they are so easy and powerful once you understand them. So, I put together a 20-minute video on YouTube that will make you an absolute analytic genius. Below…

In the old days of IT, we only queried one system. Still, I always believed that data would become so valuable that we would soon need to access many databases and seamlessly join data across them. In our tests, we could join 30 tables spanning 30 systems in a single query, and it took minutes…

When I look up on Google how to format a date on a specific database I see many short blogs with a few lame examples that don’t tell the whole story, so I decided to do something about it. My comprehensive study put together a staggering 35,000 date format examples across the top 15 databases.…

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…

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…