More on Finding Bad Links On Your Blog
Yesterday I mentioned using the Google Webmaster Tools to identify some bad URL’s here on the blog. I decided to...
2013-07-19
634 reads
Yesterday I mentioned using the Google Webmaster Tools to identify some bad URL’s here on the blog. I decided to...
2013-07-19
634 reads
I live in a pleasant, calm, middle class neighborhood. Not much crime here, at most the rare break-in or vandalism,...
2013-07-19
725 reads
I’ve been doing various clean up tasks this week related to the blog, with part of that being a review...
2013-07-18
825 reads
I just saw a post from Brian Kelley about the new PASS Security Virtual Chapter launching and the first presentation...
2013-07-17
602 reads
It’s done, finally! The sessions for SQLSaturday #232 have been selected and the schedule is available for viewing. We have...
2013-07-17
695 reads
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
528 reads
This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...
2013-07-02
780 reads
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,245 reads
This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at...
2013-06-26
1,351 reads
Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...
2013-06-17
872 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...
Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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