Chris Yates

Chris Yates is a Database Administration Manager with over thirteen years of experience in the SQL industry. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions accompanied by a strong development background. He enjoys helping others in the SQL Server community and does this by contributing on several SQL forums, creating “The SQL Professor”, and speaking at several SQL functions. His passion and focus is not only with technology but also helping others along their way and career path.

All authors

All authors

Blogs

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

By

Recently, the world was reminded of just how fragile the internet can be.  Two...

Prepping for Certification, Part 4 of 4

By

In Parts 1-3, I covered how I prepare for a certification exam. In this...

Flyway Tips: Automation Assistance in Flyway Desktop

By

I was chatting with the product managers at Flyway and one asked me whether...

Read the latest Blogs

Forums

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

what are the downsides of TDE not running vs running?

By stan

hi for the 2 years i've been here I believe we've had "encryption" turned...

Help! MEMORY_ALLOCATION_EXT wait stalls

By krypto69

Hi I have an overnight process that moves allot of claims records Been working...

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