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

Build a SQL Cluster Lab Part 3

You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...

2019-11-18 (first published: )

558 reads

Blog Post

Build a SQL Cluster Lab Part 1

This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports both...

2019-11-06 (first published: )

646 reads

Blogs

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

Planview Portfolios REST API with ADF – The OData Feed

By

In the introduction, I explained the setup of the use case and why we...

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