Creating a Transaction Log Full Alert
When I was a kid, my mom had an old cookie-tin in which she kept her sewing supplies. On the...
2011-11-10
1,256 reads
Blog Posts
My Playbook For Putting On a SQLSaturday Part 3: Food
Feed Me Seymour!
Welcome to your number one cost. Every budget I’ve looked at so far food is the top expense...
2011-11-10
1,174 reads
Notes from SQLSaturday #86 in Tampa
Quick notes as it is already Thursday!
The speaker party went well. Well attended, I spent a lot of time chatting...
2011-11-10
552 reads
SQL People PASS Board interview is online–Please Comment!
Hey folks,
Welcome back to the PASS election process. The process moves forward with all of us candidates awaiting our ranking...
2011-11-10
868 reads
SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-10
1,254 reads
Stored Procedure Checklist
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate...
2011-11-10
2,998 reads
Tentative Meetings
A lot of my work right now involves going to meetings. A few of them are ones I host, a...
2011-11-10
621 reads
Book Review: Moneyball
With the movie coming out I realized somehow I’d missed reading Moneyball by Michael Lewis. It’s the story of how...
2011-11-09
692 reads
Eighty Logical Cores of Goodness!
I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will...
2011-11-09
1,831 reads
My Playbook For Putting On a SQLSaturday Part 2: Venue
Finding Your Venue
Sounds simple right?
It can be one of the most difficult things to do for something the size of...
2011-11-09
1,228 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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