Phil Factor

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

SQLServerCentral Editorial

Over-thinking Database Build Scripts

With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]

1 (1)

You rated this post out of 5. Change rating

2019-06-29

323 reads

Stairway to Exploring Database Metadata

SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.

5 (2)

You rated this post out of 5. Change rating

2019-03-26 (first published: )

5,960 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

DB stuck in restoring state

By LearningDBA

A developer tried restoring a test DB 3 times and each time it was...

singleton is interferring with getting multiple nodes in xml

By stan

Hi we have an xml doc shaped essentially as shown in image 2 below. ...

The backup to one location fails but is successful on another

By Arsh

Dear Friends, Would be glad if any of you can help in a backup...

Visit the forum

Question of the Day

Implementing Change Data Capture

I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?

See possible answers