Do You Work for #1?
Someone recently asked me if I would work for a company if I didn’t believe in their products or services...
2011-07-28
648 reads
SQLAndy
Projects – Win Early
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even...
2011-07-26
675 reads
My Schedule for The Remainder of 2011
Just a few notes about things I’m doing over the next few months:
July 30 – Attending SQLSaturday Birmingham. I went to...
2011-07-25
577 reads
Trusts Are Transitive
If you’ve done networking in the MS world you know about the trust options between domains, and one of the...
2011-07-21
977 reads
Knowing Someone Makes a Difference-Part 2
How long does it take you to get comfortable at a new job. How long to figure out who is...
2011-07-20
911 reads
Knowing Someone Makes a Difference-Part 1
I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment,...
2011-07-19
616 reads
A Big Milestone-SQLSaturday #100
Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years...
2011-07-19
772 reads
PASS Update #60
I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...
2011-07-18
650 reads
Android Game: Slice-It
The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always...
2011-07-15
663 reads
Profiled on SQLPeople
I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going...
2011-07-14
528 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