Building My Next Workstation–Part 1
It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...
2013-02-18
746 reads
SQLAndy
My $200 Oops
My Nexus 7 tablet has grown on me, though I think it’s more about having a dedicated tablet than the...
2013-02-14
623 reads
Annual Catch Up and End of Job/Contract Networking Steps
It’s easy to get comfortable in a job and neglect to capture the relationships and connections you’ve built – for me...
2013-02-12
622 reads
Some Thoughts About Sponsors at SQLSaturday
I think it was because I had just received an email about sponsoring a SQLSaturday that had me thinking about...
2013-02-12
602 reads
LinkedIn Endorsements
Last year LinkedIn rolled out a new feature called endorsements, not to be confused with recommendations. Recommendations are free form...
2013-02-11
770 reads
The PASS BA Conference–Good Idea or Not?
Ever since it was announced I’ve been ambivalent about the PASS Business Analytics Conference. I believe PASS should look for...
2013-02-09
849 reads
Don Gabor Presents Mastering the Art of Conversation and Making Business Contacts in NYC
My friend Don Gabor is presenting a two hour seminar titled “Mastering the Art of Conversation and Making Business Contacts”...
2013-02-09
768 reads
SQLSaturday #200 in Philadelphia (And Vacation)
I’m planning to attend SQLSaturday #200 in Philadelphia on June 1, 2013. Number 200! This will be my first trip...
2013-02-09
606 reads
One Slick Solution and Unexpected Consequences
Quite a few years ago my first job in the military was driving a tracked vehicle, a variant of the...
2013-02-07
762 reads
I’ll Meet You Half Way–Compromising To Win
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
780 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
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