Blog

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Yellowbrick handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and IBM DB2 handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Teradata handles them uniquely with the FORMAT and TO_CHAR functions, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Amazon Redshift handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Azure Synapse handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and SQL Server handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Databricks handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Google BigQuery handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me…

You will love this blog because date, timestamp 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…

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…

I might be setting myself up for disappointment, but my goal for this blog is that it is the greatest blog of all humankind. My hopes are high because date functions and formatting are the Achilles Heel for everyone working with SQL, especially when you move to a new system. After all, each database treats…

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…

Tom Coffing has lived an exciting life showing off incredible range and versatility, including becoming an NCAA All-America wrestler for the University of Arizona, winning two regional Olympic trials in 1980, winning the Toastmasters National Championship as a humorous speaker, and multiple acting awards. However, Tom Coffing has recently been named one of the top…

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