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

You rated this post out of 5. Change rating

2021-11-10 (first published: )

15,397 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,258 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

109 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,048 reads

Blogs

Summit Launch Pricing Ends June 7

By

The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....

Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data

By

Information security and privacy are key in today’s data-driven world. Sensitive data needs to...

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices

By

 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a...

Read the latest Blogs

Forums

Not wanting to use a Cursor, but...

By jwilkerson@valleymetro.org

Ok, need someone to talk me off the cursor ledge on this one. I...

Better Communication Through Less Messaging

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Communication Through Less Messaging

MuleSoft Integration with Azure Key Vault

By Sukanya Konatam

Comments posted to this topic are about the item MuleSoft Integration with Azure Key...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers