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

2019-11-06 (first published: )

5,606 reads

The Multi-skilled Developer

Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.

4 (1)

2019-09-25 (first published: )

530 reads

Blogs

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

By

I am very passionate about having a disaster recovery architecture, plan and strategy. This...

I Presented with Live Captioning and Sign Language Interpreters

By

I had the pleasure of presenting a full-day pre-conference session on the Friday before...

What's New in SQL 2019? at the Santa Fe SQL Server User Group

By

Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...

Read the latest Blogs

Forums

Recursive CTE vs UNION ALL in a VIEW

By Mauricio_

Hi, I'm trying to improve a VIEW which is made of several UNION ALLs,...

Update Statistics is causing DB file to grow in always on envrionment

By PJ_SQL

Hello! When I check what is causing DB files (.mdf) to grow, it is...

Looking for recommendation on "cost threshold value"

By vsamantha35

H All, What is the recommended value for setting sp_configure setting "Cost Threshold For...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers