Change Data Capture (CDC)

This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008

2008-09-04

2,481 reads

Capture DDL Changes using Change Data Capture with SQL Server 2008

In this article we will see how Change Data Capture (CDC) in SQL Server 2008 can help DBA's to track DML changes

2008-08-06

2,183 reads

I’m not sure I knew identity column values could not be updated. I ran...

We had an interesting discussion about deployments in databases and how you go forward...

You could be tolerating limited reporting because there isn’t an off the shelf solution...

I have mentioned this several times over several years. Can someone please help me...

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?