What I’ve Been Up To Lately
I ran into a friend at a recent event and during the discussion he asked what I was doing lately...
2011-08-24
641 reads
SQLAndy
PASS Update #62
Our most recent Board meeting was Aug 11 & 12 in Ft Lauderdale (located so we could attend SQLSaturday on Saturday)....
2011-08-24
607 reads
Defining Your Culture
Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...
2011-08-23
646 reads
Networking Dinner at the PASS Summit 2011
We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...
2011-08-22
677 reads
Writing Your Resume
There’s a lot of info out there about putting together a resume, and I probably can’t add a lot, but...
2011-08-17
789 reads
You Are Allowed to Care About Whatever You Want
I wanted to write this because its often overlooked. I care about things that may not interest you, things that...
2011-08-16
574 reads
Micromanaging
Micromanaging is one of those words that evokes an instant negative image. Certainly there are times when it happens, but...
2011-08-15
627 reads
Notes from SQLSaturday #79
This was the third SQLSaturday in South Florida and the third time I’ve attended, just too good an event to...
2011-08-15
730 reads
Meet the PASS Board at SQLSaturday #79 In South Florida
We’re having a PASS Board meeting and many of us will be staying for the event on Saturday (and an...
2011-08-12
672 reads
Seeking Volunteers for the Nomination Committee
We have a few changes in the election process for PASS this year, one of them is that we have...
2011-08-11
650 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