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
HeyMo0sh
Open Letter to the PASS Membership,
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
What the future of PASS needs – and how I can help
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
Why I am running for the PASS Board in 2020
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
Azure Platform Series: How to setup Azure Cloud Shell
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)
225 reads
Azure Platform Series: Creating an Azure Container Registry – ‘registry_name’ must conform to the following pattern
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
Azure Platform Series: Push to GitHub repo with 2FA from a Mac using Personal Access Token
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
24 reads
Diversity & Inclusivity – a personal journey
This article is about my own experiences in making my user group and community events more inclusive for people from diverse backgrounds. I am going to use growing my...
2020-04-10 (first published: 2020-03-31)
855 reads
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
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
Being awarded the PASS PASSion Award – you can too
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
20 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers