Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Blog Post

Read-Scale Availability Group Setup

What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group.  It’s sole purpose and design is to scale out a read workload.  More importantly...

2018-07-05

2 reads

Blog Post

Read-Scale Availability Group Setup

What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group.  It’s sole purpose and design is to scale out a […]
The post Read-Scale Availability...

2018-07-05

1 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

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

Managed Instance Impressions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managed Instance Impressions

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