Written by: Eric Rouach, Madeira Data Solutions - May 2023 Create External Table As Select or "CETAS" has finally become available on...

I have seen a lot of graphs lately where colors are used to convey a message of comparing groups. Here are some examples: Both graphs...

Use Azure Databricks to read data from Oracle Netsuite cloud ERP.

Where you told to not use Big A** Numbers in your dashboard? Well, sometimes you should.

As someone who works with databases and often collaborates with software development teams, I've noticed a rise in the popularity of...

Today we had an interesting use case where a customer reported that one of the databases they just restored from a backup got stuck in " Single-User " mode in one of their environments. To resolve it, I first tried running the following command: ALTER DATABASE MyDB SET MULTI_USER WITH ROLLBACK IMMEDIATE; In response, I got deadlocked with the dreaded error 1205: Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock

Converting SQL server stored procedures to Databricks notebooks, be aware of syntax differences.

If someone asked you which graph would be best for visualizing the customer types for each account manager based on the table in the...

Which is the right ETL tool for you on Azure cloud? Azure data factory or Azure Databricks?