Notes from SQLSaturday #85
I’m writing this on Sunday afternoon after the event, thinking about the event and what I want to share with...
2011-09-26
630 reads
SQLAndy
SQLSaturday #85 is Tomorrow!
It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...
2011-09-23
606 reads
What Will Be The Shared Experience at Summit 2011?
Last year it was the Tina Turner impersonator. Was it last year or the year before where the servers spun...
2011-09-21
651 reads
What Should I Carry in My Laptop Bag
I have a tendency to carry more than I need, the equivalent of the Batman Utility Belt. I just went...
2011-09-21
852 reads
The Ten Thousand Year Clock
Ran across this in my reading about the Ten Thousand Year Clock, a project funded by Jeff Bezos. Awesome dream....
2011-09-21
709 reads
PASS Update #65 (Officers, September Meeting)
I wanted to start with a follow up to my last post about the officer elections and the concerns about...
2011-09-20
708 reads
No Drama
Someone I worked with recently on the server side of the business had that to say about SQL Server compared...
2011-09-19
610 reads
Conflict Resolution
More than once I’ve run into situations where I’m working with two people/groups that don’t get along. Especially as a...
2011-09-16
620 reads
Dreaming
It’s easy to get so busy with life you forget to dream, at least for me. Most of us have...
2011-09-16
708 reads
I Don’t Know
I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....
2011-09-14
629 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