LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
513 reads
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
513 reads
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes themselves have issues, but rather many questions about whether corporations are spending shareholder dollars appropriately. It's not a simple topic, but clearly there did seem to be a lack of awareness about how those kinds of things would be perceived in difficult financial times.
2009-04-01
919 reads
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,473 reads
The call for speakers is still open and will close April 6th, there's still from for a few more sessions....
2009-03-31
1,338 reads
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
2009-03-31
3,184 reads
Note: I was working on this at the Summit and then it got lost in the draft folder, so unfashionably...
2009-03-30
1,472 reads
This was an interesting year to watch the local Code Camp. Shawn Weisfeld organized it the previous two years, but...
2009-03-29
1,437 reads
My friend Brian writes Databases, Infrastructure, and Security and like me, he writes about an eclectic mix that goes beyond...
2009-03-26
1,447 reads
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,690 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
2009-03-26
2,334 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...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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