The clones are attacking

“Do the developers realize that the reason we store data is to report on it ?” Louis Davidson in Episode 178 of SQL Data Partners (around 19min 10sec ) I was faced with this question again as I could only witness the same piece of information inserted in two different tables. I’m not talking aboutContinue reading “The clones are attacking”

A unique error

This weekend, I listened to the SDU Show 81 podcast and the guest was Louis Davidson, the author my favorite SQL Server book. In this podcast, a common SQL anti-pattern came: not covering the natural keys with UNIQUE constraints, only having the surrogate being unique. I could only node in agreement. I take the timeContinue reading “A unique error”

Sailing to a new DBMS

A first transition Before I started programming on SQL Server in 2018, I only developed with PostgreSQL. In the beginning I was trying to transfer the knowledge from one DBMS to the other. And so many piece were missing to me. I could no more enjoy ROLLBACK on DDL, multicolumn JOIN, awesome aggregation and windowContinue reading “Sailing to a new DBMS”

Let’s the journey begin

I hope to soon blog on my experience with whatever is going on: Sql with Sql Server and MySql Database design… and let’s normalise Comment on other blogs… Fonctionnal programming on the .Net platform with F# … and surely deviation from this plan. But let a first thank WordPress for providing this free website andContinue reading “Let’s the journey begin”