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#

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,819 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,803 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,313 reads

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers