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.

QA, Utility Databases, and Job Executions

by Chris Yates

The SQL Professor

Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation...

2017-04-26

433 reads

SQL Doc by RedGate

by Chris Yates

The SQL Professor

I recently was on a call where a technical unit indicated they did not receive any form of documentation around...

2017-04-24 (first published: 2017-04-19)

1,317 reads

Don’t Duck On Responsibilities

by Chris Yates

The SQL Professor

Being a data professional you assume a certain amount of responsibility. It often requires having the right attitude and an...

2017-04-17 (first published: 2017-04-10)

1,384 reads

T-SQL Tuesday #89 Invitation – The times they are a-changing

by Chris Yates

The SQL Professor

This month’s topic by Koen Verbeeck (B|T) is based around times that are a changing. To break it down somewhat...

2017-04-11

348 reads

Are You Wasting Energy?

by Chris Yates

The SQL Professor

Often times we as leaders within our respective shops tend to waste our time focusing on the wrong things. Think...

2017-04-06

372 reads

Is There A Threat Inside?

by Chris Yates

The SQL Professor

If you’ve been involved in technology for any length of time you are aware of outside threats to your network...

2017-04-05

364 reads

How I Became A…SQL Server Data Professional

by Chris Yates

The SQL Professor

Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...

2017-04-04

393 reads

What Is SQL Saturday?

by Chris Yates

The SQL Professor

I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...

2017-04-03

382 reads

The Pen Cap

by Chris Yates

The SQL Professor

This post is for all you up and coming data professionals out there. Over the course of the last week...

2017-03-21

465 reads

Backup/Restore–What’s My Status?

by Chris Yates

The SQL Professor

The day begins and you find yourself going through a list in your mind of things that need to be...

2017-02-02 (first published: 2017-01-26)

1,886 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

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

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

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