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
28 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
30 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)
208 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)
247 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
82 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
29 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)
229 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
50 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
75 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
93 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers