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

SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First

By

Following up on my Part 1 baseline, the journey from 2017 onward changed how...

Google Moves Up Post-Quantum Cryptography Timeline

By

In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...

The Book of Redgate: No Politics

By

In today’s world, this might mean something different, but in 2010, we had this...

Read the latest Blogs

Forums

Auto Update Statistics not triggering on filtered indexes

By Leo.Miller

I've got a table with 186,703,969 rows, about 300GB of data. There are several...

What is the difference between SQL Server and SQL Database?

By kamiiteore

I created a SQL Database in Azure Portal but I've just noticed it also...

An Unusual Identity

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unusual Identity

Visit the forum

Question of the Day

An Unusual Identity

What values are returned when I run this code? 

CREATE TABLE dbo.IdentityTest2
(
     id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
    somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
 id
 FROM dbo.IdentityTest2

See possible answers