SQL Saturday 99 – SSWUG Interview
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-15
811 reads
StrateSQL
SQL Saturday 99 – Emergent Networks Interview
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-13
655 reads
T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the...
2011-12-13
624 reads
Re-blog – December 2 – December 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-09
561 reads
The #Meme15 On Social Networking
During a recent conversation with a few fellow bloggers, the conversation turned to how we each got started with blogging...
2011-12-08
477 reads
SQL Saturday 99 – Data Education
Welcome to the third of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-08
480 reads
December AppDev Webcast
The new year is just around the corner. And before you know it, we’ll have an opportunity to start moving...
2011-12-07
523 reads
SQL Saturday 99 – RBA Consulting Interview
Welcome to the third of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-06
731 reads
December #MemeMonday
This month for #MemeMonday, Thomas LaRock (Blog | @SQLRockstar) has assigned a topic with a holiday bend to it. The question...
2011-12-05
495 reads
December Monthly SQL Server Checklist
It’s the first Monday of the December, and it’s time to do a monthly checkup. As previously mentioned, the premise...
2011-12-05
904 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