Bash: “command not found” in IF statement
This blog post is about a situation where writing an IF THEN ELSE statement with variables fails with something like ./scalePREPROD.sh: line 26: [[1: command not found This was...
2021-01-23
25 reads
This blog post is about a situation where writing an IF THEN ELSE statement with variables fails with something like ./scalePREPROD.sh: line 26: [[1: command not found This was...
2021-01-23
25 reads
When I was appointed to serve as a Director at Large for the PASS Organization a year ago, it was with great passion, excitement and enthusiasm. I had some...
2020-12-08
29 reads
At the recent PASS Virtual Summit I and the other candidates took part in a Ask Me Anything (AMA) session – where the community posed us questions. It was...
2020-11-24 (first published: 2020-11-16)
207 reads
This blog post lists the reasons why I felt the need to run for a 2 year term.
2020-10-29 (first published: 2020-10-27)
245 reads
This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I am working on a client project that requires containerised applications – so we...
2020-06-07
80 reads
This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I have some code on my Mac. I need to put it into an...
2020-06-07
25 reads
This blog post will be a series on the Azure Platform and some things we can use it for. Background: I run a consultancy company – and sometimes I...
2020-06-22 (first published: 2020-06-06)
226 reads
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting it and have picked a topic that is near and dear to me. If you...
2020-04-07
49 reads
The annual PASSion Award is the highest accolade given to a PASS volunteer. Presented during the annual PASS Summit conference, this award recognizes an individual’s exemplary service and commitment...
2020-04-01
34 reads
Currently we have have the COVID-19 pandemic sweeping the world. Here in New Zealand we are currently in lockdown – what this means is that we Kiwis are required...
2020-03-31
92 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Please I am struggling to understand the difference between these two queries. It behaves...
Comments posted to this topic are about the item Introduction to PostgreSQL for the...
Hi we know (or believe) ssas saas gets stood up separately when a company...
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers