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
29 reads
The Hybrid DBA's Blog
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
31 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)
209 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)
248 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
84 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
30 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)
230 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
51 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
79 reads
Be Safe, Be Strong and Be Kind…. surviving COVID Lockdown in New Zealand
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
94 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Need to overload tempdb
Yes, you read that title correctly. I have a somewhat hilarious problem. We have...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers