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.

Blink – Year is gone

by Chris Yates

The SQL Professor

As the door begins to knock I start to wonder who it can be. As I begin to open it...

2014-12-22

507 reads

T-SQL Tuesday #61 – Giving Back

by Chris Yates

The SQL Professor

It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when...

2014-12-12 (first published: 2014-12-09)

4,588 reads

SQL Sentry Plan Explorer – Don’t Leave Home Without It

by Chris Yates

The SQL Professor

If you’ve been around me long enough then you realize that I am a Red Gate fanatic. With that said...

2014-12-09

1,155 reads

PASS Summit 2014 ~ My GameTime Experience

by Chris Yates

The SQL Professor

“How did you like your convention?”
“How was your trip?”
“What did you learn?”
“Where did you go for a week?”
“Who did you...

2014-11-25

1,542 reads

What Are You Thankful For

by Chris Yates

The SQL Professor

Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...

2014-11-18

520 reads

T-SQL Tuesday #60 Roundup – Step Right Up

by Chris Yates

The SQL Professor

We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...

2014-11-16

624 reads

T-SQL Tuesday #60 Something New Learned

by Chris Yates

The SQL Professor

So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...

2014-11-11

607 reads

T-SQL Tuesday #60 – Something New Learned

by Chris Yates

The SQL Professor

Lights go on, it’s another game day, grabbed my bat and headed for the plate only this time we are...

2014-11-05

576 reads

Im At Summit Now What?

by Chris Yates

The SQL Professor

Pass Summit 2011 – Photo Provided by Pat Wright
We are a week out from PASS Summit 2014 and there will be...

2014-10-28

595 reads

The Question – Why?

by Chris Yates

The SQL Professor

The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...

2014-10-14 (first published: 2014-10-06)

5,957 reads

Blogs

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Read the latest Blogs

Forums

ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777

Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...

BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777

By layanan_Bca88

Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...

ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777

Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)

Here is the sample data I am testing with:

CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor

How many rows are returned?

See possible answers