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…

Read More

A fortune 100 company had changed its on-premises strategy to the cloud and needed to move its on-premises systems to the AWS cloud.  It wanted to migrate its Netezza, Oracle, and Teradata systems to Amazon Redshift, Snowflake, MySQL, and Postgres. At the time, they decided that their best choice was to use Amazon’s Data Migration Services (DMS).  After finding that DMS was not reliable enough for this massive project, they began a Proof of Concept with the Nexus Pro desktop and Nexus Server combination.

Read More
NExus core server makes data movement easier for DBAs, IT, and business users.

The two concepts in our Big Data vision is the user’s desktop and the database server.  The Nexus desktop allows a user to access any data, at any time, anywhere from their desktop or laptop, no matter whether they are at the office, a coffee shop, or home.  The Nexus Server sits in between the many different database platforms, both on-premises and on every cloud, and manages and controls the data movement between systems.  Users use the desktop to build anything and everything, but they have the option to run it from their desktop or the Server.

Read More

An international semiconductor company was running a complex query on Teradata and wanted automatically to create a table on their MySQL system.  We came up with two solutions:

Read More

A large bank was consolidating on Teradata and needed Oracle, SQL Server, and DB2 users to move critical data to their Teradata sandbox.  We invented the Nexus multi-database tree, where you can see two systems trees side by side.  Users can click-and-drag to move a single-table or an entire database,  which creates the table(s) on the Teradata system.

Read More

A sizeable primary healthcare provider requested the Nexus Pro and Nexus Server to migrate data from their Teradata and SAP HANA systems directly to Google BigQuery.  This herculean effort might take some software companies years to develop, but we expect to finish with 30-days. 

Read More

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.

Read More

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.

Read More

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. 

Read More

I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  This week we are working on the Cumulative Sum, which is interchangeable with the word CSUM. You use a Cumulative Sum (CSUM) to get a running total with subtotals and grand totals.

Read More

Moving data between systems is called ETL, which stands for Extract, Transform, and Load.  The ETL team almost always does the moving of data because load scripts are easier to learn than Latin, transformation is more difficult than brain surgery, and computing resources are about as easy to manage as cats.

Read More

  Yesterday – My Netezza troubles seemed so far away. Since IBM bought them now, they’re here to stay. Oh, I believe in yesterday. Suddenly, I’m not half the man I used to be. Why can’t I migrate off so easily? Oh, I believe in yesterday. Why it had to go, I don’t know, they…

Read More