Blog
17,000 Teradata Timestamp Format Examples
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…
Read More20,000 Amazon Redshift Timestamp Format Examples
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…
Read More20,000 Azure Synapse Timestamp Format Examples
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…
Read More20,000 SQL Server Timestamp Format Examples
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…
Read More20000 Databricks Timestamp Format Examples
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…
Read More20,000 Google BigQuery Timestamp Format Examples
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…
Read More17,000 Oracle Timestamp Format Examples
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…
Read More5000 Snowflake Timestamp Format Examples
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…
Read MoreDate Functions and Formatting for all Major Database Systems
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…
Read MoreMastering Date Functions on SQL Server
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…
Read MoreMastering Netezza Date Functions
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…
Read MoreMastering IBM DB2 Date Functions
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…
Read MoreMastering Oracle Date Functions
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…
Read MoreTom Coffing Named as Top 50 Cloud Influencer
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…
Read MoreThe Secrets to Seamless Integration Across All Database Platforms
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…
Read MoreFive Reasons to Integrate Excel with a Data Warehouse
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…
Read MoreFourteen Years of Development Down the Drain
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…
Read MoreSnowflake’s Time Travel Feature
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,…
Read MoreGame Changer – The Art of Federated Queries on Humongous Data
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…
Read MoreCoffing’s First to Crack Code to Make All Databases Join
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…
Read More