Tom Coffing - Software connecting all databases

Federated Query and ETL Software

Here are three reasons why Snowflake is changing the Cloud computing world. Every single SQL statement I have ever seen from every other database vendor works on Snowflake. I have never seen anything like that in the 30-years of teaching SQL. Why is this nearly impossible feat important? Companies can instantly migrate data to Snowflake…

In good times and in bad, it is essential to save money. So many companies are using dozens of different tools to access data, and the penalty is millions of dollars per year. And the truth of the matter is most of these tools don’t share reports or queries with others. It is every man and woman for themselves. It may sound too good to be true, but you can give everyone a much better toolset, and allow everyone to be on the same team. You also need your people to access data both on-premises or in the cloud. And unfortunately, in today’s climate, you need a tool where everyone can perform all of their duties from home, but execute the work from an internal Server.

The only architecture able to accomplish the ability to federate, migrate, and query great is to implement an intelligent Windows Server, which we call the Nexus Server. The Nexus Pro desktop automatically builds federated queries, can join Excel to production tables, writes the SQL for the user, and allows the user to query every database platform on the market. Still, the Nexus Server runs the jobs for the user.

They say you can’t be in two places at one time, but I beg to differ. You can work from home, but access data across any platform as if you were sitting in your corporate office. The future of computing is accessing any data, at any time, anywhere, and doing so from your home. You do this with laptop software coordinating with a Server.

Query any system and then take any answer set and Pivot, or place it in a Spreadsheet, Graph/Chart it in a dashboard, or add over 80 analytic functions. Nexus makes your PC a database and analytic engine.

Teradata is taking all of the awards for Data Warehouse Analytics. You should consider consolidating users on Teradata and use the platform for your major analytic jet engine. With a few clicks of the mouse, my Nexus and NexusCore Server can make the migration to Teradata easy.

The Ides of March is best known as the date on which Julius Caesar was assassinated at the Theatre of Pompey by members of the Senate in 44 BC. I think that 2020 is the year that we make the Ides of March a good thing. During March, I am going to allow you to migrate and move any amount of data to Snowflake for FREE.

The number one goal in today’s cloud market is for users to be able to access any data, at any time, anywhere. That usually takes the skill of a data scientist, but how would you like to point-and-click to join Excel to any table from any database? As a data warehouse manager at the largest bank in the world told me, “The Nexus Super Join Builder puts the business user on the same playing field as a data scientist.”

I can teach you Snowflake analytics! Today we are going to learn about Ntile. Each Ntile partition is assigned a number starting at one increasing to a value that is up to the Ntile partition number specified. So, with a Ntile of 4, the partitions are 1 through 4. Then, all the rows are distributed as evenly as possible into each partition from highest to lowest values. Normally, extra rows with the lowest value begin back in the lowest numbered partitions.