Ted

Lead DBA with over 25 years’ experience delivering high-availability, secure SQL Server solutions across banking, government, and enterprise sectors.

Experienced in designing and supporting mission-critical environments, including Always On, DR strategy implementation, performance optimisation, and enterprise-scale backup and recovery planning.

Proven track record leading DBA teams, mentoring engineers, setting database standards, and working closely with development, infrastructure, and security teams to deliver stable and compliant data platforms.

Strong focus on automation, security, and proactive monitoring to minimise risk and improve operational efficiency. Passionate about modernising legacy environments and building resilient, scalable database architectures.
  • Interests: Writing Books, Walking,Kdramas
  • Skills: SQL,C#

All authors

SQLServerCentral Article

SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry

Taking SQL art from shamrocks and Easter eggs to something your DBA manager might actually care about. If you've been following my SQL spatial art series — shamrocks, Easter eggs, Christmas trees — you'll know I have a habit of finding increasingly creative misuses for SQL Server's geometry data type. Most of them have been […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-06-12

4,560 reads

SQLServerCentral Article

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

What a DBA team actually deals with There are many issues a DBA team faces, from servers going down to login access not being requested on time. These are not glamorous problems, but they are the problems that stop everyone else doing their jobs. In a modern environment you would expect a lot of the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-04-13

2,667 reads

SQLServerCentral Article

SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)

Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2026-03-16

2,249 reads

All authors

Blogs

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Read the latest Blogs

Forums

Partitioning a table with TEXTIMAGE_ON option

By Brandie Tarvin

I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...

OUTER APPLY Fundamentals: Part 2

By Imran2629

Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2

Building Great Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Great Software

Visit the forum

Question of the Day

The Range of Customers

I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC): 

orderid orderdate               customerid complete
3       2025-05-10 00:00:00.0002          1
21      2024-01-10 00:00:00.0003          1
15      2023-10-28 00:00:00.0004   1
13      2025-03-08 00:00:00.0006          1
11      2024-04-02 00:00:00.0007          1
If I run this query, how many rows are returned? 
SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers