January OPASS Meeting Recap
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every...
2011-02-04
862 reads
Blog Posts
Setting the Standard with Personal Appearance
Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...
2011-02-04
1,142 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,106 reads
Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,745 reads
PASS Update #52 (ERC)
We’re doing weekly calls for the ERC (election review committee) and we seem to be making some progress. This past...
2011-02-03
659 reads
Poll Reveals DBAs Actively Tune TEMPDB
When I manage a SQL Server instance, I always make an extra effort to optimize the performance of TEMPDB, so...
2011-02-03
714 reads
SQL Saturday #63 Dallas Needs YOU
Dallas’ first SQL Saturday ”was full of nothing but smooth, rich #awesomesauce.” And we had Italian gelato.
Dallas’ second SQL Saturday (BI edition) ”had over...
2011-02-03
473 reads
SQL Saturday Advice–Upload Decks Early
One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck...
2011-02-03
1,418 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
647 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
453 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
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...
Detecting Characters
Comments posted to this topic are about the item Detecting Characters
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