Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,565 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Out of Band Security Bulletin Release for Microsoft Windows
Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of...
2008-10-23
1,509 reads
"The work never matches the dream of perfection the artist has to start with."
I know, another non-technical blog post. But this one is career-related as well.
In high school I was introduced to...
2008-10-20
1,343 reads
"To Lead Is To Follow"
I first ran across these words as a Citadel cadet. Now those who know of my days at El Cid...
2008-10-19
826 reads
Speaking in West Palm Beach and Orlando
I have two speaking engagements for the week of October 19:
South Florida SQL Server User Group - West Palm Beach - October...
2008-10-18
693 reads
Red Gate SQL Response Review is up
Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...
2008-10-08
961 reads
SQL Response Review - New SQL Server Monitoring Tool
Red Gate's SQL Response is advertised as a low-impact SQL Server monitoring application with an intuitive interface. Given the advertising, I signed up for the SQL Response Release Candidate and took a look. I was pleasantly surprised with what I found.
2008-10-08
4,792 reads
What I'm Reading (5 Oct 2008)
Technical:Counter Hack Reloadedby Ed Skoudis with Tom Liston
It's a security book and I'm rather late getting a review of it...
2008-10-05
734 reads
Thanks to Andy Leonard
Midlands PASS was privileged to host SQL Server MVP Andy Leonard (Blog #1, Blog #2, his VSTS site, Twitter) tonight...
2008-10-03
733 reads
Reminder - MVP Andy Leonard Midlands PASS!
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-10-01
925 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
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
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
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