Challenge Yourself
How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.
2014-09-30
274 reads
How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.
2014-09-30
274 reads
I said that I’d write about some good things PASS does, and I’ll make it a point to do so....
2014-09-29 (first published: 2014-09-25)
6,899 reads
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
2014-09-29
220 reads
This is part of a series of tips for speakers on how to make your presentations better.
Organization matters, and it...
2014-09-29
1,389 reads
2014-09-29
2,016 reads
I had another piece that looked at some issues with PASS slated for today, but it’s been a tough morning....
2014-09-26
1,032 reads
Continuing on with things that PASS does well, since I want to be balanced, I wanted to talk about volunteers....
2014-09-26
901 reads
Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...
2014-09-25
1,068 reads
I don’t want to get too deeply involved in the complaints and struggles of PASS, but I also want to...
2014-09-25
699 reads
2014-09-25
2,003 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...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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