Art

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Blog Post

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

16 reads

Blog Post

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

230 reads

Blog Post

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

9 reads

Blogs

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

By

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

Read the latest Blogs

Forums

What technologies should beginners focus on first?

By Naeem NT

Technology trends change quickly, which can overwhelm beginners. While checking a Full Stack Course...

cant process ssas db on vm - error says source is encrypted and other things

By stan

hi i get the error you see below when trying to process my AR...

This doesn't make sense to me - making me crazy - er

By krypto69

Hi So I have the below select query that won't return results if I...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers