Tampa IT Pro Camp Coming on September 22,2012
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
659 reads
SQLAndy
Fortune Cookie Marketing
I took a break from work today to look in on an informal event a friend was hosting at his...
2012-07-25
717 reads
Should We Customize the SQLSaturday Hashtag on Twitter?
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
775 reads
Presentations That Exceed The Allotted Time
Back in February I did a presentation for MagicPASS that ran long, maybe 30 minutes over the time allotted. It...
2012-07-20
830 reads
Stacia Misner and Kevin Kline Doing All Day Sessions for SQLSaturday #151
If there is anything better than a SQLSaturday it’s a SQLSaturday with a choice of great pre-con speakers. This year...
2012-07-19
703 reads
Notes from the July 2012 MagicPASS Meeting
Quick notes from the MagicPASS meeting:
Kendal Van Dyke still the king when it comes to explaining what’s going on with...
2012-07-19
719 reads
The Mentoring Experiment–New Call for Mentees
With both Steve Jones and I done with our summer break, we’re ready to continue with several experiments we’ve been...
2012-07-23 (first published: 2012-07-19)
2,570 reads
Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,972 reads
Attending SQLSaturday #164 in Cleveland
I’ll be back on the road again in August, heading up to Cleveland for SQLSaturday #164. It’s my first time...
2012-07-17
625 reads
I’ll Be Presenting at the PASS Summit 2012
I’m a little late posting this, but I had two sessions accepted out of four I submitted. I’ll be doing...
2012-07-16
541 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