PASS Connector Editorial for June 17, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
654 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
654 reads
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker Don Gabor on my networking skills. We recently did our final call of the six hours coaching planned, and thought I'd share some final thoughts.
2009-06-18
1,274 reads
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover...
2009-06-17
1,003 reads
I wasn’t able to attend this event, but did participate as a sponsor and I had this follow up message...
2009-06-16
650 reads
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what...
2009-06-16
998 reads
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...
2009-06-16
3,267 reads
I didn’t attend, but wanted to get this written down somewhere!
I’m just catching up on email, Ken Starnes said all...
2009-06-15
540 reads
I was recently asked for advice about seeking a job, a request we all get from time to time. In...
2009-06-15
725 reads
Way back on May 19 I wrote about my search for a new laptop bag to replace my somewhat tattered...
2009-06-14
719 reads
Michelle Ufford (aka SQLFool) is leading the first SQLSaturday in Iowa at the University of Iowa in Iowa City on...
2009-06-14
762 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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 TaylorHow many rows are returned? See possible answers