A New Word: Midding
midding – n. the tranquil pleasure of being near a gathering but not quite in it – hovering on the perimeter of a campfire, talking quietly outside a party,...
2024-08-23
80 reads
Blog Posts
One Month with the Dell Latitude 7450
It was just over a month ago that I got a Dell Latitude 7450 from our corporate IT group. It wasn’t my first choice, but as Redgate grows, they’re...
2024-08-23
28 reads
PostgreSQL and Instrumentation
I’m still learning PostgreSQL and one of the things I’ve been looking at a lot lately is instrumentation. What do I mean? Well, if you’re in SQL Server, think,...
2024-08-23 (first published: 2024-08-05)
158 reads
Reducing Meetings and Making Them More Productive
I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...
2024-08-23 (first published: 2024-08-09)
377 reads
2024-08-23
27 reads
Back to Syracuse for SQL Saturday
Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...
2024-08-22
37 reads
Don’t run CHKDSK while SQL Server is running
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
379 reads
Grouping by Object Type in SQL Compare
A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
215 reads
Building Studio in Public: Maintaining High Performance in Our Local Development App for Enhanced UX
In this post, we share the strategies and techniques we've implemented to ensure our Electron-based Studio app runs smoothly, delivering a high-performance user experience.
2024-08-20
29 reads
How to Excel in Board Meetings as a CFO
The post How to Excel in Board Meetings as a CFO appeared first on Joyful Craftsmen.
2024-08-20
24 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