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,724 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,731 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,267 reads

All authors

Blogs

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

By

Making Data AI-Ready, Part 3 (This is the final article in a three-part series...

Keeping Track of my ConEmu CLIs

By

I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...

10 Decisions to Make Before You Create A Fabric Workspace

By

Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...

Read the latest Blogs

Forums

Alamat BCA KCP Mall Grand Indonesia Telp:08218520153

By layanan_Bca88

WhatsApp Cs 628218520153 Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H....

Alamat Kantor BCA KCP Senen Telp:08218520153

By R4nt4u

WhatsApp Cs 628218520153 Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....

BCA KCU PANGERAN JAYAKARTA Tlp:08218520153

By m4rt1n4

WhatsApp Cs 628218520153 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah...

Visit the forum

Question of the Day

Adding new column with DEFAULT II

Which number did the two COUNT(*) return: 

DROP TABLE IF EXISTS #tmp
CREATE TABLE #tmp (id INT NOT NULL)

INSERT INTO #tmp (id) 
SELECT gs.value
  FROM GENERATE_SERIES(1, 5) AS gs

ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1

SELECT COUNT(*)  FROM #tmp AS t WHERE my_value = 1

ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value

ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value

SELECT COUNT(*)  FROM #tmp AS t WHERE my_value = 1

See possible answers