My name is Andrew Fenna, and I am a database developer at The Laterooms Group. I have written this blog to educate my fellow database developers in subjects that I think are necessary to keep at the top of our game. I have been working with RDBMS’s since 2002 and I have worked within financial, gaming, public, and travel sectors within the Northwest of England. I have gained quite a lot of experience throughout my journey and have tackled some very difficult challenges along the way. Therefore, I am blogging my experiences, which I hope will give you the inspiration to try and tackle problems that are deemed impossible to start, but with some encouragement and guidance become much more simpler and structured, thank you for your time. Andrew J Fenna.

All authors

All authors

Blogs

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...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes

By Site Owners

Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

By Site Owners

Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...

Storytelling with Data: Let's Practice!

By Site Owners

Comments posted to this topic are about the item Storytelling with Data: Let's Practice!

Visit the forum

Question of the Day

The Decoded Value

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

DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000)));
SELECT BASE64_DECODE(@encoded)

See possible answers