We're a place where coders share, stay up-to-date and grow their careers.
Data analyst, database programmer, ancientish.
Data analyst
All private interactions must abide by the code of conduct.
Currently Learning
Python, PySpark, Java
Skills Languages
SQL (in my sleep), Pascal (in my head), Python (in my future), VBA & MS Access (for my sins).
Number 10 SQL implementations are inconsistent I've jumped t...
Feb 2
Next, #4. Select statements are not dynamic Certainly some ...
On to #3 Aliases don’t work after the Select block This is ...
Next #2 UPPERCASE Ah, the classic language argument - and on...
Ah, nothing quite like a rant to air some heartfelt observati...
A very belated addendum is that I've since cracked the soluti...
Aug 30 '20
Well, there's an irony there. If we set aside performance iss...
Jul 9 '20
You may find that this depends very much on the platform. I f...
Jun 22 '20
Sorry to nitpick but you're leaving a gap between 3.99 and 4....
To start with, I generally like the look of this explanation ...
Apr 29 '20
Just checking, you do know it's "gutsy" not "gusty"?
Apr 28 '20
I frequently see various "prerequisites" quoted with no men...
Apr 5 '20
Very glad to see you including "prerequisites" as something...
Apr 4 '20
This is incorrect where it says: "For example, the biggest di...
Mar 21 '20
You've written that so well that I don't feel I can add muc...
Feb 23 '20
I suggest you read the article I linked to, which links to ...
Jan 12 '20
It seems odd that after putting on so much Open Source soft...
Jan 11 '20
Good piece, this is something I can pass to people before t...
Jan 10 '20
At the risk of being tedious, I'll point out that your use ...
Aug 12 '19
This is a question structured as a false dichotomy. Softwar...
Jul 25 '19
Just a quick thumbs up from me - as I've been operating my Ub...
Jun 29 '19
Oh well, I just uninstalled the app after trying to use it ...
May 18 '19
All 30 comments
10 Things I Hate About SQL
Number 10 SQL implementations are inconsistent I've jumped t...
10 Things I Hate About SQL
Next, #4. Select statements are not dynamic Certainly some ...
10 Things I Hate About SQL
On to #3 Aliases don’t work after the Select block This is ...
10 Things I Hate About SQL
Next #2 UPPERCASE Ah, the classic language argument - and on...
10 Things I Hate About SQL
Ah, nothing quite like a rant to air some heartfelt observati...
Running Ubuntu From A USB Drive
A very belated addendum is that I've since cracked the soluti...
How to add IF-ELSE logic to SQL queries
Well, there's an irony there. If we set aside performance iss...
How to add IF-ELSE logic to SQL queries
You may find that this depends very much on the platform. I f...
How to add IF-ELSE logic to SQL queries
Sorry to nitpick but you're leaving a gap between 3.99 and 4....
SQL Joins without the Venn diagrams
To start with, I generally like the look of this explanation ...
Ubuntu Likes October Better.
Just checking, you do know it's "gutsy" not "gusty"?
How to Document your repository in GitHub?
I frequently see various "prerequisites" quoted with no men...
How to Document your repository in GitHub?
Very glad to see you including "prerequisites" as something...
Data Royale: [SQL] vs noSQL
This is incorrect where it says: "For example, the biggest di...
What I've learned from designing for experts
You've written that so well that I don't feel I can add muc...
How I set my Linux computer for coding
I suggest you read the article I linked to, which links to ...
How I set my Linux computer for coding
It seems odd that after putting on so much Open Source soft...
Why and how you should migrate from Visual Studio Code to VSCodium
Good piece, this is something I can pass to people before t...
4 Ways to Calculate a Running Total With SQL
At the risk of being tedious, I'll point out that your use ...
Is contributing to a private repository still considered as contributing to OSS?
This is a question structured as a false dichotomy. Softwar...
Running Ubuntu From A USB Drive
Just a quick thumbs up from me - as I've been operating my Ub...
Announcing DEV for Android
Oh well, I just uninstalled the app after trying to use it ...