Phil Factor

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

All authors

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)

2021-11-10 (first published: )

13,531 reads

SQLServerCentral Article

Reading and Writing your Database's Documentation using JSON

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2021-06-28 (first published: )

3,050 reads

SQLServerCentral Editorial

Malleable Source Control

Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2021-04-03

94 reads

SQLServerCentral Editorial

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

309 reads

All authors

Blogs

Daily Coping 24 May 2022

By

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

Notes on SQLSaturday Jacksonville 2022

By

I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...

TSQL Tuesday #150: Your first technical job. Rollup.

By

This months subject for T-SQL Tuesday was Your first technical job. I have to...

Read the latest Blogs

Forums

Is this If Condition Expression Valid?

By Stamey

I hate to be a pain, but I am a beginner at this and...

SSRS 2012 Email Relay question

By wentigels

Hi All,   I am trying to figure out if it is possible to...

Interviewing for a SQL Server DBA role, any tips?

By subevenis

Hi all, as the title says, I'm interviewing for a job as a SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Columnstore Index Limits in SQL Server 2019

See possible answers