Will Assaf


Blog Post

Updated training list for a new DBA

Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...

2023-08-18 (first published: )

582 reads

SQLSat Baton Rouge 2023!

Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...

2023-07-22 (first published: )

9 reads

Blog Post

SQL Server 2022 Administration Inside Out

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This book is far more than a quick update. We've rewritten and refreshed large portions of...

2023-03-25 (first published: )

95 reads

Blog Post

Speaking at SQLSaturday MN 2022

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for great feedback and questions. I'm always a big supporter of SQLSaturday events whenever I can...

2022-12-04 (first published: )

11 reads

Blogs

How important is having great soft skills as a Software Engineer for personal growth and career…

By

How important is having great soft skills as a Software Engineer for personal growth...

Master Advanced SQL: 2 Essential Courses for Every Data Analyst

By

If you're a data analyst, you already know that SQL isn't just a nice-to-have...

Friday Flyway Tips–State-based Deployments

By

Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...

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