Phil Factor

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,008 reads

What’s in that database? Getting information about routines

There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.

2020-03-17

Blogs

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

Why aren't the backups working?

By Rod at work

You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...

Cannot insert duplicate key in object

By adonetok

In table tUSERI primary key was added in the column [Email]. I deleted a...

Random excessive CPU consumption

By DataGuy

Hi all. I'm in a bit of a quandary with one of our Analysis...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers