Sunny South Queensferry and the Forth Rail Bridge.
#FirthOfForth #SQ #edinburgh #scotland #photography #bridge #trains
What's wrong with this SQL connection using wrong charset?
What's wrong with this SQL connection using wrong charset. The SQL code connects without specifying charset. In MySQL wrong default corrupts Unicode. In SQL you get mojibake in the database.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcharset #sqlutf8 #sq...
What's wrong with this SQL query doubling the boundary row?
What's wrong with this SQL query doubling the boundary row in a report. The SQL code uses BETWEEN for a date range. In SQL BETWEEN is inclusive on both ends so the boundary gets counted twice if used in a join.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sq...
Why does this SQL JSON extract never use the index?
Why does this SQL JSON extract never use the index. The SQL code queries JSON with JSON_EXTRACT. In MySQL that cannot use a regular index. In SQL use a generated column with an index.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqljsonextract #sqlindex #sq...
Arne הס
Arne Hess 🫑
jan
PrecisionSQL