Something wrong with your data warehouse?
Why do data-teams struggle to add value? Why do so many data warehouses and data initiatives fail to add value? Want to know more? Or a more nuanced view? Use…
Tag: sql
Snowflake primary keys woes
In my work I have used Snowflake quite a lot. The so called Data Cloud is very popular. Getting started is easy.One of the issues I have with Snowflake, it’s…
SQL Performance
If you have to access persisted data, of course, you do not have to necessarely use SQL. But in case you do, knowing something about SQL-performance helps. I just did…
Databases on SSD
SSD disk are becoming increasingly popular. As they read faster, you might consider running databases such as Oracle DBMS, MySQL or non-sql databases. However, interestingly, originally databases are optimized for…
Proxying authentication using JBoss
Wouldn’t it be nice if the connection to the database is done using the same username as the username used to login to a (JEE) application? Oracle has a solution…
Alternative to SQL
Database alternative, for people just browsing and scanning, I’ll write in staccato. Relational model pretty good, but we need a better implementation of the relational model, SQL, at least the…