In the example below, the current_date will return today’s date.  Add or subtract a number from the CURRENT_DATE, and you are adding or subtracting days from the date.  If you subtract from two dates, you get the number of days between the two dates. The Dateadd command below adds a specified time interval to a…

Read More

I am fortunate to have the experience of working with one of the largest insurance companies in the world on a big data cloud migration project. This particular company, which I will call big insurance, has one side of their company utilizing a Teradata enterprise data warehouse and the other a Netezza enterprise data warehouse.…

Read More

Snowflake PDF is a masterpiece by Tom Coffing and Dave Cook. Tom Coffing is considered the best technical book author in the world. Tom has written over 75 books on the architecture and SQL of all major database platforms. The Snowflake book is possibly his best work, and Tom’s co-author Dave Cook is the mastermind…

Read More

There is no such thing as a free lunch, but there is free analytics! If you break down an analytic, it is nothing more than math running against a data set. Most vendors have the same fundamental analytics, but each has a few analytics that only they provide. That is when the idea hit me…

Read More

In a recent study, health researchers at the University of Michigan have found that eating a single hot dog could take 36 minutes off your life. Although it is a tough call, having your team use Teradata Studio as the primary query tool could be a better choice; however, a hot dog might leave a…

Read More

I have a customer who is a significant player in the insurance business who uses the Nexus and Nexus Server to migrate data from Teradata, Oracle, and Netezza to Amazon Redshift and Snowflake. Here is a question they asked me recently. Good morning Tom, Quick question.  I have a power user (a very influential power…

Read More

Like a fine wine, the Nexus and Nexus Server have taken 18 years to build, and they keep getting better. Your competitors better hope you haven’t given Nexus to your employees because you now own the future of data access. You can check out a free trial of Nexus at https://coffingdw.com/download-nexus. There are four skills…

Read More

Tom Coffing will show off the Nexus Desktops coordinating with the Nexus Server to join data across platforms with a single click of the mouse.

Read More

Don’t take months or years and spend millions to migrate to the cloud when the technology is present today to migrate in days.  Signup for the webinar below and watch how easy and efficient migration can become.  After the webinar, you can practice migration yourself for free.  Take a test drive, migrate data, and then…

Read More

Imagine Migrating Your Legacy Database to a Modern Database in a manner of minutes or hours versus Months or Years. Reunite your data and free yourself from the chains of legacy vendors!

Read More

Are you migrating thousands of tables to the cloud? Do you want business users to be able to move data between any two systems? Can you imagine giving users the ability to join tables across disparate platforms?

Read More

  Teradata’s QueryGrid product is a brilliant concept that connects Teradata systems to multiple data sources for cross-system functionality.  However, QueryGrid does not compare with CoffingDW’s high-speed Nexus Server. Teradata is a proprietary database, but Nexus combines all database platforms. Teradata broke barriers within the database world by allowing users to join data across several…

Read More

Virtualization allows users with no technical expertise to join data across all on-premises and cloud databases.  Users can also move data from any two systems and ETL teams can migrate thousands of tables.  Having a database like Yellowbrick, where billion-row tables can return an answer set in subsecond times, encryption software from Soterosoft to guarantee the security of sensitive data, and the Nexus Server to convert and migrate between systems is the perfect package.

Read More

The Art of War is attributed to the ancient Chinese military strategist Sun Tzu and remains the most influential book in East Asian warfare and Western cultures.  This book explains Chinese military tactics, from strategy and weapons to rank, discipline, and training techniques. What is truly unique is that Sun Tzu wrote this book in the 5th century BC. During the Sengoku period (c. 1467–1568), the Japanese daimyō named Takeda Shingen (1521–1573) became almost invincible in all battles without relying on guns because he studied The Art of War. The book even gave him the inspiration for his famous battle standard “Fūrinkazan” (Wind, Forest, Fire, and Mountain), meaning fast as the wind, silent as a forest, ferocious as fire, and immovable as a mountain. The new art of war is the Virtualization of data because the tactics allow businesses to wage war on their competition.  Virtualization is the ability to join data no matter where it resides without any technical expertise, and it makes organizations fast as the changing winds of business, ferocious enough to light their sales on fire, silent to secretly understand the relationships the data is telling them, and as immovable as a mountain because their business is on solid grounding.

Read More

The Art of War is attributed to the ancient Chinese military strategist Sun Tzu and remains the most influential book in East Asian warfare and Western cultures.  This book explains Chinese military tactics, from strategy and weapons to rank, discipline, and training techniques. What is truly unique is that Sun Tzu wrote this book in the 5th century BC. During the Sengoku period (c. 1467–1568), the Japanese daimyō named Takeda Shingen (1521–1573) became almost invincible in all battles without relying on guns because he studied The Art of War. The book even gave him the inspiration for his famous battle standard “Fūrinkazan” (Wind, Forest, Fire, and Mountain), meaning fast as the wind, silent as a forest, ferocious as fire, and immovable as a mountain. Virtualization of data is the new art of war.  Virtualization is the ability to join data no matter where it resides without any technical expertise, and it makes your organization fast, ferocious, and movable.

Read More

Will we ever see a world where there are no longer gasoline-fueled cars on the road? Of course!  Why spend money on gas and pollute the planet when you can save mother earth and spend less? Ironically, gasoline as energy will become extinct, just like the dinosaurs that produced it. Will we ever see a world where users won’t care which database system their data came from, but instead query as quickly as doing a browser search over the internet? Of course!  Why spend time and money moving data to a single platform to have a single version of the truth when the truth can reside across many data sources?  Ironically, users with no technical background can now join data across platforms thousands of times faster than today’s best data scientists. Virtualization is the ability to join data no matter where it resides without any technical expertise, and it is as inevitable in data as electricity is to cars!

Read More

Data virtualization allows users to move or join data across database platforms with no technical experience.  Why spend millions moving data when your users can join data across platforms? Data virtualization is the best way to see your data in action, and thus, it has become an important tool for various business lines to get the insights their teams need. Join us on Thursday, January 21st, at 10:00 PST (1:00 EST) for a 20-minute webinar to hear from Yellowbrick, along with two solution partners, Nexus and Soterosoft, to learn how to build a virtualization roadmap.

Read More

I have never seen analytic queries perform faster than on a Yellowbrick Data Warehouse. Today, I will begin a series on how to tune a Yellowbrick system. Today, I will start with one of the most critical fundamentals for tuning any parallel processing system, including Yellowbrick.

Read More