Blog

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…

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…