Assorted Links for April 13, 2013
Consider adding Troy Hunt to your feed listGreat post about the role of staffing firms in your job search and...
2013-04-13
627 reads
Consider adding Troy Hunt to your feed listGreat post about the role of staffing firms in your job search and...
2013-04-13
627 reads
I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...
2013-04-08
767 reads
I’m not sure what put this phrase in my head, though I think in part it came from various posts...
2013-04-03
716 reads
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed...
2013-04-01
1,022 reads
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.
2013-04-01
3,528 reads
I’m writing this because I was thinking about a member of the local PASS chapter on the way home last...
2013-03-29 (first published: 2013-03-22)
1,201 reads
I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or...
2013-03-26
987 reads
I was recently talking with a friend about doing some research into a NAS solution for home and that I...
2013-03-22 (first published: 2013-03-19)
1,786 reads
I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics...
2013-03-19
652 reads
Let’s start with a quick review of the pieces and what I paid:
ItemCostAntec P280 Case$90 (may be higher now)ASUS P8Z77-V...
2013-03-12
667 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