Minutes of the Aug 2008 oPASS Meeting
I've just posted minutes of the August 2008 user group meeting. We had two great presentations, a short one from...
2008-08-10
692 reads
Blog Posts
SSWUG SQL Server Virtual Conference III
There are many technical conferences available for SQL Server professionals, such as PASS. I have been lucky enough to go...
2008-08-10
1,034 reads
Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,308 reads
Changing Jobs - Should You?
I think most people fall into two groups, the ones that change jobs every year/every time they can make another...
2008-08-07
570 reads
Check Authentication Scheme (Kerberos) on SQL Server 2005
I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I...
2008-08-07
3,769 reads
SQL Server 2008 RTM - Community Thoughts & Resources
As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download...
2008-08-07
904 reads
Negotiating - It's Not All About Winning
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
Free SQL Sticker from Paul Nielsen
A little while ago Paul Nielsen tweeted about having free Euro-style SQL stickers. All one had to do was email...
2008-08-04
1,886 reads
Great Read on the Difficulty of Computer Security
The SANS Internet Storm Center has a great handler post about working at the Abuse department for an ISP:
Securing a...
2008-08-04
798 reads
Kindle Update - August
Apparently the Kindle is a great success, financially, for Amazon. That's good to hear, though I haven't made the decision...
2008-08-04
747 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