Phil Factor

  • Interests: Motorbikes, Beer, gardening, conservation, Local history.

Of Hedgehogs and Database Design

One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]

5 (2)

2020-08-22

209 reads

Stairway to Exploring Database Metadata

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.

5 (5)

2020-04-15 (first published: )

9,471 reads

Blogs

Using Write-Debug

By

I wrote a post about PoSh output recently, noting that in general we ought...

T-SQL Tuesday Retrospective #002: A Puzzling Situation

By

For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...

Daily Coping 28 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Funny code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Funny code

Building Quality In

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Quality In

Setting Rows to Odd and Even Values

By bkubicek

Comments posted to this topic are about the item Setting Rows to Odd and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Funny code

See possible answers