Phil Factor

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

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 (6)

You rated this post out of 5. Change rating

2023-10-04 (first published: )

19,128 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 […]

You rated this post out of 5. Change rating

2021-06-28 (first published: )

3,511 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 […]

You rated this post out of 5. Change rating

2021-04-03

142 reads

Stairway to Exploring Database Metadata

Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.

5 (5)

You rated this post out of 5. Change rating

2021-01-13 (first published: )

6,179 reads

Blogs

Advice I Like: Experience and Aptitude

By

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

BK’s Bookshelf: Never Split the Difference

By

I picked up Never Split the Difference: Negotiating As If Your Life Depended On...

Read the latest Blogs

Forums

Insiders Selling Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Insiders Selling Data

Join 2 tables

By mtz676

Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...

Impact of Not Including Foreign Keys in an SQL Archive Database

By abdalah.mehdoini

Hello everyone, I am about to start a data archiving project that will affect...

Visit the forum

Question of the Day

Quiesce

What does it mean to quiesce a system?

See possible answers