Mickey

  • Interests: My Family, SQL, LEGOS, Action Movies, and Reading.

Blogs

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...

Planview Portfolios REST API with ADF – Fetching the Access Token

By

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

Read the latest Blogs

Forums

How to set execution timeout in SSMS for SQL Server

By IT researcher

I tried to set the execution timeout in SSMS for SQL Server 2017 using...

Implementing Change Data Capture

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Implementing Change Data Capture

What is new in Copilot, the new features available

By Daniel Calbimonte

Comments posted to this topic are about the item What is new in Copilot,...

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