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.

A Letter To A Younger Yates

by Chris Yates

The SQL Professor

Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...

2017-01-31

686 reads

5 Characteristics Every Leader Should Practice

by Chris Yates

The SQL Professor

The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that...

2017-01-24

726 reads

Why Use Red Gate’s SQL Multi Script?

by Chris Yates

The SQL Professor

Someone once told me at the shop that we have plenty of software utilities laying around that could be very...

2017-01-18

521 reads

Hold The Fort

by Chris Yates

The SQL Professor

Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...

2017-01-12 (first published: 2017-01-05)

1,299 reads

Looking Back At 2016

by Chris Yates

The SQL Professor

When this blog started back in 2011 I had no idea that it would continue to grow to where it...

2016-12-29

679 reads

The New PASS Logo and More

by Chris Yates

The SQL Professor

Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...

2016-12-20

338 reads

A Data Professional’s Story – PASS Summit 2016

by Chris Yates

The SQL Professor

This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...

2016-11-11 (first published: 2016-11-02)

1,231 reads

PASS Keynote Part 2 – Live Coverage

by Chris Yates

The SQL Professor

Good morning from PASS Summit in Seattle, Washington. Like yesterday I will be live blogging the event. The same format...

2016-10-27

530 reads

PASS Summit Keynote 2 – Release 1

by Chris Yates

The SQL Professor

Grant Fritchey taking the stage to talk about the financial health of PASS.
250k members , 170 countries, and 87% global representation...

2016-10-27

556 reads

PASS Summit Keynote 2 – Release 2

by Chris Yates

The SQL Professor

Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back...

2016-10-27

580 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By Klaus Aschenbrenner

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

ROLLUP to calculate Month total for all Categories

Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

By Bill Pearson

Comments posted to this topic are about the item Level 28: DAX Text Functions:...

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers