sql-dumper --config stations.ini \ "routes:id,name;stations:id,name;stations_for_routes:station_id,route_id,ord" \ 100-200 \ "routes.id=stations_for_routes.route_id ...

What a great last few days for PowerApps! I hope you have been enjoying the announcements in the Spring Update Blog bundle. Have you seen Satya’s video? This blog doesn’t quite rise to the level of ...

Null is entered into the database when the value passed into JSONB.valueOf is null. The behavior is also a bit confusing since JSONB is just a simple wrapper so one cannot see why would it not handle ...

clauses IN and EXISTS are interchangeable. However, they’re quite different in how they handle NULL values and may give different results. The problem comes from the fact that, in an Oracle database, ...

Recently I’ve been asked by colleagues with various different types of performance problems why Power BI is generating SQL in a particular way, and the answer has been the presence of nullable columns ...