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.

All authors

Blog Post

Precon in Columbus OH

I’ll be doing a precon for SQLSaturday #421 in Columbus Ohio on July 10th, 2015 titled “Planning a High Availability and Disaster...

2015-06-23

419 reads

All authors

Blogs

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

By

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

More fun with Git: git restore

By

The setup My day job involves babysitting a lot of Git repositories hosted on...

Read the latest Blogs

Forums

This doesn't make sense to me - making me crazy - er

By krypto69

Hi So I have the below select query that won't return results if I...

Catalog max connection pool size: 100

By Pete Bishop

Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...

CAST datetimeoffset(7) as a datetime in UK format

By tylerschuler75

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return? 

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers