Leo

I started in database administration on mainframes in 1995 after in house training with a bank in South Africa. Picked up MS SQL Server from 1998 with SQL 6.5. From there I've used and migrated databases to every release of SQL Server up to the current release.
Moved to New Zealand in 2006 to work with another bank for 3 years, them got a Senior Consultant position with SQL Services Ltd in 2009 where I worked for 11 years. I've now been with DataSentinel Limited, also a SQL Managed Service provider, also a Senior Consultant since 2020.
I've been a contributor to SQL Server Central since about 2004. In New Zealand I have presented at local user group meetings and TechEd, and consulted on behalf of Microsoft in Australia.
I consider some of my strengths to be: The ability to see the root cause of a problem based on minimal information, often identifying solutions that have not occurred to others. Doing research and testing to find root causes and solutions, and being able to communicate DBA principles at all levels, including to non-technical stake holders.

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

Who’s the Winningest Coach (with AI Help)

By

I was listening to the radio the other day and the hosts were discussing...

Learning from Mistakes: T-SQL Tuesday #194

By

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

By

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...

Read the latest Blogs

Forums

How Do I Choose the Best Bike Transport Service in Gurgaon?

By frontlinelogistics

Choosing the best Bike Transport Service in Gurgaon requires careful comparison and user discussion....

Basic Always On Groups Randomly Stop Synchronizing

By Leo.Miller

In one of my environments I have 3 pairs of Always On SQL 2022...

Learning From Breakage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning From Breakage

Visit the forum

Question of the Day

Adding and Dropping Columns I

I have this table in my SQL Server 2022 database: 

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
I decide to add two new columns for the StateProvince and Country. What code should I use?

See possible answers