About me
I have been developing software from my early teens and stayed with technology after leaving school. Initially focussing on software development, networking and IT support type roles, I found...
2017-05-03
13 reads
Art
VirtualBox SQL FCI - Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,629 reads
VirtualBox SQL FCI – Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared...
2017-04-19
2 reads
Moved blog to Ghost
Another year, another blog update lol!... Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS...
2017-04-12
222 reads
Moved blog to Ghost
Another year, another blog update lol!… Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS software on the DiscountASP hosting platform and it all...
2017-04-12
5 reads
Apologies in advance
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
315 reads
Olcot and Arratoon Ancestry
I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...
2017-04-03
7 reads
Pluralsight = Essential Training
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight for a...
2016-09-11
190 reads
Pluralsight = Essential Training
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post I’ve been aware of Pluralsight for a couple of years and as I’m always looking...
2016-09-11
5 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
1,029 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
Symmetric Key EncryptByKey returns NULL value
I haven't used column level encryption because usually the vendors I deal with have...
orphaned users in sys.sysusers
Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility...
TDE for multiple databases and severs
We are self hosting sql servers, we are not using Azure for sql servers....
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers