The Data Center in New Orleans
There's a blog running at LiveJournal from one of the guys at directnic. There's evidently an ISP that is still...
2005-09-02
1,466 reads
Blog Posts
Blessed to live in the boring MidWest
The images on the TV news this morning were surreal. Hundereds of people dead, missing, homeless because of Katrina and...
2005-08-31
1,273 reads
Plagiarism
Seen this from Kevin Kline?
We went back and forth along with a few others this morning looking at
the many places,...
2005-08-30
1,608 reads
New Author Experience
I was just reading Andy Leonard's blog about being a new author and thought, hey, I need a blog, too!
I'm...
2005-08-29
1,326 reads
Online Protection
Grr, it's annoying, but it's a good thing.
After the ASP.NET errors, I ordered memory a few days ago from
Crucial.com. They...
2005-08-29
1,352 reads
Technology in Schools
There's an interesting series about technology in schools in Milwaukee
(part
1, part
2, and part
3) and it inspired me to an edditorial...
2005-08-24
1,814 reads
Out of Memory
We had a major out of memory error on ASP.NET this morning and I woke
up to a few dozen messages...
2005-08-23
1,380 reads
Two of 10
The top ten MS blogs were
listed in Redmond magazine and two were SQL Server guys. I do get quite
a few...
2005-08-19
1,381 reads
The More I Learn
the more I'm sure that I'm getting dumber with SQL Server.
This week I've been working on some QODs based...
2005-08-09
1,356 reads
Slip Up
I scan about 30 or 40 blogs these days, all from various SQL Server
people around the globe, and enter the...
2005-08-08
1,456 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