Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

Setting the Standard with Personal Appearance

by Brian Kelley

Databases – Infrastructure – Security

Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...

2011-02-04

1,142 reads

User Group Giveaway: My Latest Book

by Brian Kelley

Databases – Infrastructure – Security

As I annouced earlier, Oracle and database expert, Bert Scalzo and I collaborated on an introductory text appropriately titled Introduction to SQL...

2011-01-26

704 reads

MSSQLTips Kindle Giveaway

by Brian Kelley

Databases – Infrastructure – Security

Want a legitimate chance to win an eBook reader like a Kindle? Would having it loaded down with eBooks on...

2011-01-25

825 reads

SQL Saturday #70 - Columbia, SC - Call for Speakers

by Brian Kelley

Databases – Infrastructure – Security

We're gearing up the advertising for SQL Saturday #70 since we're about 8 weeks out. In keeping with that, our...

2011-01-24

2,014 reads

The Danger of Agreements

by Brian Kelley

Databases – Infrastructure – Security

I'm speaking in context of Getting Things Done, not a legal or contractual agreement. What brought this up is me...

2011-01-24

801 reads

Free SQL Server Training for the week of January 24, 2011

by Brian Kelley

Databases – Infrastructure – Security

We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...

2011-01-21

838 reads

New Book: Introduction to SQL Server

by Brian Kelley

Databases – Infrastructure – Security

Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...

2011-01-19

599 reads

SQL People Events - TED for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

When I first saw Andy Leonard's post about a new SQL People event, I was intrigued. It's not a training...

2011-01-13

2,503 reads

Technical Goals for 2011

by Brian Kelley

Databases – Infrastructure – Security

I know I missed out on the massive meme yesterday (T-SQL Tuesday #14), but I blame dealing with the weather...

2011-01-12

797 reads

Re-Awarded MVP for 2011

by Brian Kelley

Databases – Infrastructure – Security

I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011. It's a nice...

2011-01-01

783 reads

Blogs

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

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

I’ve had a Dropbox account for years. Like a lot of people, I started...

Read the latest Blogs

Forums

Alamat kontak resmi BCA KCP Tebet Telp:0818751777

WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...

Stan Phone Number Australia +61-1800868603 Quick Help Guide

By richardrussel

When things go wrong - like trouble signing in, videos pausing, unclear charges, or...

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

By Layanan BCA 24 JAM

Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...

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