A Guitar is Just a Piece of Wood
In my real-life I play guitar. Being an analytical sort-of-fella I found myself inhaling all the books, videos, advice, etc....
2010-06-08
662 reads
Blog Posts
BI at the Royal Canadian Mint - TechEd
The Royal Canadian Mint, in Ottawa, is located at a large castle. How cool is that? Would you want to...
2010-06-08
496 reads
Building an Energy Efficient Workstation
Over this past weekend, I decided to build a new general purpose workstation from parts, with a goal of getting...
2010-06-08
906 reads
Daily SQL Server 2008 New Feature – Day 18
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-08
460 reads
Data Compression
We have come to that time of month again – blog party. This time, the party is hosted by Jorge Segarra...
2010-06-08
1,036 reads
Impressions of My First Day at TechEd 2010
TechEd 2010 started today, June 7, and will run through Thursday, June 10, 2010. In the past TechEd has run...
2010-06-08
987 reads
More Details About Engine Improvements in SQL Server 2008 R2 (SQLTuesday)
This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite...
2010-06-08
1,742 reads
Overcoming Your Limits
As I age in years, I realize more and more how blessed I was to attend The Citadel, the Military...
2010-06-08
1,269 reads
PASS Summit 2010 Abstract Submissions
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
476 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
706 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