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

19 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

10 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

Why the following cmds in sequence do not work

By hoa.nguyen 64423

I need to delete rows from both the temporal main and history tables. The...

When SQL Server Central Went Down

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When SQL Server Central Went...

The String Distance I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The String Distance I

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled.

See possible answers