Voting for the PASS Board
I got the email with a Zoomerang survey to vote for the PASS board. All are excellent candidates, but ultimately,...
2008-11-18
949 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
In remembrance of veterans and their families
Illiad has been running a series on his UserFriendly comic strip about veterans. It started on Monday and has continued...
2008-11-14
719 reads
MSSQLTips.com: How to Audit SysAdmin Logins
One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL...
2008-11-14
2,588 reads
Not Going to the PASS Summit
I've been asked by a few folks whether or not I'm going to the PASS Summit. The answer is I'm...
2008-11-13
598 reads
Of Mice and Men
In addition to the reading list I'm still struggling to finish, I've always got other books partially started. Maybe that's...
2008-11-07
691 reads
SQL Quiz - Mistakes You've Made?
Jason Massie called me out for a new SQL Quiz that was the diabolical idea of Chris Shaw.The gist is...
2008-11-07
1,392 reads
MSSQLTips: How to setup and use a SQL Server alias
I've written my first tip for MSSQLTips.com:
How to setup and use a SQL Server alias
It's a pretty simple thing to...
2008-11-05
901 reads
Midlands PASS Chapter Meeting - November 6, 2008
Speaker: Brian Kelley
Midlands PASS Chapter - November 6, 2008 Meeting
Sponsored by Red Gate Software
The Midlands PASS chapter will hold our normally...
2008-11-03
515 reads
Professional Microsoft SQL Server 2008 Administration
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,163 reads
Auditing for Blank Passwords
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,236 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