Read-Only Access to SQL Server Jobs
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
4,062 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
What Do You Want Auditors to Know About Auditing SQL Server?
Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...
2009-01-22
1,101 reads
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
686 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
914 reads
Fake LinkedIn profiles with links to malware
This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...
2009-01-20
926 reads
Have you disabled autoplay yet?
If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...
2009-01-15
749 reads
Microsoft Solution Accelerators on TechNet
I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...
2009-01-15
818 reads
More About Twitter
I've mentioned before that I was on Twitter and I know that for some the question is still out on...
2009-01-12
916 reads
MySQL GUI Tools
This came up on Twitter today. I have a search set for "SQL Server" and it pulled up someone who...
2009-01-09
946 reads
Windows Server 2008 R2 Core supports SQL Server
First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...
2009-01-09
1,265 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