Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

It’s Time to End Password Reuse

by Andy Warren

SQLAndy

Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...

2014-05-26

685 reads

Get User In Reporting Services

by Andy Warren

SQLServerCentral

Reporting Services (SSRS)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2014-05-26

1,722 reads

Discuss

Building The SQLSaturday Orlando Marketing Plan–Part 11

by Andy Warren

SQLAndy

Just received the first flyer design – thoughts?

2014-05-24

548 reads

Building The SQLSaturday Orlando Marketing Plan–Part 12

by Andy Warren

SQLAndy

Meetup.com did refund my $19, good!
Team oPASS added SQLSaturday #318 to their calendar, you can see it here, or here’s...

2014-05-24

554 reads

Building The SQLSaturday Orlando Marketing Plan–Part 10

by Andy Warren

SQLAndy

My experiment with Meetup.com hasn’t worked out well so far. I set up the event site and sent it around...

2014-05-23

535 reads

Wishing For Error Messages That Are Good Search Terms

by Andy Warren

SQLAndy

Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...

2014-05-23

522 reads

An Sp_addrolemember Gotcha

by Andy Warren

SQLAndy

Over the past few months there have been a handful of times when I had to fix a security problem...

2014-05-22

833 reads

Writing A Question Of the Day–More Notes

by Andy Warren

SQLAndy

One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...

2014-05-22

490 reads

Building The SQLSaturday Orlando Marketing Plan–Part 9

by Andy Warren

SQLAndy

I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...

2014-05-21

700 reads

Submitted My Application For the 2014 PASS Nominating Committee

by Andy Warren

SQLAndy

I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...

2014-05-21

496 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