3.15Kw Solar PV System in Parker, Colorado
After waiting nearly seven months after I signed the contract, my little 3.15Kw grid-tied solar PV system was partially installed...
2010-06-05
1,339 reads
Blog Posts
Dachshunds on Patrol
I was home today, since my 3.15Kw solar PV system was being installed, so I took a few pictures of...
2010-06-05
804 reads
Alternating Group Colors and Alternating Row Colors
Alternating Group Colors and Alternating Row Colors
After posting my recent blog about Alternating Group Colors, I’ve been asked several times...
2010-06-04
1,358 reads
Authors Needed for the SQL Server Standard
As you may recall we relaunched this late last year, trying to fill a gap in both content on sqlpass.org...
2010-06-04
275 reads
Daily SQL Server 2008 New Feature – Day 16
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-04
519 reads
DTS and 2008
Have you ever been required to update your SQL Server environment and needed to test it? I know, rhetorical question....
2010-06-04
672 reads
Multitasking for the iPhone
I didn’t think that multitasking was a big deal for my iPhone when I got it. I’d had it on...
2010-06-04
653 reads
On the Road Again
I’m leaving today for SQL Saturday #22 in Pensacola, FL. I’ll be there tonight and tomorrow, leaving Sun morning for...
2010-06-04
357 reads
Prepping for SQL Saturday #22
In Pensacola, the Hampton Inn, and bandwidth sucks. I remember this from last year. Adding a few notes to my...
2010-06-04
348 reads
Presenting "Profiling: It's Okay in SQL Server" to Seacost SQL Server Users Group
I'm excited to be presenting Profiling: It's Okay in SQL Server to the Seacost SQL Server Users Group in Portsmouth,...
2010-06-04
300 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