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: )

18,625 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,441 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

135 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,130 reads

Blogs

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Refreshed in Tuscany

By

I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t...

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Read the latest Blogs

Forums

SSIS task that runs a PowerQuery

By pietlinden

is there a good tutorial on how to get SSIS to run a PowerQuery...

Sub Queries Optimization

By ralahari

(SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1  = Table1_1.Column1 LEFT JOIN (SELECT...

UNION ALL Optimization

By ralahari

select Colum1 , Colum2  from  table 1 Union All select Colum1 , Colum2  from ...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers