Four Year IT Degree Approved for Seminole State College
Back in 2007 when we started SQLSaturday we had the good luck to leverage an existing relationship between Seminole Community...
2010-10-04
756 reads
SQLAndy
Notes from SQLSaturday #48
I drove up on Friday, just under 7 hours with a couple quick stops on the trip. Listened to Team...
2010-10-04
510 reads
Presenting at SQLSaturday #48 in Columbia, SC This Weekend
I’m leaving Orlando early Friday morning to drive up to Columbia for SQLSaturday #48 . By the time I changed planes...
2010-10-01
309 reads
Revisiting The West Wing
Sometimes spending some time with your spouse watching TV is right up there with comfort food, the challenge is often...
2010-09-30
1,430 reads
Upcoming Florida Events
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,684 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,534 reads
Do You Have Influence? Part 3
I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you...
2010-09-28
712 reads
Orlando – Reminder to Register for SQLSaturday #49
We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards...
2010-09-27
634 reads
SQLRally After Hours
One of the things we’re trying to do at SQLRally (May 2011 in Orlando!) is support and grow the social...
2010-09-27
571 reads
On Vacation
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
581 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